Vinicius Moura vinijmoura

Microsoft MVP on Developer Technologies focused in DevOps

vinijmoura / github-changelog-weekly.yml

Created March 31, 2026 17:29

vinijmoura / doc-generator.yml

Created March 31, 2026 17:08

vinijmoura / gist:0d5500cc8db5d15f2ac77cf7c36ed940

Created March 18, 2024 23:33

	clear
	$PAT=''
	$Organization=''
	$Project=""
	$VariableGroup=""

	$AzureDevOpsAuthenicationHeader = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(":$($PAT)")) }
	$UriOrganization = "https://dev.azure.com/$($Organization)/"

	$uriVariableGroup = "$($UriOrganization)$($Project)/_apis/distributedtask/variablegroups?groupName=$($VariableGroup)&queryOrder=IdDescending&api-version=7.1-preview.2"

vinijmoura / EnvironmentsApprovalsNames.sql

Created July 24, 2023 22:24

	CREATE TABLE [dbo].[EnvironmentsApprovalsNames](
	[TeamProjectName] [varchar](100) NULL,
	[EnvironmentId] [int] NULL,
	[EnvironmentName] [varchar](150) NULL,
	[ApproverUniqueName] [varchar](100) NULL,
	[ApproverDisplayName] [varchar](100) NULL
	) ON [PRIMARY]
	GO

vinijmoura / MapEnvironmentsApprovalsNames.ps1

Created July 24, 2023 22:22

	Param
	(
	[string]$PAT,
	[string]$Organization,
	[string]$Connstr
	)

	$SQLQuery = "TRUNCATE TABLE EnvironmentsApprovalsNames"
	Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura / Variables.sql

Created March 14, 2023 13:20

	CREATE TABLE [dbo].[Organization](
	[OrganizationId] [varchar](20) NOT NULL,
	[OrganizationName] [varchar](100) NOT NULL,
	CONSTRAINT [PK_Organization] PRIMARY KEY CLUSTERED
	(
	[OrganizationId] ASC
	)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
	)
	GO

vinijmoura / MapVariables.ps1

Created March 14, 2023 13:19

	Param
	(
	[string]$PAT,
	[string]$Organization,
	[string]$Connstr
	)

	$base64Token = [System.Convert]::ToBase64String([char[]]$PAT)
	$headers = @{Authorization = 'Basic {0}' -f $base64Token};
	$UriOrganization = "https://api.github.com/orgs/$($organization)"

vinijmoura / BuildApprovalsRequired.sql

Last active February 24, 2023 18:19

	CREATE TABLE [dbo].[BuildApprovalsRequired](
	[TeamProjectName] [varchar](100) NULL,
	[BuildDefinitionId] [varchar](40) NULL,
	[BuildDefinitionName] [varchar](150) NULL,
	[BuildId] [varchar](20) NULL,
	[BuildNumber] [varchar](100) NULL,
	[BuildLink] [nvarchar](MAX) NULL,
	[BuildStageName] [varchar](100) NULL,
	[BuildEnvironmentName] [varchar](100) NULL
	)

vinijmoura / YAMLApprovalsActionRequired.ps1

Created February 24, 2023 17:40

	Param
	(
	[string]$PAT,
	[string]$Organization,
	[string]$Connstr
	)

	$SQLQuery = "TRUNCATE TABLE BuildApprovalsRequired"
	Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura / DeploymentGroupsMachinesCapabilities.sql

Created September 30, 2022 18:10

	CREATE TABLE [dbo].[DeploymentGroupsMachinesCapabilities](
	[TeamProjectName] [varchar](100) NULL,
	[DeploymentGroupName] [varchar](100) NULL,
	[MachineName] [varchar](150) NULL,
	[CapabilityName] [varchar](150) NULL,
	[CapabilityValue] [nvarchar](MAX) NULL

	) ON [PRIMARY]
	GO