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

Choosing Filestream

A New SQL Server Vulnerability

A new vulnerability for SQL Server is covered by a number of patches this week.

The Browser Port

Changing the TDE Encryption