Sign in to turn on 1-Click ordering.
Trade in Yours
For a £4.21 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

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, Volume 2 [Paperback]

Kalen Delaney , Louis Davidson , Greg Low , Brad McGhee , Paul Nielson , Paul Randal , Kimberly Tripp , 64 MVP Authors
4.0 out of 5 stars  See all reviews (3 customer reviews)
RRP: £38.99
Price: £31.99 & FREE Delivery in the UK. Details
You Save: £7.00 (18%)
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 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Monday, 22 Sep.? Choose Express delivery at checkout. Details
Trade In this Item for up to £4.21
Trade in SQL Server MVP Deep Dives, Volume 2 for an Amazon Gift Card of up to £4.21, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

24 Oct 2011 9781617290473 978-1617290473 1


SQL Server MVP Deep Dives, Volume 2 is a unique book that lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more.

About this Book

To become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters and offers valuable insights for readers of all levels.

SQL Server MVP Deep Dives, Volume 2 picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.

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.

What's Inside
  • Discovering servers with PowerShell
  • Using regular expressions in SSMS
  • Tuning the Transaction Log for OLTP
  • Optimizing SSIS for dimensional data
  • Real-time BI and much more

Manning Publications and the authors of this book support the children of Operation Smile, an international children's medical charity that performs free reconstructive surgery for children suffering from facial deformities such as cleft lips and cleft palates by mobilizing medical volunteers who provide education and training programs to local doctors on the latest surgical techniques.


Table of Contents

    PART 1 ARCHITECTURE Edited by Louis Davidson
  1. Where are my keys? by Ami Levin
  2. "Yes, we are all individuals" A look at uniqueness in the world of SQL by Rob Farley
  3. Architectural growth pains by Chris Shaw
  4. Characteristics of a great relational database by Louis Davidson
  5. Storage design considerations by Denny Cherry
  6. Generalization: the key to a well-designed schema by Paul Nielsen
  7. PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp
  8. Increasing availability through testing by Allan Hirt
  9. Page restores by Gail Shaw
  10. Capacity planning by Greg Larsen
  11. Discovering your servers with PowerShell and SMO by Joe Webb
  12. Will the real Mr. Smith please stand up? by John Magnabosco
  13. Build your own SQL Server 2008 performance dashboard by Pawl Potasinski
  14. SQL Server cost recovery by Peter Ward
  15. Best practice compliance with Policy-Based Management by Rod Colledge
  16. Using SQL Server Management Studio to the fullest by Rodney Landrum
  17. Multiserver management and Utility Explorer - best tools for the DBA by Satya Shyam K. Jayanty
  18. Top 10 SQL Server admin student misconceptions by Tibor Karaszi
  19. High availability of SQL Server in the context of Service Level Agreements by Tobiasz Janusz Koprowski
  20. PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen
  21. T-SQL: bad habits to kick by Aaron Bertrand
  22. Death by UDF by Kevin Boles
  23. Using regular expressions in SSMS by John Paul Cook
  24. SQL Server Denali: what's coming next in T-SQL by Sergio Govoni
  25. Creating your own data type by Hugo Kornelis
  26. Extracting data with regular expressions by Matija Lah
  27. Relational division by Peter Larsson
  28. SQL FILESTREAM: to BLOB or not to BLOB by Ben Miller
  29. Writing unit tests for Transact-SQL by Luciano Moreira
  30. Getting asynchronous with Service Broker by Mladen Prajdic
  31. Effective use of HierarchyId by Denis Reznik
  32. Let Service Broker help you scale your application by Allen White
  34. Hardware 201: selecting and sizing database server hardware by Glenn Berry
  35. Parameter sniffing: your best friend...except when it isn't by Grant Fritchey
  36. Investigating the plan cache by Jason Strate
  37. What are you waiting for? An introduction to waits and queues by Robert Pearl
  38. You see sets, and I see loops by Linchi Shea
  39. Performance-tuning the transaction log for OLTP workloads by Brad M. McGehee
  40. Strategies for unraveling tangled code by Jennifer McCown
  41. Using PAL to analyze SQL Server performance by Tim Chapman
  42. Tuning JDBC for SQL Server by Jungsun Kim
  44. Creating a formal Reporting Services report part library by Jessica M. Moss
  45. Improving report layout and visualization by Greg Low
  46. Developing sharable managed code expressions in SSRS by William Vaughn
  47. Designing reports with custom MDX queries by Paul Turley
  48. Building a scale-out Reporting Services farm by Edwin Sarmiento
  49. Creating SSRS reports from SSAS by Robert Cain
  50. Optimizing SSIS for dimensional data loads by Michael Coles
  51. SSIS configurations management by Andy Leonard
  52. Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah
  53. Late-arriving dimensions in SSIS by John Welch
  54. Why automate tasks with SSIS? by Ted Krueger
  55. Extending SSIS using the Script component by Tim Mitchell
  56. ETL design checklist by Rafael Salas
  57. Autogenerating SSAS cubes by Johan Ahlen
  58. Scripting SSAS databases - AMO and PowerShell, Better Together by Darren Gosbell
  59. Managing context in MDX by Boyan Penev
  60. Using time intelligence functions in PowerPivot by Thiago Zavaschi
  61. Easy BI with Silverlight PivotViewer by Gogula Aryalingam
  62. Excel as a BI frontend tool by Pedro Perfeito
  63. Real-time BI with StreamInsight by Allan Mitchell
  64. BI solution development design considerations by Siddharth Mehta

Frequently Bought Together

SQL Server MVP Deep Dives, Volume 2 + SQL Server MVP Deep Dives
Price For Both: £67.08

Buy the selected items together
  • SQL Server MVP Deep Dives £35.09

Product details

  • Paperback: 688 pages
  • Publisher: Manning Publications; 1 edition (24 Oct 2011)
  • Language: English
  • ISBN-10: 9781617290473
  • ISBN-13: 978-1617290473
  • ASIN: 1617290475
  • Product Dimensions: 3 x 18.3 x 23 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 470,981 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Over 60 SQL Server MVPs contributed to this book, which was assembled and edited by Kalen Delaney and SQL Server legends Louis Davidson (Database Design and Architecture), Greg Low (Business Intelligence.), Brad McGhee (Performance Tuning and Optimization), Paul Nielson (Database Development), and Paul Randal and Kimberly Tripp (Database Administration.)

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4 star
3 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
2.0 out of 5 stars The difficult sequel... 26 Jan 2012
Format:Paperback|Verified Purchase
Not every success needs a sequel. Compared to the excellent vol. 1 there are several problems with this vol. 2. It is much more fragmented with many more contributors, perhaps all flocking to become part of a success. In other words, vol. 1 had longer articles with all the space needed and wanted by the author to deal with a given subject. The typical vol. 2 article is longer than a "mere" useful tip, but too short to really go anywhere - in other words: empty calories, idling... - This is all not to say the book is worthless, far from it , here and there it definitely has it highs as well the (too many) lows - hence two stars after all.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars More top notch content from SQL Server MVPs 3 Mar 2012
There is no doubting the quality and content in this title. If I am 100% honest then I was disappointed that this book is thinner than version 1, by some 160 pages but has a similar chapter count, this, to my mind, means we are not diving quite so deep. There are lots of new areas covered and lots of new names as authors so it is still well worth investing in.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excellent book - level 400 2 Jan 2012
By J. Alan
Format:Paperback|Verified Purchase
Level 400 - i.e. for MCITP+ depth
As good as the first 'deep dives' book.

Make sure you contact the publisher if you want the pdf version though, Amazon purchases do not automatically update their database.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  1 review
5.0 out of 5 stars This is a must read for any serious DB Admin/Dev 12 Nov 2012
By Eduardo Angeles - Published on Amazon.com
Format:Paperback|Verified Purchase
The articles here are all very good. I cannot say enought good things about the book. If you have or haven't attended a SQL Saturday or a SQL pass summit, read this book to see what you are missing or strengthen concepts presented at these SQL events.
Was this review helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category