SQL Server Science
Technical Articles for the DBA / Developer
Home » SQL Server 2022 » Page 2

EngineEdition Branches Inside System Procedures DBAs Already Call

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

SQL Server 2025 adds EngineEdition 12 branches to familiar system procedures, and sp_spaceused can delegate to a FIDO path.

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.

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.

System Procedures and Views Whose Code Changed Between SQL Server 2019 and 2022

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

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

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

SQL Server 2022 added sys.fn_filelog, an undocumented log reader with the same output columns as fn_dblog and fn_dump_dblog.

« Previous 1 2 3 4 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