Customer Reviews

SQL Server MVP Deep Dives

5 star:		(8)
4 star:		(0)
3 star:		(0)
2 star:		(1)
1 star:		(1)

 

 

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.

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.

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. Michael Coles has two chapters on XML, both are worth a read, especially if you're moving from SQL Server 2000 into 2005/2008 where you can begin to put XQuery to work instead of using OPENXML. It just goes on and on, your favorite MVP's from all around the world writing on hand-picked topics, edited by experts in the field.

The printing itself is very well done. The seperation between the text, code and notes is very clear. The graphics are also clearly printed and very readable. The binding seems very well done. It's held up well to my initial, constant, thumbing from one article to another.

Taken as a whole, tons of experts covering a huge swath of information in a very well put together book that benefits an imminently worthy charity... Why are you still reading this? Get a copy and see how it can improve your own system, your own designs, your own code, and feel good knowing purchasing the book helps not just you and your organization, but other people all over the world, kids.

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 International. Each author was able to choose their subject, something they were knowledgable and passionate about. This means that there is no filler or fluff material, nothing the author had to write about to get the page count up.

The book is divided into five sections, (Database design and Architecture, Database Development, Database Administration, Peformance Tuning and Optimization, and Business Intelligence), which does a good job of covering both SQL Server 2005 and SQL Server 2008. Each chapter was tech reviewed by at least two other SQL MVPs, and then reviewed by the MVP section editor, before the publisher's editing staff did their copy editing work. All of this means that it is a very high quality book, packed full of great information.

I know all of this because I was lucky enough to write two chapters for the book. I just received my copy of the book at SQL PASS in Seattle. I wanted to thank Paul Nielsen for organizing this project, and all of the authors and the publisher for making it possible.

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.

I for one appreciated this book.

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. I want to keep up with things but I don't have it in me to read an 800 page SQL Server book every month. I can read a 15 page essay about a particular topic though. Plus, the book covers a wide variety of material, from basic design ideas to the SQL CE, XML, BI, PowerShell, amongst many others.

What I've read has been clearly written and insightful. It's actually pleasant to read.

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 practitioners), I wondered if the fact that there were so many authors, it might mean the chapters would be just 'sound bites' with only a moderate amount of interesting content.

I could not have been more wrong! In fact, it is the complete opposite. Over the last 4 weeks, I've learnt something significant and useful each time I've picked this book up, either directly about SQL Server or one of the associated technologies. I challenge you to pick this book up, open it at random and read a couple of pages, and not learn something useful.

The blurb states "This is no ordinary SQL Server book" and it's not. There are insights and practical know-how that are the result of years of real-world experience working with SQL Server.

The book is divided into 5 sections, broadly divided into the 5 job roles based around SQL Server:

1. Database Design and Architecture
2. Database Development
3. Database Administration
4. Performance Tuning and Optimisation
5. BI Development

The 59 chapters cover material for newcomers and pros, developers and DBAs alike, including some of the new features of SQL Server 2008.

Purchasing the hard copy book, also gets you bonus access to a free pdf version of the book. [The authors of this book have donated 100% of their royalties to support War Child International]

An excellent book, and I'm glad I bought it. Highly recommended.

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. Together we have raised $12,400 for [...].

If you haven't yet purchased the book, you should: no other tech book is such a win/win proposition. 100% of the author royalties goes helps children traumatized by war, you get 59 great chapters, and MVPs got to share their expertise in a collaborative effort.

[...].

[....].

After seeing what I thought was the author list and given the title "Deep Dives", I was really excited about the book. I figured a list of MVPs diving into difficult subjects would be really interesting.

Unfortunately, the book is an overview without any deep dives at all. The chapters provide less detail than the average BOL page. For example there is a full chapter on how to join tables, another chapter informs us that indexes can help with queries and even introductions to XML, Reporting Services, Profiler, etc.

Basically the book is a collection of 59 chapters of "Hello World" to various featuers and is what you would expect from a Microsoft Marketing Presentation on the wonders of SQL Server.

You will see the big name authors advertised, but they did not write any of the chapters. They are "editors" of others work.

If you are interested in in-depth knowledge of SQL Server, I doubt you will get any value from this book, unless you are a SQL Server Newbie.

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. You may even find a nurse sharks or a lobster but dont expect anything extraordinary.