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.
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.