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' |
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' |
View CreateDateAzureSQLDW.sql
--Creates a table called Dim.Calendar. Change the table name on line 69. Change date range on line 2. | |
DECLARE @StartDate DATE = '20000101', @NumberOfYears INT = 30; | |
-- prevent set or regional settings from interfering with | |
-- interpretation of dates / literals | |
CREATE TABLE #dimdate | |
( | |
[date] DATE, | |
[day] tinyint, |