Return Top 50 Queries by Average CPU
When your SQL Server is running hot, knowing which queries are responsible is the first step. This script uses DMVs to surface the top 50 queries by average CPU time.
Read article →
How to create a SQL Server Database Snapshot
A SQL Server database snapshot captures your database at a point in time, giving you a fast rollback option before risky changes with minimal overhead.
Read article →
Script to change ALL Database Objects back to dbo
Wrong schema ownership breaks vendor upgrades and migrations. Use this script to reassign all SQL Server database objects back to dbo quickly and reliably.
Read article →
How to Attach a Database with No Log File
Learn how to attach a SQL Server database when the log file is missing. Two methods covered, including the modern replacement for the deprecated sp_attach_single_file_db procedure.
Read article →
How to Kill All SQL Server Database Connections
Clear all active SQL Server connections fast using SINGLE_USER mode or a scripted kill loop. Covers when to use each method and what to watch out for.
Read article →
How to Search every Table in a SQL Database for a String
Learn how to build a stored procedure that searches every table and character-based column in a SQL Server database for a specific string value.
Read article →
How to update all objects in a table to DBO
Fix broken SQL Server permission chains by transferring all object ownership to DBO. Covers sp_changeobjectowner, ALTER AUTHORIZATION and production gotchas.
Read article →
How to Check Authentication Method into SQL Server (SharePoint)
Query sys.dm_exec_connections to instantly identify whether SharePoint is authenticating to SQL Server via Kerberos or NTLM, and resolve SSRS integrated mode failures.
Read article →
SQL Server Migration Checklist
A comprehensive SQL Server migration checklist to ensure nothing gets left behind, from data files and logins to agent jobs and linked servers.
Read article →
How to Tune Maximum Degree of Parallelism (MAXDOP)
Getting MAXDOP wrong is one of the most common causes of SQL Server performance problems. Learn how to choose the right setting for your workload.
Read article →
SQL Server 2012 Encryption Key Hierarchy
SQL Server uses a layered key hierarchy to protect data at rest. Learn how each level works, why it matters for recovery, and how it supports compliance requirements.
Read article →
How to Find a Blocking Process
Blocking processes can cascade and cripple SQL Server performance within minutes. Learn how to find them quickly and act on what you find.
Read article →