We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we've been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we've seen the same problems and the same misconceptions about how SQL Server works crop up time-and-again. This book is our attempt to describe, diagnose, and solve some of the most common problems associated with the currently-supported versions of SQL Server: SQL Server 2005, 2008, and 2008 R2.
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now |
Book Description
Frequently Bought Together
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.
Product Details
Would you like to update product info or give feedback on images? |
More About the Authors
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
By Anke
Format:Paperback|Amazon 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!!
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!!
2 of 2 people found the following review helpful
By TRAD
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.
This book is truly 5 stars.
2 of 2 people found the following review helpful
By R. Reid
Format:Paperback|Amazon 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.
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.
Most Recent Customer Reviews
5.0 out of 5 stars
Troubleshooting SQL Server
This is a very nice book. Many questions in SQL server are in this book. This book solve these questions step by step.
Published 3 months ago by spisces
5.0 out of 5 stars
Great book for anyone working with SQL Server
I bought this book while looking for some new material to help teach some of my colleagues who are new DBAs. Read more
Published 16 months ago by John Dunleavy
5.0 out of 5 stars
Great resource for SQL Server administrators
Jonathan and Ted are forum monsters: they're constantly patrolling user questions looking for ways they can help. Read more
Published 18 months ago by Brent Ozar
What Other Items Do Customers Buy After Viewing This Item?
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Listmania!
|
|
