You are previewing SQL Server MVP Deep Dives Vol. 2.
O'Reilly logo
SQL Server MVP Deep Dives Vol. 2

Book Description

SummarySQL 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

  • 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

This unique book is your chance to learn from the best in the business. It offers valuable insights for readers of all levels. ========================================?======= Table of Contents
PART 1 ARCHITECTURE
  1. Where are my keys?

  2. "Yes, we are all individuals" A look at uniqueness in the world of SQL

  3. Architectural growth pains

  4. Characteristics of a great relational database

  5. Storage design considerations

  6. Generalization: the key to a well-designed schema

    PART 2 DATABASE ADMINISTRATION

  7. Increasing availability through testing

  8. Page restores

  9. Capacity planning

  10. Discovering your servers with PowerShell and SMO

  11. Will the real Mr. Smith please stand up?

  12. Build your own SQL Server 2008 performance dashboard

  13. SQL Server cost recovery

  14. Best practice compliance with Policy-Based Management

  15. Using SQL Server Management Studio to the fullest

  16. Multiserver management and Utility Explorer - best tools for the DBA

  17. Top 10 SQL Server admin student misconceptions

  18. High availability of SQL Server in the context of Service Level Agreements

    PART 3 DATABASE DEVELOPMENT

  19. T-SQL: bad habits to kick

  20. Death by UDF

  21. Using regular expressions in SSMS

  22. SQL Server Denali: what's coming next in T-SQL

  23. Creating your own data type

  24. Extracting data with regular expressions

  25. Relational division

  26. SQL FILESTREAM: to BLOB or not to BLOB

  27. Writing unit tests for Transact-SQL

  28. Getting asynchronous with Service Broker

  29. Effective use of HierarchyId

  30. Let Service Broker help you scale your application

    PART 4 PERFORMANCE TUNING AND OPTIMIZATION

  31. Hardware 201: selecting and sizing database server hardware

  32. Parameter sniffing: your best friend...except when it isn't

  33. Investigating the plan cache

  34. What are you waiting for? An introduction to waits and queues

  35. You see sets, and I see loops

  36. Performance-tuning the transaction log for OLTP workloads

  37. Strategies for unraveling tangled code

  38. Using PAL to analyze SQL Server performance

  39. Tuning JDBC for SQL Server

    PART 5 BUSINESS INTELLIGENCE

  40. Creating a formal Reporting Services report part library

  41. Improving report layout and visualization

  42. Developing sharable managed code expressions in SSRS

  43. Designing reports with custom MDX queries

  44. Building a scale-out Reporting Services farm

  45. Creating SSRS reports from SSAS

  46. Optimizing SSIS for dimensional data loads

  47. SSIS configurations management

  48. Exploring different types of enumerators in the SSIS Foreach Loop container

  49. Late-arriving dimensions in SSIS

  50. Why automate tasks with SSIS?

  51. Extending SSIS using the Script component

  52. ETL design checklist

  53. Autogenerating SSAS cubes

  54. Scripting SSAS databases - AMO and PowerShell, Better Together

  55. Managing context in MDX

  56. Using time intelligence functions in PowerPivot

  57. Easy BI with Silverlight PivotViewer

  58. Excel as a BI frontend tool

  59. Real-time BI with StreamInsight

  60. BI solution development design considerations

Table of Contents

  1. Copyright
  2. Dedication
  3. Brief Table of Contents
  4. Table of Contents
  5. MVP authors and their chapters
  6. Preface
  7. Acknowledgments
  8. About Operation Smile
  9. About this book
  10. About the Editors
  11. About SQL Server MVPs
  12. Part 1. Architecture
  13. Chapter 1. Where are my keys?
  14. Chapter 2. “Yes, we are all individuals” A look at uniqueness in the world of SQL
  15. Chapter 3. Architectural growth pains
  16. Chapter 4. Characteristics of a great relational database
  17. Chapter 5. Storage design considerations
  18. Chapter 6. Generalization: the key to a well-designed schema
  19. Part 2. Database administration
  20. Chapter 7. Increasing availability through testing
  21. Chapter 8. Page restores
  22. Chapter 9. Capacity planning
  23. Chapter 10. Discovering your servers with PowerShell and SMO
  24. Chapter 11. Will the real Mr. Smith please stand up?
  25. Chapter 12. Build your own SQL Server 2008 performance dashboard
  26. Chapter 13. SQL Server cost recovery
  27. Chapter 14. Best practice compliance with Policy-Based Management
  28. Chapter 15. Using SQL Server Management Studio to the fullest
  29. Chapter 16. Multiserver management and Utility Explorer—best tools for the DBA
  30. Chapter 17. Top 10 SQL Server admin student misconceptions
  31. Chapter 18. High availability of SQL Server in the context of Service Level Agreements
  32. Part 3. Database development
  33. Chapter 19. T-SQL: bad habits to kick
  34. Chapter 20. Death by UDF
  35. Chapter 21. Using regular expressions in SSMS
  36. Chapter 22. SQL Server Denali: what’s coming next in T-SQL
  37. Chapter 23. Creating your own data type
  38. Chapter 24. Extracting data with regular expressions
  39. Chapter 25. Relational division
  40. Chapter 26. SQL FILESTREAM: to BLOB or not to BLOB
  41. Chapter 27. Writing unit tests for Transact-SQL
  42. Chapter 28. Getting asynchronous with Service Broker
  43. Chapter 29. Effective use of HierarchyId
  44. Chapter 30. Let Service Broker help you scale your application
  45. Part 4. Performance tuning and optimization
  46. Chapter 31. Hardware 201: selecting and sizing database server hardware
  47. Chapter 32. Parameter sniffing: your best friend... except when it isn’t
  48. Chapter 33. Investigating the plan cache
  49. Chapter 34. What are you waiting for? An introduction to waits and queues
  50. Chapter 35. You see sets, and I see loops
  51. Chapter 36. Performance-tuning the transaction log for OLTP workloads
  52. Chapter 37. Strategies for unraveling tangled code
  53. Chapter 38. Using PAL to analyze SQL Server performance
  54. Chapter 39. Tuning JDBC for SQL Server
  55. Part 5. Business intelligence
  56. Chapter 40. Creating a formal Reporting Services report part library
  57. Chapter 41. Improving report layout and visualization
  58. Chapter 42. Developing sharable managed code expressions in SSRS
  59. Chapter 43. Designing reports with custom MDX queries
  60. Chapter 44. Building a scale-out Reporting Services farm
  61. Chapter 45. Creating SSRS reports from SSAS
  62. Chapter 46. Optimizing SSIS for dimensional data loads
  63. Chapter 47. SSIS configurations management
  64. Chapter 48. Exploring different types of enumerators in the SSIS Foreach Loop container
  65. Chapter 49. Late-arriving dimensions in SSIS
  66. Chapter 50. Why automate tasks with SSIS?
  67. Chapter 51. Extending SSIS using the Script component
  68. Chapter 52. ETL design checklist
  69. Chapter 53. Autogenerating SSAS cubes
  70. Chapter 54. Scripting SSAS databases – AMO and PowerShell, Better Together
  71. Chapter 55. Managing context in MDX
  72. Chapter 56. Using time intelligence functions in PowerPivot
  73. Chapter 57. Easy BI with Silverlight PivotViewer
  74. Chapter 58. Excel as a BI frontend tool
  75. Chapter 59. Real-time BI with StreamInsight
  76. Chapter 60. BI solution development design considerations
  77. Index
  78. List of Figures
  79. List of Tables
  80. List of Listings