Advent of 2025, Day 16 – SQL Server 2025 – Optional parameter plan optimization (OPPO)
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
Analyzes the lack of data replication support for Clustered Columnstore Indexes in SQL Server, covering features from 2012 to 2025.
Analyzes the pros and cons of renaming the built-in SQL Server 'sa' account as a security measure against brute-force attacks.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Fixing a misleading Azure AD group permission error during DACPAC deployment in Azure DevOps, related to schema creation.
A data professional shares her schedule and projects for PASS Data Community Summit, including keynotes, sessions, and a fun AI-powered PowerShell script.
Updated SQL Server diagnostic queries for November 2025, including new columns and query hints for performance analysis.
EF Core 10.0 introduces partial updates for JSON columns using ExecuteUpdate/ExecuteUpdateAsync, with examples for SQL Server.
Provides slides and scripts for the 'Indexing for Dummies' presentation from the dataMinds Connect 2025 tech conference.
Explores advanced techniques attackers use to bypass SQL Server data access auditing and provides mitigation strategies to close security gaps.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
EF Core 10.0 adds support for the new JSON data type in Microsoft SQL Server 2025, enabling querying and storage of JSON documents.
Provides slides and SQL scripts from a 'Indexing for Dummies' session, focusing on SQL Server database performance.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
A security researcher details a SQL Server auditing bug that allows low-privilege users to exfiltrate sensitive data without detection.
A developer shares techniques to improve database performance for large BLOB data retrieval in C#/.NET, including compression and chunking requests.
A guide to using SQL Server's Data Classification feature to audit access to sensitive data, focusing on the new SENSITIVE_BATCH_COMPLETED_GROUP action.
Explores methods to bypass data access auditing in Microsoft SQL Server and provides guidance on how to close these security gaps.
Updated T-SQL diagnostic queries for SQL Server (August 2025) to analyze instance configuration and performance across versions.
A guide to implementing essential security auditing for databases, using Microsoft SQL Server as a practical example to demonstrate configuration and importance.