LCK_M_SCH_A and LCK_M_SCH_C: New Lock Wait Types in SQL Server 2025
SQL Server 2025 adds LCK_M_SCH_A and LCK_M_SCH_C wait types. I checked the wait list, XE maps, Microsoft docs and local wait stats.
SQL Server 2025 Added 10 Configuration Options, and One Appeared After RTM
I checked the SQL Server 2025 configuration options added after SQL Server 2022 against sys.configurations and Microsoft Learn.
I Could Not Find Documentation for Most of What SQL Server 2025 Added
I diffed the SQL Server 2022 and 2025 system catalogs and checked 294 new items against Microsoft Learn. I found no documentation for 258.
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.