Error Message Text Is Not an Alerting Contract

· by · in

SQL Server message text changes between versions. Key alerts on message ID and severity, then diff sys.messages before an upgrade.

How Approximate Are SQL Server 2022 XTP Hash Index Stats?

· by · in

I tested SQL Server’s undocumented XTP hash index approximation function against the documented DMV on one scratch table.

CDC Extended DDL Handling in SQL Server 2022 and 2025

· by · in

SQL Server 2022 added an unsupported CDC extended DDL option. I tested the parameter, metadata function and 2025 procedure changes.

Reading the SQL Server Error Log Without sysadmin

· by · in

SQL Server 2022 added VIEW ANY ERROR LOG. I tested the newer permission against sp_readerrorlog and sp_enumerrorlogs.

EngineEdition Branches Inside System Procedures DBAs Already Call

· by · in

SQL Server 2025 adds EngineEdition 12 branches to familiar system procedures, and sp_spaceused can delegate to a FIDO path.

Replication Security Parameters Changed in SQL Server 2022 and 2025

· by · in

I parsed replication procedure signatures across SQL Server 2019, 2022 and 2025 to find security and TLS parameter changes.