$ man dba.mx
The 40 things you do most in a database.
Real commands to back up, restore, grant permissions, index, hunt slow queries, resolve locks and more — in Oracle, PostgreSQL, SQL Server and MySQL. Free, no sign-up.
// Rather have us do it, fixed-price? Start with a paid assessment.
40 guides
Oracle Backups & recovery
How to back up an Oracle database with RMAN
read guide → Oracle Backups & recovery
How to restore and recover an Oracle database with RMAN
read guide → Oracle Users & permissions
How to create a user and grant permissions in Oracle
read guide → Oracle Performance
How to create an index in Oracle and when to use bitmap
read guide → Oracle Diagnostics
How to find slow queries in Oracle with AWR and v$sql
read guide → Oracle Diagnostics
How to view and resolve session locks in Oracle
read guide → Oracle High availability
How to configure Data Guard for high availability in Oracle
read guide → Oracle Operations
How to monitor tablespaces and their growth in Oracle
read guide → Oracle Migration & data
How to export and import data in Oracle with Data Pump
read guide → Oracle Operations
How to change initialization parameters in Oracle safely
read guide → PostgreSQL Backups & recovery
How to take a PostgreSQL backup with pg_dump
read guide → PostgreSQL Backups & recovery
How to restore a PostgreSQL backup with pg_restore and psql
read guide → PostgreSQL Users & permissions
How to create a user and grant permissions in PostgreSQL with GRANT
read guide → PostgreSQL Performance
How to create an index in PostgreSQL: B-tree and partial indexes
read guide → PostgreSQL Diagnostics
How to find slow queries in PostgreSQL with pg_stat_statements
read guide → PostgreSQL Diagnostics
How to view and resolve locks in PostgreSQL with pg_locks and pg_stat_activity
read guide → PostgreSQL High availability
How to set up streaming replication in PostgreSQL
read guide → PostgreSQL Operations
How to monitor the size and growth of a PostgreSQL database
read guide → PostgreSQL Migration & data
How to export and import data in PostgreSQL with COPY
read guide → PostgreSQL Operations
How to run VACUUM and ANALYZE in PostgreSQL and tune autovacuum
read guide → SQL Server Backups & recovery
How to back up a database in SQL Server (BACKUP DATABASE)
read guide → SQL Server Backups & recovery
How to restore a backup in SQL Server (RESTORE DATABASE)
read guide → SQL Server Users & permissions
How to create a login, a user, and grant permissions in SQL Server (GRANT)
read guide → SQL Server Performance
How to create an index in SQL Server (clustered vs. nonclustered)
read guide → SQL Server Diagnostics
How to find slow queries in SQL Server (Query Store and DMVs)
read guide → SQL Server Diagnostics
How to view and resolve blocking in SQL Server (sp_who2 and DMVs)
read guide → SQL Server High availability
How to set up Always On Availability Groups in SQL Server
read guide → SQL Server Operations
How to monitor file size and growth in SQL Server
read guide → SQL Server Migration & data
How to export and import data in SQL Server (BCP and BULK INSERT)
read guide → SQL Server Operations
How to update statistics and rebuild indexes in SQL Server
read guide → MySQL Backups & recovery
How to back up MySQL with mysqldump
read guide → MySQL Backups & recovery
How to restore a MySQL backup from a SQL dump
read guide → MySQL Users & permissions
How to create a user and grant permissions in MySQL
read guide → MySQL Performance
How to create an index in MySQL and when to use a composite one
read guide → MySQL Diagnostics
How to find slow queries in MySQL
read guide → MySQL Diagnostics
How to see and resolve locks in MySQL
read guide → MySQL High availability
How to set up replication in MySQL for high availability
read guide → MySQL Operations
How to monitor database size and growth in MySQL
read guide → MySQL Migration & data
How to export and import data in MySQL with LOAD DATA and OUTFILE
read guide → MySQL Operations
How to change configuration variables in MySQL safely
read guide →next_step
Rather we handle it?
The guides are for doing it yourself. If it is production and you would rather not risk it, a paid assessment gives you the plan at a fixed price — and it credits toward the project.