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.

DBCC UPDATEUSAGE

Clearing Session Cache

Cleaning Tables

Getting More Information From the String or Binary Data Truncated Error

Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.