SQL Server Case of the Week: When Availability Group Replica Communication Issues Cause Log Drives to Fill
February 13, 2026
Summary – Log File Filling up on the Availability Group Networking firewall changes made over the weekend resulted in the client’s three disaster recovery (DR) replicas to not be able to communicate with the three High Availability (HA) replicas in their SQL Server Always on Availability Group (AG). This resulted in log files growing out
Distributed Availability Groups – Certificates, Crash Recovery, and Headaches (Case of the Week)
December 5, 2025
There are a ton of great resources out there teaching you how to build a Distributed Availability Group (DAG), but there aren’t many at all that help you troubleshoot them when they go bump. Fortunately for you (and unfortunately for me) I’ve had enough experience administering DAGs that I’d like to start to share the
Accelerated Database Recovery in SQL Server 2025
June 19, 2025
Accelerated Database Recovery (ADR) was introduced in SQL Server 2019. Its main purpose is to allow for faster database recovery in the event of a crash or unexpected shutdown. Traditionally, the database engine handles crash recovery through a series of phases—analysis, redo, and undo—which can be inefficient and slow, especially when dealing with long-running transactions.
Managing Orphaned Users in SQL Server with sp_FindOrphanedUser
September 26, 2024
Addressing orphaned users is an important piece of SQL Server security management. When left unchecked, you can accumulate an overwhelming number of users that exist in a database but do not have a correlating login in the master database, thus preventing access to the server or the database at all. There are dbatools PowerShell modules