Error 8657 and 8658 appear when a query or columnstore index build needs more memory than its Resource Governor workload group allows. Here is the fix.
SQL SERVER – Script – When/Who did Auto Grow for the Database?
A reader saw the database file grow every day with very few users. Here is a script to find when auto grow happened for a database and who triggered it.
SQL SERVER – How Can Deadlock Happen on Same Table?
How can deadlock happen on same table? A World Chess Championship match inspired this post, where I walk through how two sessions can block each other.
Reads per Execution: Ranking Queries by Average I/O
The query with the most total reads is not always the one to tune first. Here is how to rank by cost per call and read the spread.
SQL SERVER – FIX – Error 3201 – Cannot open backup device. Operating system error 3
BACKUP DATABASE failed with Error 3201, cannot open backup device, operating system error 3. The cause was a missing default folder. Here is the fix.
SQL SERVER – The Basics of the SSIS Script Task – Notes from the Field #065
SSIS expert Andy Leonard explains the basics of the SSIS Script Task, where to start with it, and how a new developer can learn to configure and use it.
Finding Near-Duplicate Rows With REGEXP_REPLACE
Find near-duplicate rows with SQL Server 2025 normalization, group matching labels, rank survivors, and preserve originals for review.