How Approximate Are SQL Server 2022 XTP Hash Index Stats?
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
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
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
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
I parsed replication procedure signatures across SQL Server 2019, 2022 and 2025 to find security and TLS parameter changes.
Six SQL Server Log Reader Columns Missing After 2019
Tested SQL Server 2022 and 2025 builds have six fewer fn_dblog and fn_dump_dblog columns than SQL Server 2019.