A friend could not delete, truncate or drop a table at 11 PM because of open transactions. Here is my quick and dirty way to identify blocking query.
What a Cumulative Update Actually Contains
Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.
SQL SERVER – Soft Delete Conversation – Your Opinion Needed
My soft delete post got great replies on both sides. Here are short abstracts from readers like Karen Lopez and Tyler Clendenin, and your input is welcome.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
An improved script to find row count in table for every table and spot the largest table in the database, now with the schema name, thanks to Ameena.
SQL SERVER – Best Practices for DBA Before Taking Vacation
Why is it so hard for a DBA before taking vacation to relax? For T-SQL Tuesday I share my best practices, starting with the hardest: do not think about your job.
Documenting a Server You Just Inherited
Documenting a server you just inherited starts with identity, databases, files, jobs, access, alerts, and tested recovery ownership.