Error 4064 Return When User Connects via SSMS

Views – 606

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…

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…

SQL Server Audit: Resources

I am doing some research on how to implement auditing of schema and security changes and will use this post to track notes…

Finding Suspect Pages

Here is where SQL Server stores any pages it has identified as suspect:

Views – 703