SQL Server 2005 Bible

Co-Authors

Outline

Part I: Laying the Foundation
Chapter 1: The Information Architecture Principle
Chapter 2: Relational Database Modeling
Chapter 3: Exploring SQL Server Architecture
Chapter 4: Installing SQL Server 2005
Chapter 5: Client Software Connectivity
Chapter 6: Using Management Studio

Part II: Manipulating Data with Select
Chapter 7: Understanding Basic Query Flow
Chapter 8: Using Expressions and Scalar Functions
Chapter 9: Merging Data with Joins and Unions
Chapter 10: Including Data with Subqueries and CTEs
Chapter 11: Aggregating Data
Chapter 12: Navigating Hierarchical Data
Chapter 13: Using Full Text Search
Chapter 14: Selecting Data through Views
Chapter 15: Working with Distributed Queries
Chapter 16: Modifying Data

Part III: Developing with SQL Server
Chapter 17: Implementing the Physical Database Schema
Chapter 18: Programming with T-SQL
Chapter 19: Performing Bulk Operations
Chapter 20: Kill the Cursor!
Chapter 21: Developing Stored Procedures
Chapter 22: Building User-Defined Functions
Chapter 23: Creating DML Triggers
Chapter 24: Exploring Advanced T-SQL Techniques
Chapter 25: Creating Extensibility with a Data Abstraction Layer
Chapter 26: Developing for SQL Server Mobile
Chapter 27: Programming CLR Assemblies within SQL Server
Chapter 28: Queueing with Service Broker
Chapter 29: Persisting Custom Data Types
Chapter 30: Programming with ADO.Net 2.0
Chapter 31: Using XML, XPath, and XQuery
Chapter 32: Building an SOA Data Store with Web Services
Chapter 33: InfoPath and SQL Server 2005

Part IV: Enterprise Data Management
Chapter 34: Configuring SQL Server
Chapter 35: Transferring Databases
Chapter 36: Recovery Planning
Chapter 37: Maintaining the Database
Chapter 38: Automating Database Maintenance with SQL Server Agent
Chapter 39: Replicating Data
Chapter 40: Securing Databases
Chapter 41: Administering SQL Server Express

Part V: Business Intelligence
Chapter 42: ETL with Integration Services
Chapter 43: Business Intelligence with Analysis Services
Chapter 44: Data Mining with Analysis Services
Chapter 45: Programming MDX Queries
Chapter 46: Authoring Reports with Reporting Services
Chapter 47: Administering Reports with Reporting Services
Chapter 48: Analyzing Data with Excel and Data Analyzer

Part VI: Optimization Strategies
Chapter 49: Measuring Performance
Chapter 50: Query Analysis and Index Tuning
Chapter 51: Managing Transactions, Locking, and Blocking
Chapter 52: Providing High Availability
Chapter 53: Scaling Very Large Databases
Chapter 54: Designing High Performance Data Access Providers

Appendix
Appendix A: SQL Server Specifications
Appendix B: System Views
Appendix C: Sample Databases

Download Files

Sample Databases and Chapter Scripts (740Kb)

Errata

...