Encrypting SQL Server Database Backups

We all go to great lengths to make sure that our databases are secure (or at least I really hope that we do), we make sure that only authorised users have access and then only to the databases and levels that they need.  We're careful that all our passwords conform to crazy complexity rules.  We're... Continue Reading →

UNDERCOVER TOOLBOX: sp_WhatsMyAG

Here's a quick one for you.  If you happen to be managing SQL Servers with a large number of databases and availability groups, it can sometimes be difficult to keep track of which database belongs to which availability group. sp_WhatsMyAG will tell you just that.  You can either provide it with the database name and... Continue Reading →

Create a website or blog at WordPress.com

Up ↑