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.
A guide for SQL Server DBAs on using Ansible to automate database administration tasks like installation, backup, and user management.
A technical guide on enforcing TLS 1.2 and trusted certificates for SQL Server connections to secure data in transit, covering FedRAMP compliance.
A guide to obfuscating sensitive data directly within SQL Server using a user-defined function, focusing on securing development environments.
A guide to implementing fine-grained permissions for SQL Server Extended Events to enforce the Principle of Least Privilege with role separation examples.
A former Azure SQL security engineer outlines seven key improvements needed for access control and security in SQL Server and Azure SQL.
A tutorial on using Docker Compose to containerize an ASP.NET Core Web API and connect it to a SQL Server database running in separate containers.
