DBRE Consistency & Automation Checklist
Use this checklist to assess your environment, identify gaps, and make automation reliable. Start small and do one section at a time. How to Use…
Category: Databases
Database content
-
-
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…
-
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…
-
“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…
-
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…
-
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…
-
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…
-
The Ultimate Checklist for Jr DBAs
As I reflect on my journey as a DBA, I realize how much the landscape has shifted over the years. With the rise of cloud…
-
SQL Server Memory Grants: Exposing the Silent Performance Assassin
Part 1 Memory Grant Introduction If you’ve been dealing with performance issues, you’ve probably focused on logical reads,duration, CPU usage, and other metrics. However, with…