SQL Server 2008 Bible

Co-Authors

Outline

Part I: Laying the Foundation
Ch 1: The World of SQL Server
Ch 2: Data Architecture
Ch 3: Relational Database Design
Ch 4: Installing SQL Server 2008
Ch 5: Client Connectivity
Ch 6: Using Management Studio
Ch 7: Scripting with PowerShell

Part II: Manipulating Data with Select
Ch 8: Understanding Basic Query Flow
Ch 9: Data Types, Expressions and Scalar Functions
Ch 10: Merging Data with Joins and Unions (.pdf) (4.42Mb)
Ch 11: Including Data with Subqueries and CTEs
Ch 12: Aggregating Data
Ch 13: Windowing and Ranking
Ch 14: Selecting Data through Views
Ch 15: Modifying Data
Ch 16: Modification Obstacles

Part III: Beyond Relational
Ch 17: Traversing Hierarchies (.pdf) (4.11Mb)
Ch 18: Manipulating XML Data
Ch 19: Using INtegrated Full Text Search

Part IV: Developing Inside SQL Server
Ch 20: Creating the Physical Database Schema
Ch 21: Programming with T-SQL
Ch 22: Kill the Cursor!
Ch 23: T-SQL Error Handling
Ch 24: Developing Stored Procedures
Ch 25: Building User-Defined Functions
Ch 26: Creating DML Triggers
Ch 27: DDL Triggers
Ch 28: Building out the Data Abstraction Layer
Ch 29: Dynamic SQL and Code Generation

Part V: Data Connectivity
Ch 30: Bulk Operations
Ch 31: Executing Distributed Queries
Ch 32: Programmign with ADO.NET 3.5
Ch 33: Synch Framework
Ch 34: LINQ
Ch 35: Asynchronous Messaging with Service Broker
Ch 36: Replicating Data
Ch 37: Performing ETL with Integration Services
Ch 38: Access as a Front End to SQL Server

Part VI: Enterprise Data Management
Ch 39: Configuring SQL Server
Ch 40: Policy-Based Management
Ch 41: Recovery Planning
Ch 42: Maintainign the Database
Ch 43: Automating Database Maintenance with SQL Server Agent
Ch 44: Transferring Databases
Ch 45: Database Snapshots
Ch 46: Log Shipping
Ch 47: Database Mirroring
Ch 48: Clustering

Part VII: Security
Ch 49: Authenticating Principals
Ch 50: Authorizing Securables
Ch 51: Data Cryptography
Ch 52: Row-Level Security

Part VIII: Monitoring and Auditing
Ch 53: Data Audit Triggers
Ch 54: Schema Audit Triggers
Ch 55: Performance Monitor
Ch 56: Tracing and Profiling
Ch 57: Wait States
Ch 58: Extended Events
Ch 59: Change Tracking
Ch 60: Change Data Capture
Ch 61: SQL Audit
Ch 62: Management Data Warehouse

Part IX: Performance Tuning and Optimization
Ch 63: Interpreting Query Execution Plans
Ch 64: Indexing Strategies
Ch 65: Query Plan Reuse
Ch 66: Managing Transactions, Locking, and Blocking
Ch 67: Data Compression
Ch 68: Partitioning
Ch 69: Resource Governor

Part X: Business Intelligence
Ch 70: BI Design
Ch 71: Building Multidimensional Cubes with Analysis Services
Ch 72: Programming MDX Queries
Ch 73: Authoring Reports with Reporting Services
Ch 74: Administering Reporting Services
Ch 75: Analyzing Data with Excel
Ch 76: Data Mining with Analysis Services

Appendix
Appdx A: SQL Server 2008 Specifications
Appdx B: Using the Sample Databases

Download Files

Sample Databases and Chapter Scripts (740Kb)

Errata

p. 399 fourth paragraph, should be "Is managing hierarchical data as easy as SELECT * FROM foo?"

p. 400 first paragraph, should be "The word hierarchy comes from the Greek and was first used in English in 1880 to describe the order of angels."