SQL Server MVP Deep Dives, Volume 2

· No Responses


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.

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
  • 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

  1. Increasing availability through testing
  2. Page restores
  3. Capacity planning
  4. Discovering your servers with PowerShell and SMO
  5. Will the real Mr. Smith please stand up?
  6. Build your own SQL Server 2008 performance dashboard
  7. SQL Server cost recovery
  8. Best practice compliance with Policy-Based Management
  9. Using SQL Server Management Studio to the fullest
  10. Multiserver management and Utility Explorer – best tools for the DBA
  11. Top 10 SQL Server admin student misconceptions
  12. High availability of SQL Server in the context of Service Level Agreements

PART 3 DATABASE DEVELOPMENT

  1. T-SQL: bad habits to kick
  2. Death by UDF
  3. Using regular expressions in SSMS
  4. SQL Server Denali: what’s coming next in T-SQL
  5. Creating your own data type
  6. Extracting data with regular expressions
  7. Relational division
  8. SQL FILESTREAM: to BLOB or not to BLOB
  9. Writing unit tests for Transact-SQL
  10. Getting asynchronous with Service Broker
  11. Effective use of HierarchyId
  12. Let Service Broker help you scale your application

PART 4 PERFORMANCE TUNING AND OPTIMIZATION

  1. Hardware 201: selecting and sizing database server hardware
  2. Parameter sniffing: your best friend…except when it isn’t
  3. Investigating the plan cache
  4. What are you waiting for? An introduction to waits and queues
  5. You see sets, and I see loops
  6. Performance-tuning the transaction log for OLTP workloads
  7. Strategies for unraveling tangled code
  8. Using PAL to analyze SQL Server performance
  9. Tuning JDBC for SQL Server

PART 5 BUSINESS INTELLIGENCE

  1. Creating a formal Reporting Services report part library
  2. Improving report layout and visualization
  3. Developing sharable managed code expressions in SSRS
  4. Designing reports with custom MDX queries
  5. Building a scale-out Reporting Services farm
  6. Creating SSRS reports from SSAS
  7. Optimizing SSIS for dimensional data loads
  8. SSIS configurations management
  9. Exploring different types of enumerators in the SSIS Foreach Loop container
  10. Late-arriving dimensions in SSIS
  11. Why automate tasks with SSIS?
  12. Extending SSIS using the Script component
  13. ETL design checklist
  14. Autogenerating SSAS cubes
  15. Scripting SSAS databases – AMO and PowerShell, Better Together
  16. Managing context in MDX
  17. Using time intelligence functions in PowerPivot
  18. Easy BI with Silverlight PivotViewer
  19. Excel as a BI frontend tool
  20. Real-time BI with StreamInsight
  21. BI solution development design considerations by BY SIDDHARTH MEHTA

Book Details

  • Paperback: 688 pages
  • Publisher: Manning Publications (October 2011)
  • Language: English
  • ISBN-10: 1617290475
  • ISBN-13: 978-1617290473
Download [37.5 MiB]

You may also like...

Leave a Reply

Follow:

More