SQL Server 2016 Basic Availability Group with non-default endpoint port

SQL Server 2016 Basic Availability Group with non-default endpoint port

Antecedent During one of my latest implementations I configured a multi-subnet SQL Basic Availability Group (BAG) configuration in Azure. I also wrote a blog about that what you can read HERE. After that configuration, I was thinking about how to deploy 2 BAGs in the same SQL Instance using separate ports. As we know there […]

JSON Azure deployment: Create PowerShell script during CSE to allow scripting to continue after a reboot

JSON Azure deployment: Create PowerShell script during CSE to allow scripting to continue after a reboot

While working on a JSON Azure deployment we came across a scenario where we were needing to script after a reboot from the Custom Script Extension (CSE). This can’t be done out of the box as once the server reboots, the CSE module stops running. To work around this we used the RunOnce, and AutoAdminLogon […]

PowerShell problems when setting failover SCOM Management Servers

PowerShell problems when setting failover SCOM Management Servers

I have recently been writing a couple of System Center Operations Manager maintenance scripts to configure failover and came across a PowerShell issue that I had not realised before. The script I was to loop through all of the agents reporting to one of my management servers and set the secondary management server to the […]