A roundup of my earlier posts on blocking, plus a SQL script using sys.dm_os_waiting_tasks to identify the blocking chain and see who is waiting for whom.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table
You can use the VALUES clause to build a small dataset like a table without creating one. Here is the syntax, which works from SQL Server 2008 onwards.
Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Diagnose low disk pressure in tempdb before moving files, inspect transaction and allocation usage, and plan a verified Windows restart.
SQL SERVER – Secure by Default – The Mantra
A SQLSaturday discussion led to this secure-by-default reminder: restrict application permissions, protect connections and inspect access before changing it.
SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level
Read Committed Snapshot and Snapshot Isolation level sound alike but work differently. I explain the difference and show the ALTER DATABASE command for each.
SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087
Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.
SQL SERVER – Steps to Generate Windows Cluster Log?
When a SQL Server resource will not come online in a failover cluster, I check the cluster log. Here are the steps to generate the cluster log on Windows.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.