AZPosh: Keeping SQL clusters active After Patching
Presenter(s):Andrew Mora
Use case: We are still using Windows FCI (Fail Over Cluster Instances) during patch windows the Network Operations Center (NOC) will often reboot servers and forget to move the SQL Server resources back to the node they just rebooted. We needed a way to allow the NOC to find all the Windows FIC’s that were running more than ( 1 ) SQL role on a single physical server.
Approach: since we needed a way to query the FCI names from Active directory we decided to use PowerShell vs TSQL. This session will be about how this was accomplished using PowerShell
On this page of the site you can watch the video online AZPosh: Keeping SQL clusters active After Patching with a duration of hours minute second in good quality, which was uploaded by the user AZ PowerShell User Group 01 January 1970, share the link with friends and acquaintances, this video has already been watched 65 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
