- 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
- Word Wise: Not Enabled
- Average Customer Review: 2 customer reviews
- Amazon Bestsellers Rank: #226,858 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
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.
To get the free app, enter your mobile phone number.
Troubleshooting SQL Server: A Guide for the Accidental DBA Kindle Edition
|New from||Used from|
Customers Who Bought This Item Also Bought
Top Customer Reviews
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...
Most Helpful Customer Reviews on Amazon.com (beta)
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!!
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.
This book is truly 5 stars.
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.
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.