Microsoft SQL Server 2008 Bible -- About Paul Nielsen -- About the Contributing Authors -- About the Technical Reviewers -- Credits -- Acknowledgments -- Contents at a Glance -- Contents -- Foreword -- Introduction -- Who Should Read This Book -- How This Book Is Organized -- SQL Server Books Online -- Conventions and Features -- www.SQLServerBible.com -- Where to Go from Here -- Part I: Laying the Foundation -- Chapter 1: The World of SQL Server -- A Great Choice -- SQL Server Database Engine -- SQL Server Services -- Business Intelligence -- UI and Tools -- SQL Server Editions -- Exploring the Metadata -- What's New? -- Summary -- Chapter 2: Data Architecture -- Information Architecture Principle -- Database Objectives -- Smart Database Design -- Summary -- Chapter 3: Relational Database Design -- Database Basics -- Data Design Patterns -- Normal Forms -- Summary -- Chapter 4: Installing SQL Server 2008 -- Selecting Server Hardware -- Preparing the Server -- Performing the Installation -- Upgrading from Previous Versions -- Migrating to SQL Server -- Removing SQL Server -- Summary -- Chapter 5: Client Connectivity -- Enabling Server Connectivity -- SQL Server Native Client Features -- Summary -- Chapter 6: Using Management Studio -- Organizing the Interface -- Registered Servers -- Object Explorer -- Using the Query Editor -- Using the Solution Explorer -- Jump-Starting Code with Templates -- Summary -- Chapter 7: Scripting with PowerShell -- Why Use PowerShell? -- Basic PowerShell -- Communicating with SQL Server -- Scripting SQL Server Tasks -- SQL Server PowerShell Extensions -- Summary -- Part II: Manipulating Data with Select -- Chapter 8: Introducing Basic Query Flow -- Understanding Query Flow -- From Clause Data Sources -- Where Conditions -- Columns, Stars, Aliases, and Expressions -- Ordering the Result Set -- Select Distinct.

Top () -- Summary -- Chapter 9: Data Types, Expressions, and Scalar Functions -- Building Expressions -- Scalar Functions -- String Functions -- Soundex Functions -- Data-Type Conversion Functions -- Server Environment Information -- Summary -- Chapter 10: Merging Data with Joins and Unions -- Using Joins -- Inner Joins -- Outer Joins -- Self-Joins -- Cross (Unrestricted) Joins -- Exotic Joins -- Set Difference Queries -- Using Unions -- Summary -- Chapter 11: Including Data with Subqueries and CTEs -- Methods and Locations -- Simple Subqueries -- Correlated Subqueries -- Relational Division -- Composable SQL -- Summary -- Chapter 12: Aggregating Data -- Simple Aggregations -- Grouping within a Result Set -- Aggravating Queries -- OLAP in the Park -- Building Crosstab Queries -- Cumulative Totals (Running Sums) -- Summary -- Chapter 13: Windowing and Ranking -- Windowing -- Ranking Functions -- Summary -- Chapter 14: Projecting Data Through Views -- Why Use Views? -- The Basic View -- A Broader Point of View -- Locking Down the View -- Using Synonyms -- Summary -- Chapter 15: Modifying Data -- Inserting Data -- Updating Data -- Deleting Data -- Merging Data -- Returning Modified Data -- Summary -- Chapter 16: Modification Obstacles -- Data Type/Length -- Primary Key Constraint and Unique Constraint -- Deleting Duplicate Rows -- Foreign Key Constraints -- Null and Default Constraints -- Check Constraints -- Instead of Triggers -- After Triggers -- Non-Updateable Views -- Views With Check Option -- Calculated Columns -- Security Constraints -- Summary -- Part III: Beyond Relational -- Chapter 17: Traversing Hierarchies -- Adjacency List Pattern -- The Materialized-Path Pattern -- Using the New HierarchyID -- Summary -- Chapter 18: Manipulating XML Data -- XML Processing in SQL Server 2008 -- Sample Tables and Data -- XML Data Type.

Understanding XML Data Type Methods -- Generating XML Output Using FOR XML -- Understanding XQuery and FLWOR operations -- Understanding XQuery Functions -- Performing XML Data Modification -- Handling Namespaces -- Shredding XML Using OPENXML() -- XSD and XML Schema Collections -- Understanding XML Indexes -- XML Best Practices -- Summary -- Chapter 19: Using Integrated Full-Text Search -- Configuring Full-Text Search Catalogs -- Word Searches -- Advanced Search Options -- Fuzzy Searches -- Performance -- Summary -- Part IV: Developing with SQL Server -- Chapter 20: Creating the Physical Database Schema -- Designing the Physical Database Schema -- Creating the Database -- Creating Tables -- Creating Keys -- Creating User-Data Columns -- Creating Indexes -- Summary -- Chapter 21: Programming with T-SQL -- Transact-SQL Fundamentals -- Variables -- Procedural Flow -- Examining SQL Server with Code -- Temporary Tables and Table Variables -- Summary -- Chapter 22: Kill the Cursor! -- Anatomy of a Cursor -- Cursor Strategies -- Refactoring Complex-Logic Cursors -- Summary -- Chapter 23: T-SQL Error Handling -- Legacy Error Handling -- Raiserror -- Try...Catch -- T-SQL Fatal Errors -- Summary -- Chapter 24: Developing Stored Procedures -- Managing Stored Procedures -- Passing Data to Stored Procedures -- Returning Data from Stored Procedures -- Summary -- Chapter 25: Building User-Defined Functions -- Scalar Functions -- Inline Table-Valued Functions -- Multi-Statement Table-Valued Functions -- Summary -- Chapter 26: Creating DML Triggers -- Trigger Basics -- Working with the Transaction -- Multiple-Trigger Interaction -- Transaction-Aggregation Handling -- Summary -- Chapter 27: DDL Triggers -- Managing DDL Triggers -- Developing DDL Triggers -- Summary -- Chapter 28: Building Out the Data Abstraction Layer -- CRUD Stored Procedures.

Google-Style Search Procedure -- Summary -- Chapter 29: Dynamic SQL and Code Generation -- Executing Dynamic SQL -- Preventing SQL Injection -- Summary -- Part V: Data Connectivity -- Chapter 30: Bulk Operations -- Bulk Insert -- Bulk Insert Options -- BCP -- Summary -- Chapter 31: Executing Distributed Queries -- Distributed Query Concepts -- Accessing a Local SQL Server Database -- Linking to External Data Sources -- Developing Distributed Queries -- Distributed Transactions -- Summary -- Chapter 32: Programming with ADO.NET 3.5 -- An Overview of ADO.NET -- ADO.NET in Visual Studio 2008 -- Application Building Basics -- Summary -- Chapter 33: Sync Framework -- Sync Framework example -- Summary -- Chapter 34: LINQ -- LINQ Overview -- LINQ to SQL -- LINQ to XML -- LINQ to DataSet -- LINQ to Entities -- Summary -- Chapter 35: Asynchronous Messaging with Service Broker -- Configuring a Message Queue -- Working with Conversations -- Monitoring Service Broker -- Summary -- Chapter 36: Replicating Data -- Replication Concepts -- Configuring Replication -- Summary -- Chapter 37: Performing ETL with Integration Services -- Design Environment -- Integration Services Package Elements -- Maintainable and Manageable Packages -- Deploying Packages -- Summary -- Chapter 38: Access as a Front End to SQL Server -- Access-SQL Server Use Case Scenarios -- Migrating from Access to SQL Server -- Designing Your Access Front End -- Connecting to SQL Server -- Monitoring and Troubleshooting -- Ad Hoc Querying and Reporting -- Summary -- Part VI: Enterprise Data Management -- Chapter 39: Configuring SQL Server -- Setting the Options -- Configuration Options -- Summary -- Chapter 40: Policy-Based Management -- Defining Policies -- Evaluating Policies -- Summary -- Chapter 41: Recovery Planning -- Recovery Concepts -- Recovery Models -- Backing Up the Database.

Working with the Transaction Log -- Recovery Operations -- System Databases Recovery -- Performing a Complete Recovery -- Summary -- Chapter 42: Maintaining the Database -- DBCC Commands -- Managing Database Maintenance -- Summary -- Chapter 43: Automating Database Maintenance with SQL Server Agent -- Setting Up SQL Server Agent -- Understanding Alerts, Operators, and Jobs -- Managing Operators -- Managing Alerts -- Managing Jobs -- Database Mail -- Summary -- Chapter 44: Transferring Databases -- Copy Database Wizard -- Working with SQL Script -- Detaching and Attaching -- Import and Export Wizard -- Summary -- Chapter 45: Database Snapshots -- How Database Snapshots Work -- Creating a Database Snapshot -- Using Your Database Snapshots -- Performance Considerations and Best Practices -- Summary -- Chapter 46: Log Shipping -- Availability Testing -- Warm Standby Availability -- Defining Log Shipping -- Checking Log Shipping Configuration -- Monitoring Log Shipping -- Modifying or Removing Log Shipping -- Switching Roles -- Summary -- Chapter 47: Database Mirroring -- Database Mirroring Overview -- Defining Database Mirroring -- Checking a Database Mirroring Configuration -- Monitoring Database Mirroring -- Pausing or Removing Database Mirroring -- Role Switching -- Summary -- Chapter 48: Clustering -- SQL Server 2008 Failover Clustering Basics -- Enhancements in SQL Server 2008 Failover Clustering -- SQL Server 2008 Failover Clustering Setup -- Summary -- Part VII: Security -- Chapter 49: Authenticating Principals -- Server-Level Security -- Database-Level Security -- Windows Security -- Server Security -- Database Security -- Summary -- Chapter 50: Authorizing Securables -- Object Ownership -- Object Security -- A Sample Security Model Example -- Views and Security -- Summary -- Chapter 51: Data Cryptography -- Introduction to Cryptography.

Encrypting Data.