Skip to content

Instantly share code, notes, and snippets.

View bjh1977's full-sized avatar

bjh1977

3 followers · 3 following
View GitHub Profile
@bjh1977
bjh1977 / blog-azure-pipelines-validate-vars.yml
Created May 26, 2021 13:16
pool:
vmImage: windows-latest
variables:
- template: vars-all.yml
- template: vars-dev.yml
steps:
# Use default for variable value (look for "$(..)"), but only for variable name "resourcename", and only warn
- task: validateVariablesTask@0
@bjh1977
bjh1977 / vars-dev.yml
Created May 26, 2021 12:37
variables:
environmentname: dev
resourcename: $(name)-$(locationshort)-$(environmentname)
@bjh1977
bjh1977 / YAML-reference-var-template.yml
Last active May 26, 2021 12:33
variables:
- template: azure-pipelines-vars.yml
@bjh1977
bjh1977 / YAML-simplest.yml
Last active May 26, 2021 12:33
variables:
myvar1: thisvalue
@bjh1977
bjh1977 / YAML-reference-var-group.yml
Last active May 26, 2021 12:32
variables:
- group: my-var-group
@bjh1977
bjh1977 / vars-all.yml
Created May 26, 2021 12:30
variables:
name: resource1
location: northeurope
@bjh1977
bjh1977 / CreateAADApplication.ps1
Last active October 25, 2020 05:33
Create AAD Application, Azure Key Vault, Azure Key Vault Key, Rights to Vault from Application (created for use with Extensible Key Management Using Azure Key Vault (SQL Server))
param (
[string]$Version = $( Read-Host "Input version" ),
[string]$DomainName = $( Read-Host "Input domain name" ),
[string]$ApplicationName = $( Read-Host "Input application name" )
)
$ApplicationURI = $("https://$DomainName/$ApplicationName")
@bjh1977
bjh1977 / arm_template.json
Created September 3, 2020 11:45
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"emailActionGroupName": {
"type": "string",
"metadata": {
"description": "Unique name (within the Resource Group) for the email Action group."
}
},
@bjh1977
bjh1977 / Get-SSISMismatchingPackageNames.ps1
Created April 15, 2020 09:53
# Point this at your SSIS project directory:
$SearchFolder = 'C:\Users\Joe.Bloggs\source\repos\SSIS_Test1\SSIS_Test1'
$Results = @()
Get-ChildItem $SearchFolder -Filter '*.dtsx' | ForEach-Object {
$FileContent = Get-Content $_.FullName -raw
$FileName = $_.BaseName
@bjh1977
bjh1977 / Get-ADLSGen2ACLS.ps1
Last active April 14, 2020 18:24
#
# More info here: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-directory-file-acl-powershell
#
Login-AzAccount
$ResourceGroupName = '<RESOURCE GROUP NAME>'
$StorageAccountName = '<STORAGE ACCOUNT NAME>'
$filesystemName = 'cont1'
$dirpath = "folderx/y/z1/"