SQL Server Science

Technical Articles for the DBA / Developer

Home

The sp_auto_tuning_* Procedures in SQL Server 2025

2026-10-09 · by Hannah Vernon · in Internals

SQL Server 2025 ships new sp_auto_tuning procedures and internal create-index recommendation views, but I checked what they prove.

Columnstore transcoder wait types in SQL Server 2025

2026-10-08 · by Hannah Vernon · in Internals

SQL Server 2025 adds 25 columnstore transcoder wait types. I found the names, XE descriptions, and what Microsoft documents.

LCK_M_SCH_A and LCK_M_SCH_C: New Lock Wait Types in SQL Server 2025

2026-10-07 · by Hannah Vernon · in Internals

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

2026-10-06 · by Hannah Vernon · in Internals

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

2026-10-05 · by Hannah Vernon · in Internals

I diffed the SQL Server 2022 and 2025 system catalogs and checked 294 new items against Microsoft Learn. I found no documentation for 258.

New Error Messages in SQL Server 2022

2026-10-04 · by Hannah Vernon · in Internals

I diffed SQL Server 2019 and 2022 system messages, then checked which new 2022 message IDs appear in Microsoft Learn.

1 2 … 58 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science