SQL Recipes for DBAs: Practical Queries for Performance, Maintenance, and Troubleshooting

By Tiye Baldwin-Anderson

SQL Recipes for DBAs is a practical, engine-by-engine guide for people who need to administer databases, diagnose problems, protect data, and keep systems running.

Same DBA responsibilities. Different database machinery.

This book covers practical DBA recipes for PostgreSQL, SQL Server, MySQL/MariaDB, SQLite, and Oracle orientation. Instead of pretending every database works the same way, it shows how common DBA tasks change from one engine to another.

Inside, you'll find recipes for: checking database and table sizemanaging users, roles, logins, grants, and permissionsfinding active sessions and long-running queriesdiagnosing blocking, locks, and connection pressurereading basic execution plansworking with indexes and statisticsbacking up and restoring databasesverifying backups before they are neededchecking logs, storage, replication, and maintenance healthThe book is organized by database engine so readers can go directly to the section they need: PostgreSQL, SQL Server, MySQL/MariaDB, SQLite, or Oracle orientation.

If you are responsible for a database and need to know what to check, what command to run, and what trap to avoid, this book is designed as a practical field guide.

Use SQL. Recognize SQL. Steward SQL systems.

• Format: Paperback
• Language: English
• ISBN: B0H7BG2S1L
• ISBN13: 9798185260197
• Release Date: July 2026
• Publisher: Independently published
• Length: 326 Pages
• Weight: 0.97 lbs.
• Dimensions: 9.0" x 0.7" x 6.0"