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.
sp_dw_* and the Trident Procedures in SQL Server 2025
SQL Server 2025 adds more sp_dw and Trident system surface, including procedures, wait types, Extended Events, and messages.
sys.dm_hadr_internal_* and the Other Availability Group Additions in SQL Server 2025
SQL Server 2025 adds internal HADR views, documented DMV columns, AG configuration options, wait types, XE events, and messages.
Year-Suffixed System Views in SQL Server 2025
SQL Server 2025 adds year-suffixed sys views for Query Store, external tables, principals and columns. They may be compatibility layers.