SQL Server Science

Technical Articles for the DBA / Developer

Home

sys.dm_hadr_internal_* and the Other Availability Group Additions in SQL Server 2025

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

SQL Server 2025 adds internal HADR views, documented DMV columns, AG configuration options, wait types, XE events, and messages.

Year-Suffixed System Views in SQL Server 2025

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

SQL Server 2025 adds year-suffixed sys views for Query Store, external tables, principals and columns. They may be compatibility layers.

System Objects Removed in SQL Server 2025

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

I compared SQL Server 2022 CU25 with SQL Server 2025 CU9 and found removed system objects, columns, wait types, XE events and messages.

System Procedures Whose Code Changed in SQL Server 2025

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

I diffed 212 changed system module definitions in SQL Server 2025 and found caller-visible changes in procedures DBAs still use.

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.

1 2 … 59 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
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
  • 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