Programming Books C Java PHP Python Learn more Browse Programming Books
Troubleshooting SQL Server: A Guide for the Accidental DBA and over one million other books are available for Amazon Kindle. Learn more
Buy New
$27.06
Qty:1
  • List Price: $35.99
  • Save: $8.93 (25%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $10.95
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Troubleshooting SQL Server - A Guide for the Accidental DBA Paperback – September 26, 2011


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$27.06
$21.99 $22.00

Frequently Bought Together

Troubleshooting SQL Server - A Guide for the Accidental DBA + Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)
Price for both: $48.38

One of these items ships sooner than the other.

Buy the selected items together

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for FREE. Print edition purchase must be sold by Amazon. Learn more.


Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

Product Details

  • Paperback: 370 pages
  • Publisher: Red gate books (September 26, 2011)
  • Language: English
  • ISBN-10: 1906434786
  • ISBN-13: 978-1906434786
  • Product Dimensions: 9.2 x 7.5 x 0.8 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #493,726 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Jonathan Kehayias is currently employed as a Principal Consultant and Trainer for SQLskills, one of the best-known and most respected SQL Server training and consulting companies in the world. Jonathan is a SQL Server MVP and one of the few Microsoft Certified Masters for SQL Server 2008, outside of Microsoft. Jonathan frequently blogs about SQL Server, presents sessions at PASS Summit, SQLBits, SQL Connections and local SQL Saturday events, and has remained a top answerer of questions on the MSDN SQL Server Database Engine forum since 2007. Jonathan is a performance tuning expert for both SQL Server and hardware, and has architected complex systems as a developer, business analyst, and DBA. He also has extensive development (T-SQL, C#, and ASP.Net), hardware and virtualization design expertise, Windows expertise, Active Directory experience, and IIS administration experience. Outside of SQL Server, Jonathan is also a Drill Sergeant in the US Army Reserves and is married with two young children. On most nights he can be found at the playground, in a swimming pool, or at the beach with his kids.

Ted Krueger is a Senior SQL Server consultant for a respected Microsoft Partner company. He is an MVP, author, blogger, speaker, volunteer, and mentor. Working with SQL Server for over a decade, Ted's areas of expertise are SSIS, high-availability, mirroring, and replication, as well as embracing all the other features that come along with this powerful database server. He works tirelessly to educate and help others in the community. He is a co-founder of the technical community at LessThanDot.com. Ted can also be found answering forum questions, working as a PASS regional mentor, answering questions on Twitter, and fishing and golfing in his spare time.


More About the Author

Jonathan Kehayias is currently employed as a Principal Consultant and Trainer for SQLskills, one of the best-known and most respected SQL Server training and consulting companies in the world. Jonathan is a SQL Server MVP and one of the few Microsoft Certified Masters for SQL Server 2008, outside of Microsoft. Jonathan frequently blogs about SQL Server, presents sessions at PASS Summit, SQLBits, SQL Connections and local SQL Saturday events, and has remained a top answerer of questions on the MSDN SQL Server Database Engine forum since 2007.

Jonathan is a performance tuning expert for both SQL Server and hardware, and has architected complex systems as a developer, business analyst, and DBA. He also has extensive development (T-SQL, C#, and ASP.Net), hardware and virtualization design expertise, Windows expertise, Active Directory experience, and IIS administration experience. Outside of SQL Server, Jonathan is also a Drill Sergeant in the US Army Reserves and is married with two young children. On most nights he can be found at the playground, in a swimming pool, or at the beach with his kids.

Customer Reviews

4.6 out of 5 stars
5 star
8
4 star
0
3 star
0
2 star
0
1 star
1
See all 9 customer reviews
One of the best troubleshooting books I have read.
Chithra Kumar
You'll learn what tools to use to diagnose the issue, the most common problems, and the best solutions.
Brent Ozar
I have this book in both paper and electronic form.
TRAD

Most Helpful Customer Reviews

3 of 3 people found the following review helpful By Anke on November 11, 2012
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!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By R. Reid on March 14, 2012
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By TRAD on November 1, 2012
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By John Dunleavy on January 28, 2012
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Brent Ozar on November 26, 2011
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again