Practical articles on database administration, architecture, and operations.16 articles published.
A practical Oracle DBA guide to diagnosing excessive hard parsing, identifying SQL statements that differ only by literals, understanding library cache pressure, and choosing between bind variables, CURSOR_SHARING, and shared pool tuning.
Oracle compression reduces block count, not just disk footprint. Understanding the difference between Basic, Advanced Row, and Hybrid Columnar Compression — and their DML, CPU, licensing, and platform implications — determines which option fits the workload.
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.
Step-by-step guide to creating an Always On Availability Group on SQL Server 2019/2022. Covers prerequisites, Windows firewall and Azure NSG rules, required privileges, AG listener creation for both on-premises and Azure ILB, manual and automatic seeding options, and monitoring scripts for seeding progress and AG health.
Step-by-step guide to enabling TDE on SQL Server 2019/2022 using a locally managed certificate or Azure Key Vault via EKM. Covers key management hierarchy, backup requirements, encryption state monitoring, risks, and rollback considerations.
Step-by-step guide to building a WSFC as the foundation for SQL Server Always On Availability Groups. Covers AD permissions and CNO pre-staging, Windows Firewall rules, Azure NSG rules, cluster validation, creation, and all quorum options with PowerShell for every step.
Step-by-step procedures to relocate master, model, msdb, tempdb, and user database files from default C: installation paths to dedicated data and log volumes, with a single-restart strategy for system databases.
No articles match that tag.