Resolving SQL Server Transaction Log Issues Efficiently
Transaction log issues are one of the quietest ways a healthy database turns into an incident. A log file fills up, backups fall behind, and by the time anyone...
2026-07-29
103 reads
Arun Sirpal
Building AgentDBA’s Slack Escalation
Until now, a CRITICAL finding did the right internal routing, but the last mile was a log line — useful for an audit trail, useless at 3am. v1.2.0 closes...
2026-07-15
37 reads
How AgentDBA Identifies Backup Failures
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of it, nobody’s fixed it, it’s just there — a handful of small compliance gaps that...
2026-07-03 (first published: 2026-07-02)
38 reads
How AgentDBA Diagnoses SQL Server Issues Fast
Not every production incident is a database in RECOVERY_PENDING or a corrupted event (like the other post). Sometimes the server is just a mess. Jobs failing. Error log full...
2026-06-23 (first published: 2026-06-22)
47 reads
AgentDBA vs Critical SQL Server
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You open the terminal and go to work. This post is about what happens next —...
2026-06-16
176 reads
Database AI Agents: The Read-Only Rule
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A read-only advisory system does exactly two things: it observes and it recommends. It never acts....
2026-06-11
36 reads
Why Database AI Agents need Layers?
Third part in my Ai series with databases. When building AI solutions within the database realm the first thing that people do is a straightforward concept, connect the LLM...
2026-06-09
177 reads
AI Insights for Database Monitoring: A DBA’s Perspective
Second in a series on Ai and databases. One Story, three signals – I have a backup of a critical database that has failed three times, the recovery point...
2026-06-05 (first published: 2026-06-04)
36 reads
Databases and AI Agents
As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI can support SQL Server operations. A failed job, missed...
2026-06-03 (first published: 2026-05-17)
531 reads
Claude Context Window
Every Claude conversation has a context window. It is the total amount of text Claude can work with in a single chat — your messages, its replies, uploaded files,...
2026-05-30 (first published: 2026-05-29)
29 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers