Nine SQL Server Backup tips every DBA should follow, starting with the simplest one: never keep backups on the same physical drive as the database files.
SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
Worried about your database while on vacation? John Sterrett shows how Policy Based Management helps a proactive DBA catch unwanted changes.
SQL SERVER – Check for Database Integrity – Notes from the Field #011
In this Notes from the Field episode, Tim explains why you should check database integrity often, so corruption is caught before it is too late.
SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010
Weak passwords are like a key under the door mat. Brian Kelley explains what auditors look for around passwords and exceptions in database security.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
John Sterrett shows how Central Management Server lets a DBA run the same query on many SQL Server instances at once, a handy tool for proactive DBAs.
SQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008
Tuned every query and SQL Server is still slow? David Klee shows a systematic way to improve overall SQL Server performance, not just query performance.
Recovering a Deleted Agent Job From an msdb Backup
Someone deleted the wrong Agent job. Here is how to get it back from an msdb backup without touching the live msdb.