Microsoft SQL Server 2008 Bible

Introduction.

Part I Laying the Foundation.

Chapter 1: The World of SQL Server.

Chapter 2: Data Architecture.

Chapter 3: Relational Database Design.

Chapter 4: Installing SQL Server 2008.

Chapter 5: Client Connectivity.

Chapter 6: Using Management Studio.

Chapter 7: Scripting with PowerShell.

Part II Manipulating Data with Select.

Chapter 8: Introducing Basic Query Flow.

Chapter 9: Data Types, Expressions, and Scalar Functions.

Chapter 10: Merging Data with Joins and Unions.

Chapter 11: Including Data with Subqueries and CTEs.

Chapter 12: Aggregating Data.

Chapter 13: Windowing and Ranking.

Chapter 14: Projecting Data Through Views.

Chapter 15: Modifying Data.

Chapter 16: Modification Obstacles.

Part III Beyond Relational.

Chapter 17: Traversing Hierarchies.

Chapter 18: Manipulating XML Data.

Chapter 19: Using Integrated Full-Text Search.

Part IV Developing with SQL Server.

Chapter 20: Creating the Physical Database Schema.

Chapter 21: Programming with T-SQL.

Chapter 22: Kill the Cursor!

Chapter 23: T-SQL Error Handling.

Chapter 24: Developing Stored Procedures.

Chapter 25: Building User-Defined Functions.

Chapter 26: Creating DML Triggers.

Chapter 27: DDL Triggers.

Chapter 28: Building Out the Data Abstraction Layer.

Chapter 29: Dynamic SQL and Code Generation.

Part V Data Connectivity.

Chapter 30: Bulk Operations.

Chapter 31: Executing Distributed Queries.

Chapter 32: Programming with ADO.NET 3.5.

Chapter 33: Sync Framework.

Chapter 34: LINQ.

Chapter 35: Asynchronous Messaging with Service Broker.

Chapter 36: Replicating Data.

Chapter 37: Performing ETL with Integration Services.

Chapter 38: Access as a Front End to SQL Server.

Part VI Enterprise Data Management.

Chapter 39: Configuring SQL Server.

Chapter 40: Policy-Based Management.

Chapter 41: Recovery Planning.

Chapter 42: Maintaining the Database.

Chapter 43: Automating Database Maintenance with SQL Server Agent.

Chapter 44: Transferring Databases.

Chapter 45: Database Snapshots.

Chapter 46: Log Shipping.

Chapter 47: Database Mirroring.

Chapter 48: Clustering.

Part VII Security.

Chapter 49: Authenticating Principals.

Chapter 50: Authorizing Securables.

Chapter 51: Data Cryptography.

Chapter 52: Row-Level Security.

Part VIII Monitoring and Auditing.

Chapter 53: Data Audit Triggers.

Chapter 54: Schema Audit Triggers.

Chapter 55: Performance Monitor.

Chapter 56: Tracing and Profiling.

Chapter 57: Wait States.

Chapter 58: Extended Events.

Chapter 59: Change Tracking.

Chapter 60: Change Data Capture.

Chapter 61: SQL Audit.

Chapter 62: Management Data Warehouse.

Part IX Performance Tuning and Optimization.

Chapter 63: Interpreting Query Execution Plans.

Chapter 64: Indexing Strategies.

Chapter 65: Query Plan Reuse.

Chapter 66: Managing Transactions, Locking, and Blocking.

Chapter 67: Data Compression.

Chapter 68: Partitioning.

Chapter 69: Resource Governor.

Part X Business Intelligence.

Chapter 70: BI Design.

Chapter 71: Building Multidimensional Cubes with Analysis Services.

Chapter 72: Programming MDX Queries.

Chapter 73: Authoring Reports with Reporting Services.

Chapter 74: Administering Reporting Services.

Chapter 75: Analyzing Data with Excel.

Chapter 76: Data Mining with Analysis Services.

Appendix A: SQL Server 2008 Specifications.

Appendix B: Using the Sample Databases.

Index.