This DSC configuration assumes you have already created the gMSAs (group managed service accounts) with appropriate SPNs for your deployment, as well as the computer accounts used for the Windows failover cluster and the SQL always on group listener. The configuration also assumes you have a file share setup with the SQL install media and…
Category: PowerShell
Azure Update Management Hybrid Worker Script
I spent some time working with the Update Management feature of the Automation Account and noticed a few issues with the example scripts provided by Microsoft so I figured I would share my script with you here. Today we are using SCCM to automate the majority of our Windows server patching but I was interested…
Applying an Xsl transform in PowerShell
I recently worked on a project that required an Xsl stylesheet be applied to an encoded Xml data set. I wanted to avoid the use of external files or executables and was able to leverage the dotnet XmlWriter and XslCompiledTransform classes to accomplish this task. The runbook accepts two parameters, $Xml an Xml object containing…