Trigger Archaeology: Mapping Nested and Recursive Trigger Chains
Map which SQL Server trigger writes to which table before you change a legacy schema, and see what happens at the 32-level nesting limit.
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.
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.
System Procedures Whose Code Changed in SQL Server 2025
I diffed 212 changed system module definitions in SQL Server 2025 and found caller-visible changes in procedures DBAs still use.
System Procedures and Views Whose Code Changed Between SQL Server 2019 and 2022
I diffed 217 changed system module definitions between SQL Server 2019 and 2022 and found caller-visible changes in procedures DBAs use.
INTERSECT and EXCEPT: Where NULL Finally Behaves
INTERSECT and EXCEPT treat NULL as equal, the one place NULL comparison behaves as expected. Use them for NULL-safe row comparison.