Deep Dives 2 erscheint in Kürze

Die zweite Ausgabe des SQL Server MVP Buchs (Deep Dives) ist fertig gestellt und geht in Kürze in den Druck. Vorbestellungen sind bereits möglich.

Das Buch enthält 60 Kapitel, die von verschiedenen Microsoft SQL Server MVPs geschrieben wurden. Alle SQL Server MVPs konnten sich an der Abstimmung beteiligen, welche gemeinnützige Organisation den Erlös des Buches erhalten soll. Für dieses Buch wurde wieder eine Organisation ausgewählt, die sich für Kinder engagiert:

SQL Server MVP Deep Dives, Volume 2

www.operationsmile.org

www.manning.com/delaney

Informationen des Herausgebers

DESCRIPTION

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.

About the Authors

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).

Table of Contents:

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