Microsoft SQL Server 2008 Step by Step

Acknowledgments; Introduction; Who This Book Is For; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; System Requirements; Sample Databases; Practice Files; Find Additional Content Online; Support for This Book; Part I: Getting Started with Microsoft SQL Server 2008; Chapter 1: Overview of Microsoft SQL Server; 1.1 Database Engine; 1.2 Business Intelligence; 1.3 Chapter 1 Quick Reference; Chapter 2: Installing and Configuring SQL Server 2008; 2.1 Editions of SQL Server 2008; 2.2 Infrastructure Requirements; 2.3 Service Accounts; 2.4 Collation Sequences; 2.5 Authentication Modes; 2.6 SQL Server Instances; 2.7 Upgrading to SQL Server 2008; 2.8 Installing SQL Server 2008; 2.9 Chapter 2 Quick Reference; Chapter 3: Using the Tools in SQL Server 2008; 3.1 SQL Server Documentation; 3.2 Management Tools in SQL Server 2008; 3.3 Performance Management Tools; 3.4 Business Intelligence Tools; 3.5 Chapter 3 Quick Reference; Part II: Designing Databases; Chapter 4: Creating Databases; 4.1 SQL Server System Databases; 4.2 SQL Server Database Structure; 4.3 Creating a Database; 4.4 Moving Databases; 4.5 Chapter 4 Quick Reference; Chapter 5: Designing Tables; 5.1 Naming Objects; 5.2 Schemas; 5.3 Data Types; 5.4 Column Properties; 5.5 Creating Tables; 5.6 Computed Columns; 5.7 Sparse Columns; 5.8 Constraints; 5.9 Database Diagrams; 5.10 Chapter 5 Quick Reference; Chapter 6: Indexes; 6.1 Index Structure; 6.2 Clustered Indexes; 6.3 Nonclustered Indexes; 6.4 Included Columns; 6.5 Filtered Indexes; 6.6 Online Index Creation; 6.7 Index Management and Maintenance; 6.8 XML Indexes; 6.9 Spatial Indexes; 6.10 Chapter 6 Quick Reference; Chapter 7: Partitioning; 7.1 Partition Functions; 7.2 Partition Schemes; 7.3 Partitioning Tables and Indexes; 7.4 Managing Partitions; 7.5 Chapter 7 Quick Reference; Part III: Retrieving and Manipulating Data; Chapter 8: Data Retrieval; 8.1 General SELECT Statement; 8.2 Sorting Results; 8.3 Filtering Data; 8.4 Retrieving from More Than One Table; 8.5 Retrieving Unique Results; 8.6 Chapter 8 Quick Reference; Chapter 9: Advanced Data Retrieval; 9.1 General SELECT Statement; 9.2 Aggregating Data; 9.3 Aggregating Result Sets; 9.4 Common Table Expressions; 9.5 Querying XML Data; 9.6 Chapter 9 Quick Reference; Chapter 10: Data Manipulation; 10.1 Inserting Data; 10.2 Updating Data; 10.3 Deleting Data; 10.4 MERGE Statement; 10.5 OUTPUT Clause; 10.6 Transaction Handling; 10.7 Tracking Changes; 10.8 Chapter 10 Quick Reference; Part IV: Designing Advanced Database Objects; Chapter 11: Views; 11.1 Creating a View; 11.2 Modifying Data Through a View; 11.3 Creating an Indexed View; 11.4 Chapter 11 Quick Reference; Chapter 12: Stored Procedures; 12.1 Creating Stored Procedures; 12.2 Commenting Code; 12.3 Variables, Parameters, and Return Codes; 12.4 Executing Stored Procedures; 12.5 Control Flow Constructs; 12.6 Error Handling; 12.7 Dynamic Execution; 12.8 Cursors; 12.9 CLR Procedures; 12.10 Building an Administrative Procedure; 12.11 Chapter 12 Quick Reference; Chapter 13: Functions; 13.1 System Functions; 13.2 Creating a Function; 13.3 Retrieving Data from a Function; 13.4 Chapter 13 Quick Reference; Chapter 14: Triggers; 14.1 DML Triggers; 14.2 DDL Triggers; 14.3 Chapter 14 Quick Reference; Chapter 15: Database Snapshots; 15.1 Creating a Database Snapshot; 15.2 Reverting Data Using a Database Snapshot; 15.3 Chapter 15 Quick Reference; Chapter 16: Service Broker; 16.1 Service Broker Architecture; 16.2 Message Types and Contracts; 16.3 Queues and Services; 16.4 Conversations; 16.5 Sending and Receiving Messages; 16.6 Queue Activation; 16.7 Prioritization; 16.8 Chapter 16 Quick Reference; Chapter 17: Full-Text Indexing; 17.1 Full-Text Catalogs; 17.2 Full-Text Indexes; 17.3 Querying Full-Text Data; 17.4 Chapter 17 Quick Reference; Part V: Database Management; Chapter 18: Security; 18.1 Configuring the Attack Surface; 18.2 Endpoints; 18.3 Principals, Securables, and Permissions; 18.4 CLR Security; 18.5 Data Encryption; 18.6 Chapter 18 Quick Reference; Chapter 19: Policy-Based Management; 19.1 Overview of Policy-Based Management; 19.2 Facets; 19.3 Conditions; 19.4 Policy Targets; 19.5 Policies; 19.6 Policy Categories; 19.7 Policy Compliance; 19.8 Chapter 19 Quick Reference; Chapter 20: Data Recovery; 20.1 Database Backups; 20.2 Recovery Models; 20.3 Database Restores; 20.4 Chapter 20 Quick Reference; Chapter 21: SQL Seeeeeerver Agent; 21.1 Creating Jobs; 21.2 Creating Maintenance Plans; 21.3 Creating Alerts; 21.4 Chapter 21 Quick Reference; Chapter 22: Dynamic Management Views; 22.1 Overview of DMVs; 22.2 Retrieving Object Metadata; 22.3 Database Diagnostics; 22.4 Chapter 22 Quick Reference; Part VI: High Availability Overview; Chapter 23: High Availability; 23.1 Failover Clustering; 23.2 Database Mirroring; 23.3 Log Shipping; 23.4 Replication; 23.5 Chapter 23 Quick Reference; Part VII: Business Intelligence; Chapter 24: SQL Server Integration Services; 24.1 BIDS Overview; 24.2 Tasks; 24.3 Transforms; 24.4 Building a Package; 24.5 Chapter 24 Quick Reference; Chapter 25: SQL Server Reporting Services; 25.1 Configuring Reporting Services; 25.2 Reporting Services Web Site; 25.3 Creating Reports; 25.4 Deploy Reports; 25.5 Report Subscriptions; 25.6 Linked Reports; 25.7 Report Caching and Snapshots; 25.8 Chapter 25 Quick Reference; Chapter 26: SQL Server Analysis Services; 26.1 Data Warehousing Overview; 26.2 Online Analytic Processing (OLAP); 26.3 KPIs, Partitions, Perspectives, and Translations; 26.4 Data Mining; 26.5 Chapter 26 Quick Reference; About the Author; Additional Resources for Developers from Microsoft Press; Visual Basic; Visual C#; Web Development; Data Access; SQL Server; Other Developer Topics; More Great Developer Resources; Developer Step by Step; Developer Reference; Focused Topics;