Start reading SQL Server Tacklebox on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA

SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA [Kindle Edition]

Rodney Landrum

Print List Price: £19.99
Kindle Price: £6.27 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.72 (69%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £6.27  
Paperback £12.62  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Special Offers and Product Promotions

  • Purchase any Kindle Book sold by and receive £1 credit to try out our Digital Music Store. Here's how (terms and conditions apply)

Customers Who Bought This Item Also Bought

Product Description

Product Description

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain.. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly.

The success of your career as a DBA depends largely on how well-prepared you are to deal with such situations. Without verified backups, sound server documentation, and a ready supply of tried-and tested troubleshooting tools, there is no safe place to hide when the monster rears up. All you can do is buy some time, patch things up as best you can and then duck away into your cubicle, which, if you lost any data in the process, may soon be empty.

However, with the tools and techniques provided in the SQL Server Tacklebox, you will be fully-equipped to fight back. Inside, you'll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending danger, secure access to your servers and fight off data corruption.

In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live.

Product details

  • Format: Kindle Edition
  • File Size: 9859 KB
  • Print Length: 250 pages
  • Publisher: Red Gate Books; 1 edition (3 Aug 2009)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B0046A9SOE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Amazon Bestsellers Rank: #197,388 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  5 reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars Very useful 1 Oct 2009
By Anthony R. Miller - Published on
This is a book above my current experience level. That doesn't mean it isn't useful to me.

By the time I started chapter 3 I: learned new ways to install SQL Server. I have a better understanding of the importance of seperate drives for the data & logs. Most importantly I've learned the importance of DOCUMENTATION.

I've been able to compare what I got from Forta's T-SQL in 10 to the scripts provided in the book and follow them. Do you remember when SQL, or any form of programming, was new to you and how great you felt when you were able to read somebody's code and understand it? Yeah, that rocks.

I have liked being able to take the scripts from the book and run them against my install of SQL Server 2008 Express and see the results.

The author's sense of humor helped make what could be dry material fun to read.
1 of 1 people found the following review helpful
5.0 out of 5 stars Review of SQL Server Tacklebox 2 Aug 2010
By Pat Byrne - Published on
SQL Server Tacklebox is a must have for the technical library of any DBA. I found this book both interesting and informative. It was well written with a lot of detailed information and many code samples. This book walks you through the processes of Installing and Securing SQL Server and also provides great insight into how to monitor and manage it in order to keep it running smoothly. Rodney backs up his writing with numerous real world examples that he has encountered through his work experience, including the DBA Repository. I highly recommend paying special attention to chapter 2 which covers the DBA Repository in great detail.

If had to begin discarding most of the resources in my technical library, rest assured this book would be one of the last, if not "the last" to go.

As a footnote, I've had the opportunity to hear Rodney speak on several occasions. I would highly recommend attending any of his sessions if you ever have the opportunity to hear him speak at a SQL Saturday or Code Camp. Above all, Rodney is probably about the most genuine guy that you'd ever want to meet. He has always had to time to thoroughly answer my questions or just chat about life in general.
1 of 1 people found the following review helpful
4.0 out of 5 stars If you use SQL Server consider this book 21 Sep 2009
By Ralph C - Published on
Readable, informative, thorough, and (above all) very useful. Lots of examples, illustrations, and references. A valuable tool for every DP professional who touches SQL Server in any capacity.
4.0 out of 5 stars Add more tools to your box 30 Nov 2010
By Eric Wisdahl - Published on
I have read a lot of SQL books by now, so a lot of what I get from them is just picking up on little things. For example, I did my first command line install because of the SQL Server Tacklebox and would recommend that to my team going forward. Also, I had heard of items like sp_foreachdb and tabledifference, but getting reminded of them will make me more likely to use them.

The idea of storing information relating to all of your databases in a central location is certainly not new, but Rodney does a pretty good job of showing how easy it is that this can be accomplished. The scripts and SSIS packages provided will lay the foundation for any new DBA in this endeavor. And, even if you aren't planning on implementing the central repository, these scripts will help to understand the important topics being addressed. All in all a very easy read.
5.0 out of 5 stars Five Stars 9 Aug 2014
By George F Rasco - Published on
Good BooK!
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category