Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $6.18 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL Server MVP Deep Dives [Paperback]

by Paul Nielsen, Kalen Delaney, Adam Machanic, Kimberly Tripp, Paul Randal, Greg Low
4.3 out of 5 stars  See all reviews (13 customer reviews)

List Price: $59.99
Price: $40.04 & FREE Shipping. Details
You Save: $19.95 (33%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 5 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it Monday, April 28? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Paperback $40.04  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

December 20, 2009 1935182048 978-1935182047 1

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you.

SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI.

Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit for more information.

Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

Frequently Bought Together

SQL Server MVP Deep Dives + SQL Server MVP Deep Dives, Volume 2 + Microsoft SQL Server 2008 Internals (Developer Reference)
Price for all three: $120.71

Buy the selected items together

Editorial Reviews

About the Author

Paul Nielsenis a Microsoft SQL Server MVP and contributed to Microsoft’s offi-cial SQL Server courses. He’s a database developer and trainer, and previously wrote SQL Server Bible (Wiley) and lives in Colorado.

Kalen Delaney is a Microsoft MVP who has worked with SQL Server since 1987. She’s a subject-matter expert on Microsoft's official SQL Server courses and previously wrote Inside SQL Server(Microsoft Press). She lives in the Pacific Northwest.

Adam Machanic lives in Boston, is a regular usergroup speaker and has written for SQL Server magazines. He’s a Microsoft MVP and Certified IT Professional and previously wrote Expert SQL Server 2005 Development (APress).

Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. She lectures for a variety of events including Microsoft Tech Ed and is married to co-editor and SQL guru Paul Randal. Paul Randal and wife Kimberly L. Tripp are two of the most-sought-after SQLServer speakers in the world. A Microsoft MVP and Regional Director, Paul is alsocontributing editor to TechNet Magazine.

Greg Low is one of only three Microsoft MSDN Regional Directors for Australia.He hosts the SQL Down Under podcast and organizes multiple SQL Code Camp events.

Product Details

  • Paperback: 848 pages
  • Publisher: Manning Publications; 1 edition (December 20, 2009)
  • Language: English
  • ISBN-10: 1935182048
  • ISBN-13: 978-1935182047
  • Product Dimensions: 9.2 x 7.3 x 1.7 inches
  • Shipping Weight: 3.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #739,187 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews
18 of 19 people found the following review helpful
5.0 out of 5 stars Great Book even without the cause November 8, 2009
I bought this book for full price at the SQL PASS conference in 2009 and I didn't even feel bad about paying full price because of the cause. After reading through a number of the chapters, I still don't feel bad for paying full price :-)

This book contains 59 golden nuggets. You name the topic and there is likely a white paper quality or beyond chapter for your interest. From Database Design, to development best practices to complex administrative or BI issues, it covers it.

I could not put the book down on my flights back and still have managed to find the time to leaf throw more. I will be suggesting all of the developers and system administrators (part reluctant DBA) purchase their own copy (primarily because I don't want to share my copy :-P) and get learning.

Some great approaches to common problems, some great forays into areas I have, unfortunately, not forced myself to get into (like Power Shell for my administrative tasks). I will be taking some of the tips, like the Tools database and Aaron Bertrand's version of a great utility script to easily show the important info on active tasks, and putting them to use as early as I find the time next week.

I am also going to force my SSIS developers to read Andy Leonard's chapter on Incremental loads and other SSIS chapters while re-reading Erin Welker's chapter on BI For the relational guy (that's me) a few times myself.

Every chapter is top quality and I really liked the in depth approach. This is a good reference to add to a library with some of the great internals books or in depth books on a single topic. Also nice knowing that these top notch MVPs, mostly all great speakers and authors, gave up their time and royalties to give to a worthy cause.
Comment | 
Was this review helpful to you?
14 of 15 people found the following review helpful
5.0 out of 5 stars Wow! December 24, 2009
Format:Paperback|Verified Purchase
Wow! Actually this could be the whole review, but I guess it does need some elaboration. This book is bound to become a classic just like Ken England's book on performance of SQL 2000 used to be, or the Inside Microsoft SQL Server series is now.

It does not happen that often that I keep postponing all but the pressing task at work to read yet another chapter. Can someone be called an SQL addict? This book may well make you one. So I've tried to get to the bottom of it and understand what is it that they have done so right. It is not only that the book is written by people who know what they are writing about, and that they display the essence of various topics which most of us have accumulated only through reading many other sources. Here it is all distilled and presented in one single volume of 59 chapters. But more than that, it seems that they have found the ultimate golden ratio in the size of the chapters, roughly between 8 to 13 pages, so that each can be covered in one short read without distraction. Almost like reading a collection of short stories by Edgar Allan Poe or William Somerset Maugham.

Have you ever spent time going through the 1204 trace flag deadlock graphs and then made the transition to the new trace flag 1222? Here it is, explained clearly without the need to go to BOL or the web. The benefits of a covering index? Which DMVs to use? Even the absurdity of using a shrink database task in a maintenance plan (why do they offer such a thing in the first place?). It is all here. The range of topics is impressive.

I have to admit I have not read more than a seventh of the book (only got it two days ago), jumping from one topic to another, having to balance what I am interested in most, and what would immediately be applicable to my current work, but even without a FULLSCAN there is little doubt that this volume will be enthusiastically received by developers and DBAs across the globe.
Comment | 
Was this review helpful to you?
10 of 10 people found the following review helpful
5.0 out of 5 stars Trusted Knowledge November 8, 2009
This is like a dream book. The best, most knowledgeable, and helpful, SQL Server experts each get to pick a topic of their own and write about it. Things gets better. The book then gets edited by some of the great names in SQL Server over the last 10 years (and more). But, do these fantastic people stop there? No. They go on and write the whole book for charity. All the author royalties are going to support War Child International. Over the years, I've read books and articles by many of these people. I've also attended classes or conference sessions presented by them. I've even had the opportunity and privilege of talking to quite a few them both online and in person. These people are not only well versed in SQL Server technology, but they're nice, funny, and friendly people.

Enough about them, let's talk about the book. There are 59 different chapters, written by one or more of the MVP's involved with the book. The chapters are broken down into five different sections; Database Design and Architecture, Database Development, Database Administration, Performance Tuning and Optimization, and Business Intelligence. In other words, something for everyone.

You probably should sit and read this book cover to cover, straight through, but I've found myself jumping from one topic to another. For example, Joe Webb's chapter on indexes and column order was immediately useful. Like all the chapters, it's direct and clear, with some good sample code, a few screen captures and a great explanation of the concepts that it's going after. Lots of people will benefit from Gail Shaw's description of how to trace deadlocks. But then I had to jump right back to Chapter 1 and read Louis Davidson & Paul Nielsen's chapter on relational design ideas. It's hard to settle on a single topic.
Read more ›
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Absolutely essential if trying to grow as a DBA.
One of the few SQL books I consider a must-have. It's not for beginners, but it's absolutely essential to get the most of it. Read more
Published 11 months ago by The Rev
3.0 out of 5 stars Good reference book
The book is good in most areas, but there are some subjects that I question as a long time data architect/DBA/Modeler. Read more
Published 14 months ago by Fishing Guy
5.0 out of 5 stars Awesome SQL Server Resource
My latest SQL read was SQL Server MVP Deep Dives. It's a compilation - 59 chapters - on various SQL Server topics, written by Microsoft MVPs. Read more
Published 23 months ago by Jes Schultz Borland
2.0 out of 5 stars Shallow dive
This book is more like a beach reef dive. It shows you lots of little samples but does not go far or deep into anything. Read more
Published on June 20, 2011 by Marcelo G Silva
1.0 out of 5 stars Deep Dives is really Shallow
After seeing what I thought was the author list and given the title "Deep Dives", I was really excited about the book. Read more
Published on November 16, 2010 by M. Sullivan
5.0 out of 5 stars Technically illuminating and human readable.
I agree with the other reviewers here, this is an exceptional book. I love the format - 50 some different essays on specific SQL Server topics. It works for me. Read more
Published on March 6, 2010 by Amazon Customer
5.0 out of 5 stars SQL Server MVP Deep Dives: Highly Recommended
I didn't buy this book the day it came out because despite the fact that all 53 of the contributors are SQL Server MVPs (indeed some of the the world's leading experts and... Read more
Published on February 23, 2010 by Mitchell Wheat
5.0 out of 5 stars $12K for WarChild
On behalf of the 53 MVPs who collaberated on the SQL Server MVP Deep Dives book , I'm pleased to say thank you to the many who have purchased the book. Read more
Published on February 18, 2010 by Paul Nielsen
5.0 out of 5 stars Very good details on top of Your SQL server knowledge
When You try to learn something to a deeper level, a book like this is good to get.

Not trying to reach everything, but going the step extra on selected areas. Read more
Published on January 30, 2010 by Gunnar Venaas
5.0 out of 5 stars Amazing SQL Server Resource
This book was written by 49 different SQL Server MVPs (who are well-known experts and contributors to the SQL Server community), who are all donating their royalties to War Child... Read more
Published on November 8, 2009 by Glenn Berry
Search Customer Reviews
Only search this product's reviews

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


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category