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.
Microsoft releases SQL Server 2022 Cumulative Update 20, detailing its fixes, servicing model, and patching recommendations.
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.
SQL Server 2022 Cumulative Update 19 includes a critical security fix for auditing missing permission changes, urging immediate installation.
A security experiment exposing a SQL Server to the internet, revealing attack patterns and providing security recommendations.
Explains the benefits of SQL Server contained availability groups for simplifying failover and reducing DBA workload, contrasting them with traditional AGs.
Part 3 of a series on SQL Server security, covering auditing, encryption, and secure development practices for DBAs.
A guide to troubleshooting and improving performance in slow SQL Server applications using structured techniques.
