SQL Server MVP Deep Dives, Volume 2
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
- Where are my keys?
- “Yes, we are all individuals” A look at uniqueness in the world of SQL
- Architectural growth pains
- Characteristics of a great relational database
- Storage design considerations
- Generalization: the key to a well-designed schema
PART 2 DATABASE ADMINISTRATION
- Increasing availability through testing
- Page restores
- Capacity planning
- Discovering your servers with PowerShell and SMO
- Will the real Mr. Smith please stand up?
- Build your own SQL Server 2008 performance dashboard
- SQL Server cost recovery
- Best practice compliance with Policy-Based Management
- Using SQL Server Management Studio to the fullest
- Multiserver management and Utility Explorer – best tools for the DBA
- Top 10 SQL Server admin student misconceptions
- High availability of SQL Server in the context of Service Level Agreements
PART 3 DATABASE DEVELOPMENT
- T-SQL: bad habits to kick
- Death by UDF
- Using regular expressions in SSMS
- SQL Server Denali: what’s coming next in T-SQL
- Creating your own data type
- Extracting data with regular expressions
- Relational division
- SQL FILESTREAM: to BLOB or not to BLOB
- Writing unit tests for Transact-SQL
- Getting asynchronous with Service Broker
- Effective use of HierarchyId
- Let Service Broker help you scale your application
PART 4 PERFORMANCE TUNING AND OPTIMIZATION
- Hardware 201: selecting and sizing database server hardware
- Parameter sniffing: your best friend…except when it isn’t
- Investigating the plan cache
- What are you waiting for? An introduction to waits and queues
- You see sets, and I see loops
- Performance-tuning the transaction log for OLTP workloads
- Strategies for unraveling tangled code
- Using PAL to analyze SQL Server performance
- Tuning JDBC for SQL Server
PART 5 BUSINESS INTELLIGENCE
- Creating a formal Reporting Services report part library
- Improving report layout and visualization
- Developing sharable managed code expressions in SSRS
- Designing reports with custom MDX queries
- Building a scale-out Reporting Services farm
- Creating SSRS reports from SSAS
- Optimizing SSIS for dimensional data loads
- SSIS configurations management
- Exploring different types of enumerators in the SSIS Foreach Loop container
- Late-arriving dimensions in SSIS
- Why automate tasks with SSIS?
- Extending SSIS using the Script component
- ETL design checklist
- Autogenerating SSAS cubes
- Scripting SSAS databases – AMO and PowerShell, Better Together
- Managing context in MDX
- Using time intelligence functions in PowerPivot
- Easy BI with Silverlight PivotViewer
- Excel as a BI frontend tool
- Real-time BI with StreamInsight
- 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