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.
The 11 Configuration Options Added in SQL Server 2022, and Their Documentation
I checked the 11 SQL Server 2022 configuration options added after SQL Server 2019 against sys.configurations and Microsoft Learn.