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.
SQL Server 2025 sp_columns Omits JSON and Vector Columns
SQL Server 2025 filters json and vector columns from sp_columns and ODBC catalog output. I tested the alternatives.
What Is openrowset auto_create_statistics Connected To?
I traced the undocumented openrowset auto_create_statistics option through SQL Server inventory, Microsoft docs, and a local 2025 test.
Cloud Feature Wait Types in Boxed SQL Server
SQL Server includes wait types named for Synapse Link, Trident, DW, and Parquet. I checked which ones exist and whether they collect counts.
Idle SQL Server Instances Still Accumulate Undocumented Wait Types
I sampled two idle SQL Server instances and found undocumented wait types with non-zero counts. Here is how I keep them visible but out of top waits.