Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Kindle Price: £7.88
includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Troubleshooting SQL Server: A Guide for the Accidental DBA by [Kehayias, Jonathan, Krueger, Ted, Shaw, Gail]
Kindle App Ad

Troubleshooting SQL Server: A Guide for the Accidental DBA Kindle Edition

5.0 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"

Length: 356 pages Enhanced Typesetting: Enabled Page Flip: Enabled

Kindle Books from 99p
Load up your Kindle library before your next holiday -- browse over 500 Kindle Books on sale from 99p until 31 August, 2016. Shop now

Product details

  • Format: Kindle Edition
  • File Size: 2242 KB
  • Print Length: 356 pages
  • Page Numbers Source ISBN: 1906434786
  • Publisher: Red Gate Books; 1 edition (30 Jun. 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00DQ9JYG8
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Enabled
  • Average Customer Review: 5.0 out of 5 stars 2 customer reviews
  • Amazon Bestsellers Rank: #226,858 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback

I have written a chapter-by-chapter review of this book on i-programmer DOT info, the first part of this review follows:

This Book aims to provide solutions to the most common problems encountered by the inexperienced (accidental) DBA. How does it fare?

The premise behind the book's title is that many DBA roles are filled accidentally, often by the developer that has the most database knowledge. This typically results in a steep and stressful learning curve, as mistakes are made. This book, which can be downloaded as a free pdf file from www.red-gate.com/community/books/accidental-dba aims to help the accidental DBA overcome the most common problems.

The book was published in September 2011, and covers SQL Server 2005, 2008, and 2008 R2. It occasionally drops back to SQL Server 2000 and jumps forward to Denali (the name of the beta version of SQL Server 2012). Although SQL Server 2012 is not covered explicitly, I think 95% of the book is still applicable to SQL Server 2012.

Considering how much it covers, this is a short book, it could have easily been twice as big. Luckily it concentrates on what you need to know, and provides useful links for further reading. In many ways its limited size makes it more difficult to criticize negatively. The first seven chapters (of nine) read like a guide to performance tuning and troubleshooting. So it comes as a surprise when the last two chapters switch to admin related issues. Some useful code is supplied, while it is adequate for the introduction of a topic, if you want to delve deeper you will need to rely on the chapter text to extend the code or look elsewhere. One small gripe is the lack of diagrams and outputs...
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
clear and well presented guide with lots of very useful queries, suitable for the beginner and the experienced software engineer
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 4.7 out of 5 stars 13 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Excellent, a must have for DBA's! 11 Nov. 2012
By Anke - Published on Amazon.com
Format: Paperback Verified Purchase
I have followed Jonathan's blog for some time before purchasing this book. This book is a great collection of information centrally located and easy to get to without having to navigate Jonathan's blog or other articles he may have published around the web.

The book features a wealth of information for any of us that were born a DBA, but rather had it add as a job feature along with everything else we are currently maintaining! It is nice to be able to go through the book and have access to the code from the book to add to some of the SSIS jobs I had created.

This is a great book that is well worth the price!!
4 of 4 people found the following review helpful
5.0 out of 5 stars the desert island DBA's book 14 Mar. 2012
By R. Reid - Published on Amazon.com
Format: Paperback Verified Purchase
If I were a DBA stuck on a dessert island and could have only one book, I think this is it.

As the subtitle suggests ("accidental" dba) - this is especially helpful to those of us who really do know what we're doing most of the time, but may be fuzzy around the edges.

For example, I do understand how SQL Server manages memory; but over the years I've had to guess at times on machines that had been overconsolidated with multiple instances and hundreds of databases. That's covered concisely on pages 160 and 161.

Jonathan and Ted also understand well that one can't always get just what is wanted or needed for the servers, and that sometimes we need to do the best we can with what we've got.

A word of warning: when you get this book, you may have an impulse to push it in a manager's or SAN administrator's face saying "See! I didn't make this stuff up!".

That's of course a poor idea. Use this to educate and to explain the impact of choices made.
3 of 3 people found the following review helpful
5.0 out of 5 stars A must have book for any DBA. 1 Nov. 2012
By Timothy R. - Published on Amazon.com
Format: Paperback
This book is a must have for any DBA. I have made reading this book a requirement for any advancement for my DBA's. This book is full of critical information that we need in order to better before our jobs. Both Ted and Jonathan are very highly respected in the database field and both spend countless hours in forums helping others. They have taken their years of experience and created one of the best books I have ever read. I have this book in both paper and electronic form. I recommend it at every user group and SQL Saturday that I present at.

This book is truly 5 stars.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great book for anyone working with SQL Server 28 Jan. 2012
By John Dunleavy - Published on Amazon.com
Format: Paperback
I bought this book while looking for some new material to help teach some of my colleagues who are new DBAs. When I saw the author I remembered that Jonathan was someone who had helped me numerous times in the past on the internet, and through #SQLHELP on twitter, so I knew it was by a true expert.

This book is very well written and it gives you a literal toolbox to help diagnose and fix most of the issues you can have in SQL Server today. You can just turn to the section that describes the symptoms you are currently experiencing, and it then walks you through the diagnosis step by step like you were solving the problem together.

I loved the way it described the background knowledge too. It included just enough to understand and then included links to blogs and other useful resources so you can drill down into certain topics in greater detail later. This really kept the background knowledge of certain things from distracting the reader from their main task which is to diagnose the issue at hand. This made the book a literal tool for active troubleshooting on the fly. Now my new DBAs can experience issues and just open this book and follow the strategies described to get to the route of the problem quickly. It also includes many useful diagnostic queries that you will use every day too.

After having read this book now, and after using its strategies and tools first hand, I can honestly say that it is a must read for not only new DBAs, but also for just about anyone who is currently working with SQL Server.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great resource for SQL Server administrators 26 Nov. 2011
By Brent Ozar - Published on Amazon.com
Format: Paperback
Jonathan and Ted are forum monsters: they're constantly patrolling user questions looking for ways they can help. As a result, they're well-versed in the typical problems DBAs face and the best ways to solve those problems. They've compiled the results into a book. The book reads like a very polished forum answer: if you've got a CPU problem, turn to Chapter 3. You'll learn what tools to use to diagnose the issue, the most common problems, and the best solutions.

Jonathan was one of the coauthors on Professional SQL Server 2008 Internals and Troubleshooting, and at first glance, it might sound like those two books are similar. This book is different because it takes a problem-and-solution approach, whereas our Pro 2008 Internals teaches the reader about internals first, then explains troubleshooting tools you can use to look under the hood. I'd say that Troubleshooting SQL Server is a faster approach to getting `er done, and I'm adding it to my list of recommended books for SQL Server DBAs.
Were these reviews helpful? Let us know
click to open popover