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

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 size- managing users, roles, logins, grants, and permissions- finding active sessions and long-running queries- diagnosing blocking, locks, and connection pressure- reading basic execution plans- working with indexes and statistics- backing up and restoring databases- verifying backups before they are needed- checking logs, storage, replication, and maintenance health The 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.