Tag: dba-workflows
All the articles with the tag "dba-workflows".
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.
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.
The Production DBA Remote Workstation: Managing 100+ Linux/AIX Servers, Dual Monitors & Zero-Lag SSH
How to organize a multi-monitor macOS DBA workstation for managing 100+ Linux and AIX database servers—covering DisplayLink hardware, environment-colored terminal profiles, and SSH ControlMaster multiplexing.