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

Disabling the CEIP

What's the CEIP?

Shutdown without NOWAIT

[Video] Fragmentation Explained in 20 Minutes at SQLBits

What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it?

Service Broker Issues

Understanding the System Function FILEPROPERTY()

Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.

The Case for Patching

Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]