What a Linked Server Query Sends: Four-Part Names, OPENQUERY and EXEC AT
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
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
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
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
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
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.