Open Daily: 10am - 10pm | Alley door pickup 10am - 7pm 3038 Hennepin Ave Minneapolis, MN
612-822-4611

  • Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
SQL Recipes for DBAs: Practical Queries for Performance, Maintenance, and Troubleshooting

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

Baldwin-Anderson, Tiye

Paperback

DatabasesProgramming

ISBN13: 9798185260197
Publisher: Independently Published
Published: Jul 2 2026
Pages: 328
Weight: 0.97
Height: 0.69 Width: 6.00 Depth: 9.00
Language: English
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.

Also from

Baldwin-Anderson, Tiye

View All

Also in

Programming

View All