Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

323 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / TeamSettingsTaskBoardColumns.sql
Created July 28, 2021 21:27
CREATE TABLE [dbo].[TeamSettingsTaskBoardColumns](
[TeamSettingsTaskBoardColumnsId] [int] IDENTITY(1,1),
[TeamProjectName] [varchar](100) NOT NULL,
[TeamName] [varchar](100) NOT NULL,
[TeamSettingsTaskBoardColumnName] [varchar](50) NOT NULL,
[TeamSettingsTaskBoardColumnOrder][TINYINT] NOT NULL,
CONSTRAINT [PK_TeamSettingsTaskBoardColumns] PRIMARY KEY CLUSTERED
(
[TeamSettingsTaskBoardColumnsId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
@vinijmoura
vinijmoura / MapTeamSettingsTaskBoardColumns.ps1
Last active July 28, 2021 21:25
Param
(
[string]$PAT,
[string]$Organization,
[string]$ConnStr
)
$SQLQuery = "DELETE FROM TeamSettingsTaskBoardColumnsWorkItemType"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / TeamSettingsBoards.sql
Created July 19, 2021 14:21
CREATE TABLE [dbo].[TeamSettingsBoards](
[TeamSettingBoardsId] [int] IDENTITY(1,1),
[TeamProjectName] [varchar](100) NOT NULL,
[TeamName] [varchar](100) NOT NULL,
[TeamBackLogLevel] [varchar](50) NOT NULL,
CONSTRAINT [PK_TeamSettingsBoards] PRIMARY KEY CLUSTERED
(
[TeamSettingBoardsId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
@vinijmoura
vinijmoura / MapTeamSettingsBoards.ps1
Created July 19, 2021 14:19
Param
(
[string]$PAT,
[string]$Organization,
[string]$ConnStr
)
$SQLQuery = "DELETE FROM TeamSettingsBoardLanes"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / TeamSettings.sql
Created July 14, 2021 14:04
CREATE TABLE [dbo].[TeamSettings](
[TeamSettingId] [int] IDENTITY(1,1),
[TeamProjectName] [varchar](100) NOT NULL,
[TeamName] [varchar](100) NOT NULL,
[TeamWorkingWithBugs] [varchar](20) NOT NULL,
CONSTRAINT [PK_TeamSettings] PRIMARY KEY CLUSTERED
(
[TeamSettingId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
@vinijmoura
vinijmoura / MapTeamSettings.ps1
Created July 14, 2021 14:03
Param
(
[string]$PAT,
[string]$Organization,
[string]$ConnStr
)
$SQLQuery = "DELETE FROM TeamSettingsBackLogLevels"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / EnvironmentsApprovalsChecks.sql
Created July 7, 2021 19:32
CREATE TABLE [dbo].[EnvironmentsApprovalsChecks](
[TeamProjectName] [varchar](100) NULL,
[EnvironmentId] [int] NULL,
[EnvironmentName] [varchar](150) NULL,
[EnvironmentCheckName] [varchar](100) NULL,
[EnvironmentCheckDisplayName] [varchar](100) NULL
) ON [PRIMARY]
GO
@vinijmoura
vinijmoura / MapEnvironmentsApprovalsChecks.ps1
Created July 7, 2021 19:30
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE EnvironmentsApprovalsChecks"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ReposAheadBehind.sql
Created June 30, 2021 17:39
CREATE TABLE [dbo].[ReposAheadBehind](
[TeamProjectName] [varchar](100) NULL,
[RepositoryId] [varchar](40) NULL,
[RepositoryName] [varchar](150) NULL,
[RepositoryBranchName] [nvarchar](max) NULL,
[RepositoryBranchAheadCount] [int] NULL,
[RepositoryBranchBehindCount] [int] NULL,
[RepositoryBranchIsBaseVersion] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
@vinijmoura
vinijmoura / ListReposAheadBehind.ps1
Created June 30, 2021 17:38
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ReposAheadBehind"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr