This SQL logic will check to see if the instance you are running it on is the Primary in an AlwaysOn configuration.
Here’s some quick SQL Logic to return all the Compatability Modes per Database.
The following SQL logic will perform the following actions. 1. Automatically create a backup folder structure on a network share ( you just provide the share name ) 2. Automatically delete old […]