Exciting news… The second edition of the SQL Server MVP Deep Dives book has been completed and is going to press in time for the PASS Global Summit! The book will be on sale at the conference book store and is available to pre-order on Amazon* It can be purchased as an eBook or paperback from the publisher at http://www.manning.com/delaney/
It contains 60 chapters written by several of the Microsoft SQL Server MVPs. Most of these industry leaders write their own books for other publishers and have collaborated to produce this unique book with all profits donated to charity. This effort was led by Kalen Delaney, Paul Randal and other well-known industry leaders.
I was privileged to write a chapter about designing Reporting Services reports with custom MDX queries for Analysis Services (highlighted in the TOC below).
All profits from the book are donated to the Operation Smile program
Individually, each SQL Server MVP possesses an impressive wealth of knowledge and skill. Collectively, the 63 MVPs who contributed to SQL Server MVP Deep Dives, Volume II represent over 1000 years of daily experience in SQL Server administration, development, training, and design. This incredible book captures this expertise and passion in a collection of sixty concise chapters, each handpicked by lead editor Kalen Delaney and section editors Louis Davidson, Greg Low, Brad McGehee, Paul Nielsen, Paul Randal, and Kimberly Tripp, and written by an active SQL Server MVP.
This second volume picks up where the first SQL Server MVP Deep Dives leaves off, offering completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques. The chapters fall into five parts, Architecture and Design, Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.
This unique book is your chance to learn from the best in the business. It offers something of interest for any SQL Server pro at any level of experience.
This book includes contributions from 63 SQL Server MVPs. All chapters were selected and edited by Kalen Delaney and section editors Louis Davidson (Architecture and Design), Paul Randal and Kimberly Tripp (Database Administration), Brad McGehee (Performance Tuning), Paul Nielsen (Database Development), and Greg Low (Business Intelligence).
Part I: ARCH/DESIGN
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 II: ADMIN
7 Increasing Availability Through Testing
8 Page restores, the what how and why
9 Capacity Planning and Why DBA’s Should be doing it.
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 with CLR, DMVs and SQL Server Reporting Services
13 SQL Server Cost Recovery
14 Best Practice Compliance with Policy-based Management & Central Management Servers
15 Using SQL Server Management Studio to the Fullest
16 SQL Server 2008 R2 :: Multi-server management and Utility explorer—best tools for DBA
17 Top 10 SQL Server admin students misconceptions
18 High Availability of SQL Server in the context of Service Level Agreement
Part III: DB DEV
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 Create your own data type
24 Extracting Data with Regular Expressions
25 Relational division – Practice uses of Relational Algebra
26 SQL FILESTREAM: To BLOB or not to BLOB
27 Writing unit tests for Transact-SQL
28 Getting Async with SQL Server Service Broker
29 Effective using of HierarchyId datatype
30 Let Service Broker Help You Scale Your Application
Part IV: PTO
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 States & 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 Use PAL to Analyze SQL Server Performance
39 Tuning JDBC for SQL Server
Part V: BI
40 Creating a Formal Reporting Services Report Part Library
41 Improving Report Layout and Visualization in SQL Server 2008 R2 Reporting Services
42 Developing Sharable Managed Code Expressions in Reporting Services
43 Designing Reports with Custom MDX Queries
44 Building a Scale-Out SQL Server 2008 R2 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 Multiplying DBA Headcount with SSIS
51 Extending SSIS using the Script Component
52 ETL Design Checklist: Helping your Data Warehouse Succeed
53 Autogenerating SSAS Cubes
54 Scripting your Analysis Services Database—AMO and PowerShell, Better Together
55 Managing Context in MDX
56 Using Time Intelligence Functions in PowerPivot
57 Easy BI with the Silverlight PivotViewer
58 Excel as a BI Front-End Tool
59 Real-time BI with StreamInsight
60 BI Solution Development Design Considerations
*Amazon currently has the release date listed as October 28th but this will be revised.