-
Why Every Byte Matters for SQL Server Pages
Think of a SQL Server data page as a Delta carry-on suitcase. It is always the same size, 8 kilobytes. When people talk about making SQL Server fast, they usually
-
“Rebuilding Indexes and Updating Statistics” The DBA’s Panic Button
We have all met this DBA. That has a “panic button” for every performance issue. The Index Rebuild and then update statistics. Dave’s maintenance schedule is aggressive. He rebuilds heavy
-
Understanding the Basic Architecture of Azure Managed Cassandra
I’ve been learning about Azure Managed Cassandra recently, and it’s very different from the usual relational SQL Server database. The documentation and tutorials can seem confusing at first, but once
-
My First Step in AI-Driven Ops
Automating SQL Server to Jira with Python (Phase 1) I’ve been spending a lot of time thinking about observability and how I can use AI to automate fixing problems, not
-
Knowledge Hoarding and What Changed My Perspective
Last year, while speaking at PASS about imposter syndrome, another topic that kept coming up in conversations was knowledge hoarding. At the time, I didn’t fully understand it. I’ve always
-
Is That Index Really Fixing Your ORM Query Performance or Just Adding Costs?
Recently, I thought a database query in a plan was straightforward. It looked innocent until I noticed strange behavior. The deeper I dug, the more I realized many people might
-
Small Steps to Automate Repetitive Manual Tickets with AI
If you handle Jira tickets every day, you’ve probably seen the same requests repeatedly: These are perfect candidates for small AI-assisted automation. You don’t need to rebuild your workflow or
-
Quiet Quitting, The Graveyard Where Skills Go to Die
I kept hearing the term “quiet quitting” and at first, I didn’t know what it meant. Then I looked around and realized I was seeing it everywhere. People are staying in
-
Where’s the DBA Role Headed?
Most of my energy lately has been devoted to building new skills and stepping into new challenges, including pursuing a Master’s degree in Database Administration and Design, driving performance improvements
-
What Causes Locking and Blocking and When to Take Action
It’s common to see a lock and immediately assume it’s the problem. Many people believe that any lock is a bad thing. I’ve had to explain this many times, so
Welcome to
AAA DBA Blogging
