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.
SQL SERVER – How to Enable or Disable All the Triggers on a Table and Database?
One line commands to enable or disable all the triggers on a table, a database or the whole server using ENABLE TRIGGER ALL and DISABLE TRIGGER ALL.
SQL SERVER – Configure the Backup Compression Default Server Configuration Option
Backup compression is off by default. Here is how to view or configure the backup compression default server option using SSMS or Transact-SQL.
SQL SERVER – What’s the Difference between ROW_NUMBER, RANK, and DENSE_RANK? – Notes from the Field #096
Kathi Kellenberger explains the difference between ROW_NUMBER, RANK, and DENSE_RANK, three T-SQL window functions, in Notes from the Field #096.