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,…
Category: Databases
Database content
-
-
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…
-
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…
-
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…
-
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…