Identify open transactions with modern SQL Server DMVs, inspect sleeping owners and recent SQL, and verify a two-window transaction demo.
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.
Rank Your Work: Only One Task Can Be Number One
Rank your work every morning, and give each task its own place. A priority list with five items marked high is a pile, not a plan. This post shows how to number your tasks, break ties with a rule and re-rank when something real arrives.
SQL SERVER – FIX – Error: Alter failed for Server ‘Server Name’ in Check Integrity task
My CHECKDB maintenance plan failed with Alter failed for Server in the Check Integrity task. Profiler led me to sp_configure and a recovery interval problem.
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions
A banking DBA quizzed me about TDE on SQL Server 2008 R2. Here are the Transparent Data Encryption questions and answers from that 30 minute chat.
SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?
Your SPID shows KILLED/ROLLBACK and never seems to finish. Here is what that state means, why SQL Server sometimes cannot undo the work and what to do next.