By Other People
Using Pester for Infrastructure Tests
Blog Entry by Rob Sewell with link to conference talk
Azure RM Templates
Cheat sheet for retrieving output values from ARM Resources by Justin Yoo
gavincampbell
/ DispDev2019Notes.md
Last active Oct 10, 2019
Resources for talk on Disposable Development Environments from SQL Relay 2019
gavincampbell
/ WinRM-HTTPS.ps1
Created Feb 19, 2019
— forked from TechIsCool/WinRM-HTTPS.ps1
A simple Powershell WinRM-HTTPs setup
View WinRM-HTTPS.ps1
| Write-Output "Disabling WinRM over HTTP..." | |
| Disable-NetFirewallRule -Name "WINRM-HTTP-In-TCP" | |
| Disable-NetFirewallRule -Name "WINRM-HTTP-In-TCP-PUBLIC" | |
| Get-ChildItem WSMan:\Localhost\listener | Remove-Item -Recurse | |
| Write-Output "Configuring WinRM for HTTPS..." | |
| Set-Item -Path WSMan:\LocalHost\MaxTimeoutms -Value '1800000' | |
| Set-Item -Path WSMan:\LocalHost\Shell\MaxMemoryPerShellMB -Value '1024' | |
| Set-Item -Path WSMan:\LocalHost\Service\AllowUnencrypted -Value 'false' | |
| Set-Item -Path WSMan:\LocalHost\Service\Auth\Basic -Value 'true' |
gavincampbell
/ InstallHaProxy.sh
Last active Nov 23, 2018
— forked from jrouleau/InstallHaProxy.sh
Amazon Linux AMI Install HAProxy From Source (1.7.0 release pre configured). chmod +x InstallHaProxy.sh then ./InstallHaProxy.sh
View InstallHaProxy.sh
| #!/bin/bash | |
| ### VARIABLES ### | |
| PRE_PACK="openssl-devel pcre-devel make gcc" | |
| VER="1.8.14" | |
| # Setup Colours | |
| black='\E[30;40m' | |
| red='\E[31;40m' | |
| green='\E[32;40m' |
gavincampbell
/ packer-iam-policy.json
Last active Oct 9, 2018
AWS policy for Packer including S3 access
View packer-iam-policy.json
| { | |
| "Version": "2012-10-17", | |
| "Statement": [ | |
| { | |
| "Sid": "VisualEditor0", | |
| "Effect": "Allow", | |
| "Action": [ | |
| "ec2:AttachVolume", | |
| "ec2:AuthorizeSecurityGroupIngress", | |
| "ec2:DeregisterImage", |
View misc.ps1
| #Creating a pscredential from a username:password pair in a single line: | |
| $Creds = New-Object System.Management.Automation.PSCredential ($User, $(ConvertTo-SecureString $Password -AsPlainText -Force)) | |
| #Self signed wildcard certificate | |
| New-SelfSignedCertificate -Subject *.my.domain -DnsName my.domain, *.my.domain -CertStoreLocation Cert:\LocalMachine\My -NotAfter (Get-Date).AddYears(10) | |
| # trusting the PS gallery so we can install packages unattended, e.g. for DSC | |
| Install-PackageProvider NuGet -Force -Scope CurrentUser | |
| Import-PackageProvider NuGet -Force | |
| Set-PSRepository -Name PSGallery -InstallationPolicy Trusted |
gavincampbell
/ DeleteSpecifiedResourceGroup.ps1
Created Sep 8, 2017
Azure Automation Runbook to parse a VSTS merge commit hook and delete the resource group corresponding to the source branch identified therein.
View DeleteSpecifiedResourceGroup.ps1
| [CmdletBinding()] | |
| param([object]$WebhookData) | |
| if ($WebhookData){ | |
| $requestBody = (ConvertFrom-Json -InputObject $WebhookData.RequestBody) | |
| $refspec = $requestBody.resource.SourceRefName | |
| $branchName = $requestBody.resource.SourceRefName.Split("/")[-1] |
gavincampbell
/ Vagrantfile
Last active Jun 17, 2017
Vagrantfile for SQL Server on Linux with WideWorldImporters sample database and tSQLt framework included
View Vagrantfile
| Vagrant.configure("2") do |config| | |
| config.vm.box = "centos/7" | |
| config.vm.network "forwarded_port", guest:1433, host:1433 | |
| config.vm.provider :libvirt do |libvirt| | |
| libvirt.memory = "4096" | |
| end | |
| config.vm.provision "shell", | |
| inline: <<-SHELL |
View Jenkinsfile
| node{ | |
| checkout scm | |
| def the_one_to_run | |
| if (env.BRANCH_NAME == "master"){ | |
| the_one_to_run = load 'master.groovy' | |
| } | |
| else{ | |
| the_one_to_run = load 'not-master.groovy' | |
| } |
View test insert image
| IF NOT EXISTS (SELECT * FROM testIMAGE where ID = 2) | |
| BEGIN | |
| INSERT INTO testIMage VALUES | |
| (2, | |
| 0x89504E470D0A1A0A0000000D49484452000001480000014808060000003214673300000006624B474400FF00FF00FFA0BDA793000000097048597300000048000000480046C96B3E000038034944415478DAED9D779C5D55B9B09F5DCE39FBF439D36B32E93D19121242092D14814B0B28E5A2A05CAEE2FDB8D8BB5851E4AAD7AE572F227A45400101E98890400209E999F4C964D233BD9CDEF6F7C749A4972453CEDEFB7D7E3FFF904C3267AFBDD673DEB5D6BBDEA59BA66922088220BC095D9A4010044104290882208214044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110410A822008224841100411A4200882085210044104290882208214044110410A822088200541104490822008224841100411A4200882085210044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110410A82208820054110449082200882085210044104290882208214044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110449023409E54324F3C6792CE9B28AFF913435308E92AB85578DD9FD88B64264B2A9B239DCD9248675194B77956D304452168B |
gavincampbell
/ Jenkinsfile
Created Apr 4, 2017
View Jenkinsfile
| node { | |
| stage('git checkout'){ | |
| git 'file:///C:/Projects/Chinook.JenkinsDemo' | |
| } | |
| stage('Build Dacpac from SQLProj'){ | |
| bat "\"${tool name: 'Default', type: 'msbuild'}\" /p:Configuration=Release" | |
| stash includes: 'Chinook.JenkinsDemo\\bin\\Release\\Chinook.JenkinsDemo.dacpac', name: 'theDacpac' | |
| } | |
| stage('Deploy Dacpac to SQL Server') | |
| { |
NewerOlder