This SQL logic will check to see if the instance you are running it on is the Primary in an AlwaysOn configuration.
Get All Compatability Levels Per Database
Here’s some quick SQL Logic to return all the Compatability Modes per Database.
Automatically Backup All Databases Without Cursors
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 […]
Recent Comments