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…
Author: Ryan Nielsen
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…
Kelverion Automation Portal Dispatcher
In this post we are going to take a look at how we integrated our Azure Automation account with the Automation Portal. We refer to this integration as our universal dispatcher, it handles initiating all of our self service requests and sending status updates when a request reaches a terminal status. Overview Once submitted, the…
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…