SQL Server Science

Technical Articles for the DBA / Developer

Home

Replication Security Parameters Changed in SQL Server 2022 and 2025

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

I parsed replication procedure signatures across SQL Server 2019, 2022 and 2025 to find security and TLS parameter changes.

Six SQL Server Log Reader Columns Missing After 2019

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

Tested SQL Server 2022 and 2025 builds have six fewer fn_dblog and fn_dump_dblog columns than SQL Server 2019.

sp_dw_* and the Trident Procedures in SQL Server 2025

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

SQL Server 2025 adds more sp_dw and Trident system surface, including procedures, wait types, Extended Events, and messages.

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.

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