-
Play with Terraform and Docker on Mac
Today we are going to walk through a simple installation, run a local test, and then provision a Docker container. This should be very easy and straightforward. Prerequisites https://code.visualstudio.com/download 2.
-
Learn PowerShell the Easy Way Without AI
When I mentor others, the question I hear most is, “How do I actually start automating with PowerShell?” The advice my mentees usually get from others lately is “Just go
-
Time, The Foundation for Effective Operational Capacity Planning
When it comes to managing the capacity of operational and infrastructure teams (like DBAs, DBREs, SREs, and PFEs), the traditional product development metric of using story points often doesn’t work
-
A Beginner’s Guide to Roadmaps for DBREs and DBAs
If you work in operations, whether you are a DBA, DBRE, SRE, or somewhere in between, you already know most work is urgent. Something always needs fixing, tuning, patching, scaling,
-
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
Welcome to
AAA DBA Blogging
