Practical articles on database administration, architecture, and operations.10 articles published.
A planned Patroni site switchover does not guarantee RPO 0 by itself. The guarantee comes from fencing the old primary before the standby cluster is promoted — and from the specific sequence that makes that safe.
Finding JAVAVM in DBA_REGISTRY proves Oracle JVM is installed — not that an application depends on it. A practical diagnostic framework for separating installation from active use.
Extending Always On across Azure regions: quorum witness, possible-owner verification, REVERTING state, and transaction checks before failover.
Step-by-step procedure to recover sysadmin access to a SQL Server instance using single-user mode when all privileged accounts are disabled, deleted, or have unknown passwords.
Synchronous commit prevents data loss only while the secondary is SYNCHRONIZED. When it falls out of sync, the primary commits without waiting.
Dead tuples accumulate silently in PostgreSQL. When autovacuum can't keep up, tables bloat, queries slow, and XID wraparound becomes a risk. Here's how to detect and respond.
STATSPACK is Oracle's license-free performance repository. Learn how to install it, automate snapshots, generate reports, and read the sections that reveal the most about your database workload.
SQL Server can fail to start after Azure recreates local temporary storage because the configured tempdb directory and permissions are missing. Use the SQL IaaS Agent extension as the supported solution, with custom startup automation only as a fallback.
Oracle manages time zones across three independent layers — OS, database, and session. Understanding the separation is the prerequisite for diagnosing any timestamp inconsistency in production.
SQL Server deadlocks do not require two different rows. One row, two index structures, two sessions acquiring them in opposite order — that is enough for a cycle.
No articles match that tag.