This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (blog). The topic of choice is a fantastic one, its simply just to teach something new.
So let’s do this.
Our current windows patching process is manual. On a given weekend every month, we log into the inactive node of the production cluster, install the windows patches and then fail over the cluster. Making the newly patched server the active node of the cluster.