Expiring Database Backups

The “Backup set will Expire” option is used to indicate how long a backup should be prevented from being over written by another…

PASS 2015 – Seattle WA – Day 3

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

Display all SQL Server’s Undocumented DBCC Commands

To display SQL Server’s undocumented commands, you can run the following T-SQL:

(use at your own risk, and not on a production…

Using the DAC (Dedicated Admin Connection) in SQL Server

From Kendra’s blog: There’s always a catch. You many need to get firewall ports opened as well, depending on your environment and…