Divide and Conquer the Database
A developer shares techniques to improve database performance for large BLOB data retrieval in C#/.NET, including compression and chunking requests.
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.
A guide to optimizing SQL Server indexes for tables with high rates of data insertion, updates, and deletions to combat fragmentation.
Announcing a full-day SQL Server performance monitoring and troubleshooting PreCon session at SQLSaturday NYC 2025, led by a former Microsoft PM.
SQL Server 2019 has ended mainstream support, leaving users with only security patches. This article outlines the implications and next steps.
A developer announces the return of their technical blog after a 3-year hiatus, hinting at future posts on databases, cloud, AI, and more.
SQL Server auditing fails to capture permission change attempts, creating a security gap. Article details the issue and a temporary workaround.
Analyzes challenges implementing the Principle of Least Privilege in Microsoft SQL Server, focusing on tasks that still require the powerful sysadmin role.
A technical guide comparing SQL Server data-at-rest encryption methods: Transparent Data Encryption, Backup Encryption, and Always Encrypted.