Updated SQL Server diagnostic queries for February 2026, with fixes and improvements for various SQL Server and Azure versions.
Updated SQL Server diagnostic queries for January 2026, covering multiple versions and Azure services for performance and configuration analysis.
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
Updated SQL Server diagnostic queries for November 2025, including new columns and query hints for performance analysis.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
Updated T-SQL diagnostic queries for SQL Server (August 2025) to analyze instance configuration and performance across versions.
Author's updated SQL Server diagnostic queries for July 2025, covering multiple versions and Azure services for performance and configuration analysis.
Updated SQL Server diagnostic queries for June 2025, covering multiple versions and Azure services for performance and configuration analysis.
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
Explores the new Edge Constraints feature in SQL Server 2019 and Azure SQL Database for enforcing data quality and directionality in graph database schemas.
Explains how to exclude specific nodes from XML data in SQL Server using T-SQL's modify method, UDFs, or temp tables.
A summary of the first SQL Server Southampton UserGroup meeting, covering sessions on SQL CLR and community discussions.
Explains using SET NOEXEC to validate SQL query syntax programmatically, noting a bug in SQL Server 2008 regarding object name validation.
