SQL Server MVP Deep Dives

Introduction

This is no ordinary SQL Server book. In SQL Server MVP Deep Dives, the world’s leading experts and practitioners offer a masterful collection of techniques and best practices for SQL Server development and administration. 53 MVPs each pick an area of passionate interest to them and then share their insights and practical know-how with you.

SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. In each, you’ll find concise, brilliantly clear chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance.

About the book
SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. In each, you’ll find concise, brilliantly clear chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance.

What’s inside
Topics important for SQL Server pros
Accessible to readers of all levels
New features of SQL Server 2008
Whether you’re just getting started with SQL Server or you’re an old master looking for new tricks, this book belongs on your bookshelf.

About the authors
The authors of this book have generously donated 100% of their royalties to support War Child International.

PART 1 DATABASE DESIGN AND ARCHITECTURE
1 Louis and Paul’s 10 key relational database design ideas
2 SQL Server tools for maintaining data integrity
3 Finding functional dependencies

PART 2 DATABASE DEVELOPMENT
4 Set-based iteration, the third alternative
5 Gaps and islands
6 Error handling in SQL Server and applications
7 Pulling apart the FROM clause
8 What makes a bulk insert a minimally logged operation?
9 Avoiding three common query mistakes
10 Introduction to XQuery on SQL Server
11 SQL Server XML frequently asked questions
12 Using XML to transport relational data
13 Full-text searching
14 Simil: an algorithm to look for similar strings
15 LINQ to SQL and ADO.NET Entity Framework
16 Table-valued parameters
17 Build your own index
18 Getting and staying connected—or not
19 Extending your productivity in SSMS and Query Analyzer
20 Why every SQL developer needs a tools database
21 Deprecation feature
22 Placing SQL Server in your pocket
23 Mobile data strategies

PART 3 DATABASE ADMINISTRATION
24 What does it mean to be a DBA?
25 Working with maintenance plans
26 PowerShell in SQL Server
27 Automating SQL Server Management using SMO
28 Practical auditing in SQL Server 2008
29 My favorite DMVs, and why
30 Reusing space in a table
31 Some practical issues in table partitioning
32 Partitioning for manageability (and maybe performance)
33 Efficient backups without indexes
34 Using database mirroring to become a superhero!
35 The poor man’s SQL Server log shipping
36 Understated changes in SQL Server 2005 replication
37 High-performance transactional replication
38 Successfully implementing Kerberos delegation
39 Running SQL Server on Hyper-V

PART 4 PERFORMANCE TUNING AND OPTIMIZATION
40 When is an unused index not an unused index?
41 Speeding up your queries with index covering
42 Tracing the deadlock
43 How to optimize tempdb performance
44 Does the order of columns in an index matter?
45 Correlating SQL Profiler with PerfMon
46 Using correlation to improve query performance
47 How to use Dynamic Management Views
48 Query performance and disk I/O counters
49 XEVENT: the next event infrastructure

PART 5 BUSINESS INTELLIGENCE
50 BI for the relational guy
51 Unlocking the secrets of SQL Server 2008 Reporting Services
52 Reporting Services tips and tricks
53 SQL Server Audit, change tracking, and change data capture
54 Introduction to SSAS 2008 data mining
55 To aggregate or not to aggregate—is there really a question?
56 Incorporating data profiling in the ETL process
57 Expressions in SQL Server Integration Services
58 SSIS performance tips
59 Incremental loads using T-SQL and SSIS

SQL Server MVP Deep Dives

Introduction

Table of Contents

Access the Book Page on the Publisher's Website: