Blog
Database guides from working DBAs
Practical, opinionated writing on SQL Server, Oracle, MySQL, PostgreSQL, and database architecture. No fluff — techniques used on real production systems.
Stop Clicking: Why dbatools is the Only Way to Manage SQL Server in 2024
If you are still using SQL Server Management Studio for repetitive administrative tasks, you are wasting cycles. The dbatools PowerShell module is a force multiplier that every serious DBA must master.
SQL Server 2025 Standard Edition: Finally, More Than Crumbs for Your Hardware
Microsoft is finally increasing the compute limits for SQL Server 2025 Standard Edition, providing a long-overdue path for scaling without the immediate jump to Enterprise pricing.
SQL Server Change Data Capture: The Production DBA’s Survival Guide
A practical reference for managing SQL Server CDC, preventing transaction log explosions, and maintaining high-performance data pipelines in 2026.
Why Bring in a Fractional DBA Consultant?
A full-time DBA runs $123K–$300K all-in. A fractional DBA runs $35K–$100K. Here is why the math works, why it compounds, and when to make the call.
SQL Server Linked Servers: Performance Traps, Security Gaps, and the Queries That Will Cost You
Linked servers are one of SQL Server most misused features. Poorly configured remote joins, missing statistics, and credential delegation issues routinely show up as the root cause of slow batches and security gaps. Here is what 20 years of production DBA work teaches about making linked servers behave.
SQL Server to Oracle 23ai Migration: A Technical Case Study
A production DBA team migrated a 12TB SQL Server OLTP workload to Oracle 23ai in 11 weeks. This is what actually happened — migration drivers, Oracle 23ai features leveraged, the hard parts, and the measurable outcomes. No marketing copy.
SQL Server Extended Events: The Definitive Guide for DBAs
Extended Events replaced SQL Trace over a decade ago. Most DBAs still default to legacy tools when diagnosing production issues — missing the speed, flexibility, and diagnostic depth that XEvents actually provide. Here is the guide I wish had existed when I made the switch.
Oracle Data Guard Configuration: A Step-by-Step Guide for Production DBAs
Configuring Oracle Data Guard doesn’t have to be a week-long project. Here’s the practical sequence we’ve used on hundreds of production systems — primary setup, standby creation, observer configuration, and the switchover runbook.
SQL Server Always On Availability Groups: A Deep Dive into Architecture, Replica Roles, and Failover
AGs are more than a HA feature — they're a replication and routing platform. This post goes under the hood: replica roles, synchronous vs asynchronous modes, failover mechanics, readable secondary behavior, and the T-SQL that actually controls it all.
SQL Server 2025 Query Store: Hint-Based Forcing, CE Feedback Persistence, and Plan Regression Detection
SQL Server 2025 ships its most significant Query Store overhaul yet — hint-based plan forcing without query text changes, cardinality estimator feedback that survives restarts, and smarter regression detection that cuts through parameter-sniffing noise. Here's what actually changed and how to use it.
How to Set Up SQL Server TDE: Setup, Backup, and Restore to Another Server
Transparent Data Encryption (TDE) encrypts your SQL Server database at rest — no application code changes, no schema modifications. This guide covers setup from scratch and migrating keys to a new server.
How to Set Up SQL Server Transactional Replication: A Practical Guide
SQL Server transactional replication moves data and schema changes from one database to another in near real-time. This guide covers concepts, components, and a working example you can build on.
SQL Server TempDB Contention: How to Diagnose It and Fix It for Good
TempDB contention shows up as PAGELATCH\_UP and PAGELATCH\_EX waits on allocation pages, and it degrades everything — sorts, spills, temp tables, table variables, even row versioning. Here's how to find it in 5 minutes with DMVs and fix it with the right number of data files.
SQL Server Always On Availability Groups vs Oracle Data Guard: Which Should You Trust With Your Data?
After 20+ years running both Oracle RAC and SQL Server AGs in production, here's what the vendor marketing won't tell you about failover speed, read-scale, licensing cost, and which one actually stays up when it matters.
SQL Server Always On Availability Group Failover Testing: A Production Runbook That Actually Works
Most AGs go untested until a real failover happens. By then it is too late to discover your application connection string has a hardcoded node name, your secondary is 45 minutes behind, or your monitoring does not alert on replica state. Here is the runbook I run on every new AG setup before it goes to production.
Oracle 23ai New Features: AI Vector Search, JSON Duality, and Why It Matters for DBAs
Oracle Database 23ai brings native AI vector search, JSON Relational Duality, and True Cache to the enterprise. Here is what actually changes for multi-platform DBAs.
sp_checkAG — Check Your SQL Server Availability Groups for Availability Issues
sp\_checkAG is a free stored procedure that surfaces SQL Server Availability Group health issues before they become outages. Learn how to install it, interpret its output, and automate AG monitoring.
SQL Server Always On Failover Troubleshooting: What to Do When the AG Won't Fail Over
Your Always On AG isn't failing over — or it failed over and you don't know why. Here's the step-by-step diagnostic process: checking quorum, synchronization state, lease timeouts, and the DMV queries that tell you exactly what happened and why.
SQL Server 2025 OPTIMIZED\_LOCKING: What DBAs Need to Know
SQL Server 2025 introduces OPTIMIZED\_LOCKING, a database-scoped option that fundamentally changes how the lock manager works. Here is what it does, how to enable it, and what to watch out for.
SQL MCP Server: Microsoft's Open-Source Bridge Between AI Agents and SQL Databases
Microsoft's SQL MCP Server connects AI agents like Copilot and Claude to SQL Server databases through the Model Context Protocol. Here's what it actually does, how to set it up, and where an experienced DBA is still irreplaceable.
SQL Server Performance Tuning Checklist: 12 Checks That Actually Find Problems
Before you tune anything, know what is actually wrong. This checklist walks through the 12 diagnostics that catch 90% of SQL Server performance problems — no guessing, no voodoo, just DMVs and evidence.
SQL Server Performance Monitoring: DMVs and Extended Events Every Production DBA Needs
Stop guessing what is killing your SQL Server. Learn how to use built-in DMVs and Extended Events to diagnose CPU spikes, wait stats, and slow queries without spending a dime on third-party tools.
SQL Server 2016 End of Life Is July 12, 2026 — Here's What You Need to Do Now
SQL Server 2016 reaches End of Life on July 12, 2026 — less than 10 weeks away. No more security patches means real compliance exposure. Here's what your options are, what they cost, and what to do in the next 60 days.
SQL Server AG Deep Dive: Standard Edition Gotchas, Distributed AGs, and Clusterless AGs
Basic Availability Groups on Standard Edition are not what most shops think they are — one database, no readable secondary, no backup offloading. Here is what you need to know about Standard Edition limits, distributed AG architecture, and clusterless AGs on Linux before you commit to a topology.
SQL Server Backup and Restore Best Practices for Production DBAs
Most SQL Server teams have backups. Far fewer have restores. Here is how to build a backup strategy that actually works when it matters most.
SQL Server Deadlock Troubleshooting: How to Find, Read, and Fix Deadlocks in Production
Deadlocks hit at 2am when your ticketing system is down and the business is screaming. Here is how to capture, read, and eliminate them permanently — using Extended Events, not the deprecated trace flags still clogging search results.
SQL Server Index Tuning: The DBA's Guide to Query Performance
SQL Server index tuning is where query performance lives or dies. Here's the hands-on guide — finding missing indexes with DMVs, the truth about fragmentation thresholds, covering indexes that eliminate key lookups, and the composite index that turned a 47-minute report into a 3-second one.
SQL Server Always On Availability Groups: Configuration, Pitfalls, and the 3am Survival Guide
Always On Availability Groups are SQL Server's most powerful high-availability feature — and the most commonly misconfigured. Here's what 20 years of production DBA experience looks like when a cluster node fails at 3am and you need every setting right.
PostgreSQL Disaster Recovery: A DBA's Guide to Backup Strategies That Actually Work
Most PostgreSQL backup strategies are theater. They run, they complete, and when you actually need them they fail. After 20+ years managing production databases, here's what a real DR plan looks like.
PostgreSQL Performance Tuning: Index Strategies That DBAs Actually Use
Generic index advice won't save you at 3am when queries are crawling. Here's the PostgreSQL index tuning playbook seasoned DBAs actually reach for — from partial indexes to covering indexes to the queries that reveal what's really killing your performance.
Migrating SQL Server to Azure SQL Database: A DBA's Practical Checklist
Moving SQL Server to Azure SQL Database looks straightforward on paper. In practice, the surprises hit at 11 PM before go-live. Here's the checklist built from doing this dozens of times across companies of every size.
MySQL Performance Tuning: 7 Query Optimizations That Cut Response Times in Half
Slow MySQL queries are usually fixable without new hardware. Here are 7 practical optimizations—from index strategy to query rewrites—that consistently deliver the biggest performance gains.
SQL Server to PostgreSQL Migration: A DBA's Practical Step-by-Step Guide
Migrating from SQL Server to PostgreSQL? Here's the practical, no-nonsense guide covering schema conversion, data migration tools, cutover planning, and the pitfalls most teams miss.
5 Signs Your Database Needs a Remote DBA (Before It's Too Late)
Most companies wait until a crisis hits before hiring DBA support. Here are 5 clear warning signs that remote DBA expertise would transform your operation—and your peace of mind.
Remote DBA vs. Full-Time DBA: Cost Comparison for SMBs (You're Probably Overspending)
Hiring a full-time senior DBA costs $120K–$180K+ annually. A remote DBA costs a fraction of that with zero overhead. Here's the true cost analysis with real numbers.
How AI is Changing Database Administration in 2026: What DBAs Must Learn Now
AI-assisted database management is no longer futuristic. It's here, and it's changing how DBAs work. Here's what's actually changing and what skills matter more than ever.
SQL Server Query Optimization: 10 Techniques Every DBA Should Know
Slow queries are the number one complaint we hear from clients. Here are 10 battle-tested optimization techniques that will slash your query times—some in minutes.
MySQL Indexing Best Practices: From Beginner to Expert
Indexes are the single highest-leverage tool in MySQL performance. Most teams use them wrong. Here's the complete guide from basic B-tree behavior to composite index design.
Oracle AWR Reports Explained: Performance Tuning Without Guessing
AWR (Automatic Workload Repository) is Oracle's most powerful diagnostic tool—and the most misunderstood. Here's how to read AWR reports and actually fix what you find.
SQL Server Always On Availability Groups: The Complete Setup Guide
Always On AG is SQL Server's flagship HA solution. The setup is complex but the payoff—automatic failover with near-zero data loss—is worth every step. Here's the full walkthrough.
Database Backup Strategies: RPO, RTO, and What Actually Matters
Most backup strategies are theater. They look good on paper but fail the moment you actually need them. Here's how to design a backup strategy around recovery—not backups.
SQL Server Blocking and Deadlocks: Diagnosis and Prevention
Blocking brings applications to their knees. Deadlocks cause transaction rollbacks your users notice. Both are diagnosable and fixable—here's the complete guide.
SSIS Package Development: Common Mistakes and How to Fix Them
SSIS is powerful but unforgiving. Most teams learn its quirks the hard way—in production. Here are the 8 most common SSIS mistakes and exactly how to avoid them.
The True Cost of Database Downtime (And How to Prevent It)
Most companies don't know what an hour of database downtime actually costs them. Once you calculate it, your HA investment looks very different. Here's the math and the prevention plan.