Skip to content

Instantly share code, notes, and snippets.


Sven Aelterman SvenAelterman

View GitHub Profile
SvenAelterman / Set-ClusterProbePort
Created Jun 30, 2021
Sets the cluster probe port for Windows Server Failover Cluster (WSFC) in Azure using a load balancer (traditional VNN, not needed for DNN). This is an enhancement to the script at
View Set-ClusterProbePort
Import-Module FailoverClusters
[int]$ClusterProbePort = 58888 # The probe port from the WSFCEndPointprobe in the Azure portal. This port must be different from the probe port for the availability group listener probe port.
# Retrieve info from the cluster
$ClusterNetworkName = (Get-ClusterNetwork).Name
$IPResource = (Get-ClusterResource | Where {($_.OwnerGroup -eq "Cluster Group" -And $_.ResourceType -eq "IP Address")})
$IPResourceName = $IPResource.Name
$ClusterCoreIP = ($IPResource | Get-ClusterParameter | Where { $_.Name -eq "Address" }).Value
View Azure-CopyManagedDisks.ps1
Written with version 2.8.0 of the Azure PowerShell Module
available from here
or run: Install-Module -Name Az -RequiredVersion 2.6.0 -AllowClobber
Migration instructions Azure.RM to Az -
# from
function Out-GridView
View Test-ManagedDiskDeleteSnapshot.azcli
# A valid password requires a length of 12 and at least one upper/lower/digit
# Generate a random string of 12 characters to make the names unique and to use as a password
while ! echo $random12 | grep -P "(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).*"
random12=$(head /dev/urandom | tr -dc a-zA-Z0-9 | fold -w 12 | head -n 1)

Keybase proof

I hereby claim:

  • I am svenaelterman on github.
  • I am svenaelterman ( on keybase.
  • I have a public key ASBZCmBChaaiWq4ThPJNCgWm7WQN4D3dTXM0fLujQ1z59go

To claim this, I am signing this object:

SvenAelterman / Configure-Sql2017RS.ps1
Last active May 24, 2021
PowerShell script to configure SQL Server 2017 Reporting Services
View Configure-Sql2017RS.ps1
function Get-ConfigSet()
return Get-WmiObject –namespace "root\Microsoft\SqlServer\ReportServer\RS_SSRS\v14\Admin" `
-class MSReportServer_ConfigurationSetting -ComputerName localhost
# Allow importing of sqlps module
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Force
SvenAelterman / FirewallRules.ps1
Last active Jul 2, 2017
Azure SQL DB PowerShell script for managing firewall rules
View FirewallRules.ps1
Select-AzureRmSubscription -SubscriptionName 'Your Subscription Name'
$RgName = 'Your Resource Group Name'
$SrvName = 'Your SQL Server Name'
$staticIps = "", ""
$ruleNames = "Rule 1", "Rule 2"
$i = 0
SvenAelterman / Response.json
Last active May 6, 2018
VS2017 Response.json for silent install
View Response.json
"installChannelUri": ".\\ChannelManifest.json",
"channelUri": "",
"installCatalogUri": ".\\Catalog.json",
"channelId": "VisualStudio.15.Release",
"productId": "Microsoft.VisualStudio.Product.Enterprise",
"includeRecommended": true,
"includeOptional": true,