Undocumented Changes in SQL Server 2022 and 2025: Series Contents

I compared the system catalogs of SQL Server 2019, 2022 and 2025 and checked each new object against Microsoft Learn. I found no documentation for 477 of 558 new objects in SQL Server 2022, and for 258 of 294 in SQL Server 2025.

A woman cartographer sketches a new coastline into the blank part of a large map by lantern light.

The first eight posts cover SQL Server 2022, the next ten cover SQL Server 2025, and the fourteen follow-ups test individual findings in more depth. New posts publish daily until 2026-10-28, and each entry becomes a link on its publish date.

SQL Server 2022

  1. I Could Not Find Documentation for Most of What SQL Server 2022 Added
  2. The 11 Configuration Options Added in SQL Server 2022, and Their Documentation
  3. Undocumented DMVs Added in SQL Server 2022
  4. Undocumented Wait Types Added in SQL Server 2022
  5. The sp_fido_* Procedures and the Rest of the FIDO Surface in SQL Server 2022
  6. sys.fn_filelog: An Undocumented Log-Reading Function Added in SQL Server 2022
  7. System Procedures and Views Whose Code Changed Between SQL Server 2019 and 2022
  8. New Error Messages in SQL Server 2022

SQL Server 2025

  1. I Could Not Find Documentation for Most of What SQL Server 2025 Added
  2. SQL Server 2025 Added 10 Configuration Options, and One Appeared After RTM
  3. LCK_M_SCH_A and LCK_M_SCH_C: New Lock Wait Types in SQL Server 2025
  4. Columnstore transcoder wait types in SQL Server 2025
  5. The sp_auto_tuning_* Procedures in SQL Server 2025
  6. System Procedures Whose Code Changed in SQL Server 2025
  7. System Objects Removed in SQL Server 2025
  8. Year-Suffixed System Views in SQL Server 2025
  9. sys.dm_hadr_internal_* and the Other Availability Group Additions in SQL Server 2025
  10. sp_dw_* and the Trident Procedures in SQL Server 2025 (available 2026-10-14)

Follow-ups

  1. Six SQL Server Log Reader Columns Missing After 2019 (available 2026-10-15)
  2. Replication Security Parameters Changed in SQL Server 2022 and 2025 (available 2026-10-16)
  3. EngineEdition Branches Inside System Procedures DBAs Already Call (available 2026-10-17)
  4. Reading the SQL Server Error Log Without sysadmin (available 2026-10-18)
  5. CDC Extended DDL Handling in SQL Server 2022 and 2025 (available 2026-10-19)
  6. How Approximate Are SQL Server 2022 XTP Hash Index Stats? (available 2026-10-20)
  7. Error Message Text Is Not an Alerting Contract (available 2026-10-21)
  8. Idle SQL Server Instances Still Accumulate Undocumented Wait Types (available 2026-10-22)
  9. Cloud Feature Wait Types in Boxed SQL Server (available 2026-10-23)
  10. What Is openrowset auto_create_statistics Connected To? (available 2026-10-24)
  11. SQL Server 2025 sp_columns Omits JSON and Vector Columns (available 2026-10-25)
  12. SQL Server 2025 Added Lock Modes to Extended Events (available 2026-10-26)
  13. SQL Server 2025 Has Automatic Index Management Parts, but I Could Not Turn CREATE_INDEX On (available 2026-10-27)
  14. Why SQL Server RTM Diffs Do Not Match CU Diffs (available 2026-10-28)

Questions or corrections are welcome on Bluesky or LinkedIn. See all series on this blog.