Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts for the Day-to-Day DBA. This 240 page book, and accompanying scripts, is chock full of advice for DBAs, from novice to experienced.
The book focuses on these topics:
- Installing SQL Server
- SQL Server Documentation
- How to Move Data Into and Out of SQL Server
- How to Manage Data Growth
- How to Use System Tables and DMVs to Investigate What SQL Server is Doing
- Monitoring and Notification
- Security Monitoring
- Finding and Fixing Data Corruption
The book, unlike most technical books, attempts to make dry technical content come to life. According to Rodney, “I wrote the book the way it is because I did not want to bore DBAs to tears with another 500+ page textbook-style tome with step-by-step instructions. I wanted this book to be a novel, a book of poetry, a murder mystery, a ghost story, an epic trilogy, a divine comedy. But realizing that this is, after all, a technical book, I compromised by imbuing it with some humor and personality. If you make it as far as the monster at the end of this book, my hope is that you will have been entertained and can use the code from the Tacklebox in some fashion that will make your lives as DBAs easier. Why “The Tacklebox,” you might ask, rather than “Zombie Queries,” “You Can’t Handle the Code” or “You had me at BEGIN?” I think, as I push halfway through my career as a DBA and author, this book is as close as I will ever get to “The Old Man and the Sea”…oh yes, and apparently the “Toolbox” had been copyrighted. Plus, come on! Look at the cover of the book. How can I live here and not go fishing once in a while?”
You can download the free eBook here.