Who dropped table or database objects on your server? I show how the default trace, which runs in every SQL Server install, can answer these who questions.
SQL SERVER – How to View Objects in mssqlsystemresource System Database?
Facts and myths about the hidden mssqlsystemresource database, database ID 32768, and how you can view objects in mssqlsystemresource if you need to.
Volunteering in the Data Community
Volunteering in the data community can mean welcoming people, reviewing talks, answering questions, or organizing events within a clear time budget.
Hey DBA – Do You Study Mistakes? – Notes from the Field #097
A scare with a chainsaw got Mike Walsh thinking. In Notes from the Field #097, he explains why DBAs should study their mistakes and learn from each one.
SQL SERVER – Introduction to Disk Systems
My learning notes on disk systems for SQL Server data and log files, starting with what SCSI means and how it compares to IDE drives.
SQL SERVER – Column Alias and Usage in Where Clause
You can ORDER BY a column alias, so why not use it in WHERE? A simple example that shows how SQL Server assigns a Column Alias and where it is in scope.
SQL SERVER – Identify Time Between Backups Calculation
A DBA whose latest tape backup was corrupt wanted to know the possible data loss. This script uses backup history to calculate the time between backups.