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') | |
| { |
gavincampbell
/ Install-Latest-Pester.ps1
Created Feb 28, 2017
Powershell script to download and extract the latest version of [Pester](https://github.com/pester/Pester)
View Install-Latest-Pester.ps1
| $latestRelease = Invoke-WebRequest https://github.com/pester/Pester/releases/latest -Headers @{"Accept"="application/json"} | |
| $json = $latestRelease.Content | ConvertFrom-Json | |
| $latestVersion = $json.tag_name | |
| $url = "https://github.com/pester/Pester/archive/$latestVersion.zip" | |
| $download_path = "$env:USERPROFILE\Downloads\pester-master.zip" | |
| Invoke-WebRequest -Uri $url -OutFile $download_path | |
| Get-Item $download_path | Unblock-File |
NewerOlder