SQL Server Science
Technical Articles for the DBA / Developer
Home » Extended Events

What a Linked Server Query Sends: Four-Part Names, OPENQUERY and EXEC AT

2026-11-09 · by Hannah Vernon · in t-sql

Which filters and joins reach the remote server in a linked server query? I traced four-part names, OPENQUERY and EXEC AT, and counted the rows.

SQL Server 2025 Added Lock Modes to Extended Events

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

SQL Server 2025 adds XE lock-mode map values, LAQ events, and optimized-locking evidence from a small scratch workload.

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.

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.

The sp_fido_* Procedures and the Rest of the FIDO Surface in SQL Server 2022

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

SQL Server 2022 added 25 FIDO-named procedures and a larger FIDO XE surface, so I mapped what is visible without executing them.

Catching Slow File I/O with a Filtered Extended Events Session

2026-07-10 · by Hannah Vernon · in extended-events

file_read_completed and file_write_completed fire on every I/O. Filter on duration to capture only the slow ones, then shred to name the file.

1 2 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 Hannah Vernon
  • 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
    • Work That Flows: Kanban for DBAs: 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