Monthly Archives: January 2012

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database. ¬†Since most folks probably don’t have a routine … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits | Leave a comment

SQL Server Login Auditing

In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins.¬† It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication, Tibits | 6 Comments