Get Your Money’s Worth from Your Read-Only Nodes with Round-Robin Routing
I was working on a four-node Availability Group migration and learned something new. Thanks to Brian Tanquary for showing me this trick. Without round-robin routing,…
Tag: DBA
-
-
10 Things That Surprised Me About PostgreSQL
I’m learning PostgreSQL so I can support it. Everyone told me it was easy. Some even said it was better than SQL Server. Let’s just…
-
Your Backup Job Succeeded. Your Backup Didn’t.
I keep seeing this problem. Jobs say success, but the backups are not usable.If backups are not your top priority, they should be. In many…
-
The .gitignore List
This post exists for one reason, everyone should have a .gitignore if they are using GitHub. I tell you why and what it is here:…
-
SQL Server Error Log Tricks More DBAs Should Know
When SQL Server starts going down, one of the first places you should look is the error logs. They are the fastest way to pinpoint…
-
Humble, Hungry, & Smart
I recently started reading The Ideal Team Player, a book I received from Straight Path. About halfway through, I felt this overwhelming sense of familiarity and…
-
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…
-
From Reactive DBA to Proactive DBRE, Building Trust Through Reliability
Most DBAs start their careers in a firefighting mindset. I sure did. Systems go down, war rooms are daily, alerts blow up, and dashboards light…