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.
sys.fn_filelog: An Undocumented Log-Reading Function Added in SQL Server 2022
SQL Server 2022 added sys.fn_filelog, an undocumented log reader with the same output columns as fn_dblog and fn_dump_dblog.
The sp_fido_* Procedures and the Rest of the FIDO Surface in SQL Server 2022
SQL Server 2022 added 25 FIDO-named procedures and a larger FIDO XE surface, so I mapped what is visible without executing them.
Undocumented Wait Types Added in SQL Server 2022
SQL Server 2022 added 353 wait types. I grouped them by family and found 339 without a public description.
Undocumented DMVs Added in SQL Server 2022
A closer look at undocumented SQL Server 2022 DMVs and functions for request phases, XTP hash indexes, CDC, governance and retired internals.