Arizona PowerShell Users Group August 2019

Topic: Keeping SQL clusters active After Patching

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

About our Speaker:

Andrew Mora
Andrew Mora is a SQL Server DBA by trade now spending time in a management role. The focus of our effort over the next year will be to automate as many tasks as possible using powershell.

If you are interested in joining remotely Browse to our Youtube Channel and look for our speaker:

If you plan on being OnSite please sign up via EventBrite

Tuesday August 6th, from 5:30 pm – 7 pm Arizona Time ( first 30 minutes reserved for speaker setup and for attendees to  network).  Speaker should start around 6 pm.

Tek Systems 
2625 South Plaza Drive
Suite #301 : 3rd Floor in the main conference room.
Tempe, AZ

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s