Sql Server Mvp Deep Dives, Volume 2 by Kalen DelaneySql Server Mvp Deep Dives, Volume 2 by Kalen Delaney

Sql Server Mvp Deep Dives, Volume 2

byKalen Delaney, Louis Davidson, Greg Low

Paperback | October 24, 2011

Pricing and Purchase Info

$50.74 online 
$77.95 list price save 34%
Earn 254 plum® points

Prices and offers may vary in store


In stock online

Ships free on orders over $25

Available in stores



SQL Server MVP Deep Dives, Volume 2is 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 2picks 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 ARCHITECTUREEdited 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 SQLby Rob Farley
  3. Architectural growth painsby Chris Shaw
  4. Characteristics of a great relational databaseby Louis Davidson
  5. Storage design considerationsby Denny Cherry
  6. Generalization: the key to a well-designed schemaby Paul Nielsen
  7. PART 2 DATABASE ADMINISTRATIONEdited by Paul Randal and Kimberly Tripp
  8. Increasing availability through testingby Allan Hirt
  9. Page restoresby Gail Shaw
  10. Capacity planningby Greg Larsen
  11. Discovering your servers with PowerShell and SMOby Joe Webb
  12. Will the real Mr. Smith please stand up?by John Magnabosco
  13. Build your own SQL Server 2008 performance dashboardby Pawl Potasinski
  14. SQL Server cost recoveryby Peter Ward
  15. Best practice compliance with Policy-Based Managementby Rod Colledge
  16. Using SQL Server Management Studio to the fullestby Rodney Landrum
  17. Multiserver management and Utility Explorer - best tools for the DBAby Satya Shyam K. Jayanty
  18. Top 10 SQL Server admin student misconceptionsby Tibor Karaszi
  19. High availability of SQL Server in the context of Service Level Agreementsby Tobiasz Janusz Koprowski
  20. PART 3 DATABASE DEVELOPMENTEdited by Paul Nielsen
  21. T-SQL: bad habits to kickby Aaron Bertrand
  22. Death by UDFby Kevin Boles
  23. Using regular expressions in SSMSby John Paul Cook
  24. SQL Server Denali: what's coming next in T-SQLby Sergio Govoni
  25. Creating your own data typeby Hugo Kornelis
  26. Extracting data with regular expressionsby Matija Lah
  27. Relational divisionby Peter Larsson
  28. SQL FILESTREAM: to BLOB or not to BLOBby Ben Miller
  29. Writing unit tests for Transact-SQLby Luciano Moreira
  30. Getting asynchronous with Service Brokerby Mladen Prajdic
  31. Effective use of HierarchyIdby Denis Reznik
  32. Let Service Broker help you scale your applicationby Allen White
  34. Hardware 201: selecting and sizing database server hardwareby Glenn Berry
  35. Parameter sniffing: your best friend...except when it isn'tby Grant Fritchey
  36. Investigating the plan cacheby Jason Strate
  37. What are you waiting for? An introduction to waits and queuesby Robert Pearl
  38. You see sets, and I see loopsby Linchi Shea
  39. Performance-tuning the transaction log for OLTP workloadsby Brad M. McGehee
  40. Strategies for unraveling tangled codeby Jennifer McCown
  41. Using PAL to analyze SQL Server performanceby Tim Chapman
  42. Tuning JDBC for SQL Serverby Jungsun Kim
  44. Creating a formal Reporting Services report part libraryby Jessica M. Moss
  45. Improving report layout and visualizationby Greg Low
  46. Developing sharable managed code expressions in SSRSby William Vaughn
  47. Designing reports with custom MDX queriesby Paul Turley
  48. Building a scale-out Reporting Services farmby Edwin Sarmiento
  49. Creating SSRS reports from SSASby Robert Cain
  50. Optimizing SSIS for dimensional data loadsby Michael Coles
  51. SSIS configurations managementby Andy Leonard
  52. Exploring different types of enumerators in the SSIS Foreach Loop containerby Abolfazl Radgoudarzi and Shahriar Nikkhah
  53. Late-arriving dimensions in SSISby John Welch
  54. Why automate tasks with SSIS?by Ted Krueger
  55. Extending SSIS using the Script componentby Tim Mitchell
  56. ETL design checklistby Rafael Salas
  57. Autogenerating SSAS cubesby Johan Ahlen
  58. Scripting SSAS databases - AMO and PowerShell, Better Togetherby Darren Gosbell
  59. Managing context in MDXby Boyan Penev
  60. Using time intelligence functions in PowerPivotby Thiago Zavaschi
  61. Easy BI with Silverlight PivotViewerby Gogula Aryalingam
  62. Excel as a BI frontend toolby Pedro Perfeito
  63. Real-time BI with StreamInsightby Allan Mitchell
  64. BI solution development design considerationsby Siddharth Mehta
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 (Databa...
Title:Sql Server Mvp Deep Dives, Volume 2Format:PaperbackDimensions:688 pages, 9.5 × 7.5 × 1.2 inPublished:October 24, 2011Publisher:Manning PublicationsLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1617290475

ISBN - 13:9781617290473

Look for similar items by category: