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 […]

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.

Configurations that take effect on RECONFIGURE

Linked Servers: a Peek Behind the Curtain

Learn how a linked server caused an issue with Gallium Data.

ALTER Transactions