SQL Server 2022 Log File IFI

Readable SQLCMD Results

Waitfor Threads

Pausing an Index

Find Invalid Objects in SQL Server

This article shows how you can find which objects in your database might not be valid after schema changes.

The Top SQL Server Engine Errors

The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.

The Struggles to Keep Up with Growing Systems

The growing complexity of environments can cause struggles for many IT professionals. However, we need to ensure we are not making things worse.

The Query Store Capture Mode

Shutdown without NOWAIT

The Lock Escalation Threshold – Part 1

This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.