SQL Server MVP Deep Dives, Volume 2

Kalen Delaney, Louis Davidson, Greg Low, Brad McGehee,
Paul Nielsen, Paul Randal, and Kimberly Tripp


October 2011 | 688 pages
ISBN: 9781617290473

$59.99 pBook + eBook (includes PDF, epub and Kindle)
$47.99 eBook only (includes PDF, ePub, and Kindle)
Browse all our mobile format eBooks.

Resources

 Look Inside Resources Downloads

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

PART 2 DATABASE ADMINISTRATION EDITED BY PAUL RANDAL AND KIMBERLY TRIPP
  7. Increasing availability through testing by ALLAN HIRT
  8. Page restores by GAIL SHAW
  9. Capacity planning by GREG LARSEN
10. Discovering your servers with PowerShell and SMO by JOE WEBB
11. Will the real Mr. Smith please stand up? by JOHN MAGNABOSCO
12. Build your own SQL Server 2008 performance dashboard by PAWEL POTASINSKI
13. SQL Server cost recovery by PETER WARD
14. Best practice compliance with Policy-Based Management by ROD COLLEDGE
15. Using SQL Server Management Studio to the fullest by RODNEY LANDRUM
16. Multiserver management and Utility Explorer—best tools for the DBA by SATYA SHYAM K JAYANTY
17. Top 10 SQL Server admin student misconceptions by TIBOR KARASZI
18. High availability of SQL Server in the context of Service Level Agreements by BY TOBIASZ JANUSZ KOPROWSKI

PART 3 DATABASE DEVELOPMENT EDITED BY PAUL NIELSEN
19. T-SQL: bad habits to kick by AARON BERTRAND
20. Death by UDF by KEVIN BOLES
21. Using regular expressions in SSMS by JOHN PAUL COOK
22. SQL Server Denali: what's coming next in T-SQL by SERGIO GOVONI
23. Creating your own data type by HUGO KORNELIS
24. Extracting data with regular expressions by MATIJA LAH
25. Relational division by PETER LARSSON
26. SQL FILESTREAM: to BLOB or not to BLOB by BEN MILLER
27. Writing unit tests for Transact-SQL by LUCIANO MOREIRA
28. Getting asynchronous with Service Broker by MLADEN PRAJDIC
29. Effective use of HierarchyId by BY DENIS REZNIK
30. Let Service Broker help you scale your application by ALLEN WHITE

PART 4 PERFORMANCE TUNING AND OPTIMIZATION EDITED BY BRAD M. MCGEHEE
31. Hardware 201: selecting and sizing database server hardware by GLENN BERRY
32. Parameter sniffing: your best friend... except when it isn't by GRANT FRITCHEY
33. Investigating the plan cache by JASON STRATE
34. What are you waiting for? An introduction to wait states and queues by ROBERT PEARL
35. You see sets, and I see loops by LINCHI SHEA
36. Performance-tuning the transaction log for OLTP workloads by BRAD M. MCGEHEE
37. Strategies for unraveling tangled code by JENNIFER MCCOWN
38. Using PAL to analyze SQL Server performance by TIM CHAPMAN
39. Tuning JDBC for SQL Server by JUNGSUN KIM
PART 5 BUSINESS INTELLIGENCE EDITED BY GREG LOW
40. Creating a formal Reporting Services report part library by JESSICA M. MOSS
41. Improving report layout and visualization by GREG LOW
42. Developing sharable managed code expressions in SSRS by WILLIAM (BILL) VAUGHN
43. Designing reports with custom MDX queries by PAUL TURLEY
44. Building a scale-out Reporting Services farm by EDWIN SARMIENTO
45. Creating SSRS reports from SSAS by ROBERT CAIN
46. Optimizing SSIS for dimensional data loads by MICHAEL COLES
47. SSIS configurations management by ANDY LEONARD
48. Exploring different types of enumerators in the SSIS Foreach Loop container by ABOLFAZL RADGOUDARZI AND SHAHRIAR NIKKHAH
49. Late-arriving dimensions in SSIS by JOHN WELCH
50. Why automate tasks with SSIS? by TED KRUEGER
51. Extending SSIS using the Script component by TIM MITCHELL
52. ETL design checklist by RAFAEL SALAS
53. Autogenerating SSAS cubes by JOHAN AHLEN
54. Scripting SSAS databases—AMO and PowerShell, Better Together by DARREN GOSBELL
55. Managing context in MDX by BY BOYAN PENEV
56. Using time intelligence functions in PowerPivot by THIAGO ZAVASCHI
57. Easy BI with Silverlight PivotViewer by GOGULA ARYALINGAM
58. Excel as a BI frontend tool by BY PEDRO PERFEITO
59. Real-time BI with StreamInsight by BY ALLAN MITCHELL
60. BI solution development design considerations by BY SIDDHARTH MEHTA

Summary

SQL Server MVP Deep Dives, Volume 2 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.

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.

What's Inside

This unique book is your chance to learn from the best in the business. It offers valuable insights for readers of all levels.

About the Authors

Written by 64 SQL Server MVPs, the chapters were selected and edited by Kalen Delaney and Section Editors Louis Davidson (Architecture and Design), Paul Randal and Kimberly Tripp (Database Administration), Paul Nielsen (Database Development), Brad McGehee (Performance Tuning and Optimization), and Greg Low (Business Intelligence).

About Operation Smile

Operation Smile logoOperation Smile is an international children's medical charity whose principal purpose is to perform free reconstructive surgery for those who suffer 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.