SQL Server Case of the Week: The Transaction Log of Your Snapshot Replication Publisher Database Won’t Truncate… But Why?
December 12, 2025
Quick Summary When snapshot replication is configured with schema replication enabled, DDL changes are sometimes marked for replication but never marked for truncation, creating a false “undistributed command” that prevents log truncation and causes uncontrolled growth. The solution was to add a log reader agent using sp_addlogreader_agent on the publisher to mark all replicated commands for truncation. Context The SQL
Essential SQL Server Database Maintenance Tasks Every DBA Should Know
August 23, 2023
Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. Some folks will implement a SQL Server maintenance plan without fully digesting what they are doing, but we prefer you to do this with eyes wide open. In this post, we will explore key tasks and areas
Tara’s favorite SQL Server 2012+ Feature
February 16, 2019
If you’re still on SQL Server 2008/2008 R2, you’re missing out on some great features. It’s no secret that Availability Groups are my favorite feature since SQL Server 2012. Back in the day, I was supporting complex environments with aggressive SLAs. On one particular system, I had Failover Clustering for HA, Asynchronous Database Mirroring for