SQL Server MVP Deep Dives, Volume 2



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

See more details below
BN.com price
(Save 30%)$59.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (13) from $30.14   
  • New (9) from $33.80   
  • Used (4) from $30.14   
Sending request ...



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

    Edited by Louis Davidson
  2. Where are my keys? by Ami Levin
  3. "Yes, we are all individuals"
    A look at uniqueness in the world of SQL by Rob Farley
  4. Architectural growth pains by Chris Shaw
  5. Characteristics of a great relational database by Louis Davidson
  6. Storage design considerations by Denny Cherry
  7. Generalization: the key to a well-designed schema by Paul Nielsen

  8. PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp
  9. Increasing availability through testing by Allan Hirt
  10. Page restores by Gail Shaw
  11. Capacity planning by Greg Larsen
  12. Discovering your servers with PowerShell and SMO by Joe Webb
  13. Will the real Mr. Smith please stand up? by John Magnabosco
  14. Build your own SQL Server 2008 performance dashboard by Pawl Potasinski
  15. SQL Server cost recovery by Peter Ward
  16. Best practice compliance with Policy-Based Management by Rod Colledge
  17. Using SQL Server Management Studio to the fullest by Rodney Landrum
  18. Multiserver management and Utility Explorer - best tools for the DBA by Satya Shyam K. Jayanty
  19. Top 10 SQL Server admin student misconceptions by Tibor Karaszi
  20. High availability of SQL Server in the context of Service Level Agreements by Tobiasz Janusz Koprowski

  21. PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen
  22. T-SQL: bad habits to kick by Aaron Bertrand
  23. Death by UDF by Kevin Boles
  24. Using regular expressions in SSMS by John Paul Cook
  25. SQL Server Denali: what's coming next in T-SQL by Sergio Govoni
  26. Creating your own data type by Hugo Kornelis
  27. Extracting data with regular expressions by Matija Lah
  28. Relational division by Peter Larsson
  29. SQL FILESTREAM: to BLOB or not to BLOB by Ben Miller
  30. Writing unit tests for Transact-SQL by Luciano Moreira
  31. Getting asynchronous with Service Broker by Mladen Prajdic
  32. Effective use of HierarchyId by Denis Reznik
  33. Let Service Broker help you scale your application by Allen White

  35. Hardware 201: selecting and sizing database server hardware by Glenn Berry
  36. Parameter sniffing: your best friend...except when it isn't by Grant Fritchey
  37. Investigating the plan cache by Jason Strate
  38. What are you waiting for? An introduction to waits and queues by Robert Pearl
  39. You see sets, and I see loops by Linchi Shea
  40. Performance-tuning the transaction log for OLTP workloads by Brad M. McGehee
  41. Strategies for unraveling tangled code by Jennifer McCown
  42. Using PAL to analyze SQL Server performance by Tim Chapman
  43. Tuning JDBC for SQL Server by Jungsun Kim

  45. Creating a formal Reporting Services report part library by Jessica M. Moss
  46. Improving report layout and visualization by Greg Low
  47. Developing sharable managed code expressions in SSRS by William Vaughn
  48. Designing reports with custom MDX queries by Paul Turley
  49. Building a scale-out Reporting Services farm by Edwin Sarmiento
  50. Creating SSRS reports from SSAS by Robert Cain
  51. Optimizing SSIS for dimensional data loads by Michael Coles
  52. SSIS configurations management by Andy Leonard
  53. Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah
  54. Late-arriving dimensions in SSIS by John Welch
  55. Why automate tasks with SSIS? by Ted Krueger
  56. Extending SSIS using the Script component by Tim Mitchell
  57. ETL design checklist by Rafael Salas
  58. Autogenerating SSAS cubes by Johan Ahlen
  59. Scripting SSAS databases - AMO and PowerShell, Better Together by Darren Gosbell
  60. Managing context in MDX by Boyan Penev
  61. Using time intelligence functions in PowerPivot by Thiago Zavaschi
  62. Easy BI with Silverlight PivotViewer by Gogula Aryalingam
  63. Excel as a BI frontend tool by Pedro Perfeito
  64. Real-time BI with StreamInsight by Allan Mitchell
  65. BI solution development design considerations by Siddharth Mehta
Read More Show Less

Product Details

  • ISBN-13: 9781617290473
  • Publisher: Manning Publications Company
  • Publication date: 10/21/2011
  • Edition number: 1
  • Pages: 688
  • Sales rank: 1,488,417
  • Product dimensions: 7.40 (w) x 9.20 (h) x 1.40 (d)

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)