Posts
All the articles I've posted.
Automating SQL Server Patching with PowerShell: A Safe-Stop Blueprint for Standalone & Clustered Estates
A defensive DBA guide to automating SQL Server Cumulative Updates using PowerShell—covering SHA-256 verification, Setup Bootstrap log parsing, and rolling upgrades for Always On AGs and Failover Clusters.
Automated Patching for SQL Server on Azure VMs: Setup, Always On Guardrails & Azure Update Manager Migration
A practical DBA guide to configuring Automated Patching for SQL Server on Azure VMs via Portal and PowerShell—covering Always On AG scheduling caveats, Cumulative Update limits, and migrating ahead of the September 2027 retirement.
Migrating Off Expensive Managed Databases: Real-World Cost & IOPS Comparison (AWS RDS vs. DigitalOcean Managed PostgreSQL)
A practical DBA breakdown of AWS RDS vs. DigitalOcean Managed PostgreSQL—covering hidden billing meters, pgbench IOPS testing, and zero-downtime logical replication cutover.
DataGrip vs. DBeaver Pro vs. TablePlus: Which SQL Client Survives 50-Million-Row Production Diagnostics?
A real-world DBA stress test of DataGrip, DBeaver Pro, and TablePlus across 50M-row tables, SSH jump hosts, memory consumption, and visual EXPLAIN ANALYZE plans.
Escaping Oracle & SQL Server Licensing Costs: A Senior DBA’s Playbook for Migrating to PostgreSQL
A structured, four-phase DBA checklist for migrating enterprise workloads off Oracle and SQL Server to open-source PostgreSQL—covering TCO math, schema conversion, CDC sync, and post-migration validation SQL.
Zero-Downtime Database Failover & Point-in-Time Recovery (PITR): A Practical RPO/RTO Architecture Guide
Why nightly pg_dump scripts fail at scale, how to calculate true RPO and RTO budgets, and how to validate sub-30-second failover and Point-in-Time Recovery.