D-Bart – Blog

Verify “ApplicationIntent=ReadOnly”

July 6, 2025 / bart / DBA, Extended Events, High availabitlity, SQLServer

Context A client used “ApplicationIntent=ReadOnly” in their connection string, expecting queries to execute on the secondary read-only replica. Instead, the queries were executed on the primary database, leading them to suspect an Availability Group misconfiguration. Diagnostic To confirm whether the driver sent the read-only intent, we captured the “hadr_read_only_route_preconditions” Extended Event. This event records whether […]

Verify “ApplicationIntent=ReadOnly” Read More »

Streamlining SQL Server management: Thrive

July 5, 2025 / bart / D-Bart, DBA, SQLServer, TeamEfficiency

This article covers the fifth and final step in the D-BART method, a structured approach to managing SQL Server environments. What’s in it for you? Less firefighting, more focus: Your team spends less time on repetitive tasks and more on high-impact work. Better decisions, faster: With reliable data at your fingertips, you can act on

Streamlining SQL Server management: Thrive Read More »

Streamlining SQL Server management: Report

July 5, 2025 / bart / D-Bart, DBA, SQLServer, TeamEfficiency

This article covers the fourth step in the D-BART method, a structured approach to managing SQL Server environments. What’s in it for you? Proactive insight: Spot unexpected changes in configuration, hardware, or database state before they become problems Stronger foundations: Ensure that automation scripts rely on accurate, verified data Answer with certainty: Give clear,

Streamlining SQL Server management: Report Read More »