July 2025

Understanding TDE in SQL Server: A Quick Guide Transparent Data Encryption (TDE) is a security feature in Microsoft SQL Server designed to protect data at… Read More »What is TDE

How Vital Is Your SQL Server Data? A Guide to Preparedness SQL Server data forms the backbone of countless organizations, powering critical applications, storing sensitive… Read More »How Vital Is Your SQL Server Data? Are You Prepared?

Join Types Hi there, I’m Steve Stedman, and I’m excited to share with you my SQL Server course focused on SQL Server Joins, available at… Read More »SQL School: Master SQL Server JOINS with My JOINS Course

Cross DB Ownership Chaining is a feature of SQL Server that allows one database to access objects in another database, even if the two databases… Read More »Securing SQL Server: Cross DB Ownership Chaining

Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as… Read More »SQL Server DBCC Commands: Shrink Errors

The integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. My comprehensive approach… Read More »SQL Server Corruption: NOLOCK and Corruption

What SQL Server TDE Doesn’t Do: Clearing Up Common Misconceptions Transparent Data Encryption (TDE) in SQL Server is a powerful feature designed to protect data… Read More »What TDE Does Not Do

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU20 for 2022 (16.0.4205.1 – July 2025) CU19 + GDR (16.0.4200.1 – July… Read More »New SQL Update from Microsoft

Enabling Transparent Data Encryption (TDE) on SQL Server is critical for safeguarding sensitive data by encrypting the database files at rest, ensuring that data remains… Read More »Enabling TDE in SQL Server