Cloud Feature Wait Types in Boxed SQL Server

· by · in

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

· by · in

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.

Error Message Text Is Not an Alerting Contract

· by · in

SQL Server message text changes between versions. Key alerts on message ID and severity, then diff sys.messages before an upgrade.

How Approximate Are SQL Server 2022 XTP Hash Index Stats?

· by · in

I tested SQL Server’s undocumented XTP hash index approximation function against the documented DMV on one scratch table.

CDC Extended DDL Handling in SQL Server 2022 and 2025

· by · in

SQL Server 2022 added an unsupported CDC extended DDL option. I tested the parameter, metadata function and 2025 procedure changes.

Reading the SQL Server Error Log Without sysadmin

· by · in

SQL Server 2022 added VIEW ANY ERROR LOG. I tested the newer permission against sp_readerrorlog and sp_enumerrorlogs.