DBA KNOWLEDGE BASE

Free technical resources for database teams

Guides with real commands, actionable checklists and escalation criteria for the most common issues in PostgreSQL, SQL Server and Oracle.

PostgreSQL · Performance

Slow PostgreSQL: step-by-step diagnosis for DBAs and technical teams

PostgreSQL · Replication

Delayed PostgreSQL replication: lag diagnosis in streaming and logical replication

PostgreSQL · Backup & Recovery

PostgreSQL backup that won't restore: validation, causes and recovery

PostgreSQL · Migration

PostgreSQL 14 to 16 migration: technical plan with validation and rollback

PostgreSQL · High Availability

Patroni for high availability in PostgreSQL: architecture, operations and failover

SQL Server · Performance

Slow SQL Server: wait analysis, locks and performance with DMVs

SQL Server · Locks and Deadlocks

SQL Server locks: identify deadlocks, release resources and prevent them

Oracle · Data Guard

Oracle Data Guard lagging: diagnosis and lag recovery

All engines · Disaster Recovery

Disaster Recovery for databases: technical plan, RTO and RPO

All engines · Backup & Recovery

Database backup audit: complete technical checklist