Microsoft SQL Server 2008 -- Table of Contents -- Introduction -- Part I Welcome to SQL Server 2008 -- Chapter 1 Introducing SQL Server 2008 -- Starting Off on the Right Foot -- Understanding the Basic Components of SQL Server -- Implementing Databases with SQL Server 2008 -- What's New in SQL Server 2008 -- Chapter 2 Building Your SQL Server -- Installing SQL Server 2008 -- Upgrading an Existing SQL Server Installation -- Configuring Database Mail -- Using SQL Server's Built-In Databases -- Chapter 3 Working with SQL Server Tools -- Using SQL Server Configuration Manager -- Managing Your Server with SQL Server Management Studio -- Working from the Command Line -- Part II Building SQL Server 2008 Databases -- Chapter 4 Planning Your Database -- Introducing Database Design Concepts -- Understanding the Elements of a Database -- Organizing a Database -- Diagramming Your Database -- Staying Fit and Trim with Normalization -- Choosing Data Types for Your Tables -- Working with NULL Values -- Chapter 5 Creating Databases and Tables -- Creating a Database -- Specifying Files and Filegroups -- Creating a Table -- Chapter 6 Imposing Constraints and Relationships -- Introducing Constraints -- Controlling Database Contents Using Constraints -- Enforcing Database Integrity -- Part III Retrieving Data from Databases -- Chapter 7 Constructing Simple Database Queries -- Retrieving Data with SELECT Statements -- Organizing Query Results -- Chapter 8 Joins and Other Advanced Queries -- Joining Data from Multiple Tables -- Taking SELECT to the Next Level -- Using Database Views -- Chapter 9 Turning Data into Information with SQL Server Reporting Services -- Setting up SQL Server Reporting Services -- Creating an SSRS Report with Report Builder -- Working with Deployed (Published) Reports -- Part IV Inserting and Manipulating Your Data.

Chapter 10 Inserting, Updating, and Deleting Data -- Inserting Small Quantities of Data -- Modifying and Deleting Data -- Importing Large Quantities of Data -- Working with SQL Server Integration Services -- Chapter 11 Saving Time with Functions, Stored Procedures, and Triggers -- Reusing Logic with Functions -- Leveraging SQL Server's built-in functions -- Creating Your Own Functions -- Reusing SQL Code with Stored Procedures -- Updating Data Automatically with Triggers -- Modifying and Deleting Functions, Stored Procedures, and Triggers -- Part V SQL Server Administration -- Chapter 12 Keeping Your SQL Server Running Smoothly -- Indexing Data to Improve Query Performance -- Improving Performance with Partitions -- Updating Database Statistics -- Managing File Sizes -- Checking Database Integrity -- Governing Resource Consumption -- Chapter 13 Automating SQL Server 2008 Administration -- Scheduling Tasks with SQL Server Agent -- Implementing Database Maintenance Plans -- Alerting Administrators about Database Events -- Chapter 14 Troubleshooting SQL Server 2008 Problems -- Understanding the Inner Workings of SQL Server Queries -- Reviewing Log Records -- Monitoring Your Server with Performance Studio -- Tuning Your Database with Database Engine Tuning Advisor -- Chapter 15 Replicating Data across Multiple Servers -- Understanding Replication -- Publishing Data with Snapshot Replication -- Subscribing to a Publication -- Monitoring Replication -- Part VI Protecting Your Data -- Chapter16 Protecting Your Data from Prying Eyes -- Creating and Managing Logins -- Adding Database Users -- Managing Rights with Roles -- Preserving Confidentiality with Encryption -- Auditing SQL Server Activity -- Chapter 17 Preserving the Integrity of Your Transactions -- Preserving Transaction Integrity with the ACID Model -- Creating SQL Server Transactions.

Changing the Transaction Isolation Level -- Handling Errors -- Chapter 18 Preparing for Disaster -- Backing Up Your Data -- Specifying Disaster Recovery Requirements with Recovery Models -- Restoring Your Data after a Disaster -- Using Database Snapshots -- Chapter 19 Staying Alive: High Availability in SQL Server 2008 -- Creating Redundancy with Database Mirroring -- Synchronizing Databases with Log Shipping -- Chapter 20 Implementing Policy-Based Management with the Declarative Management Framework -- Coming to Terms with DMF -- Creating DMF Policies -- Using On Demand Evaluation Mode -- Automated Policy Enforcement -- Viewing Policies Affecting a Target -- Part VII The Part of Tens -- Chapter 21 Ten Ways to Keep Your SQL Server 2008 Databases Humming -- Monitor Query Performance -- Back Up Your Data Routinely -- Verify Database Integrity Often -- Tune the Physical Structure of Your Databases -- Conserve Transaction Log Disk Space -- Monitor Database Logs -- Automate Administrative Alerts -- Manage Multiple Servers -- Simplify User Rights Administration with Roles -- Perform Security Reviews -- Chapter 22 Ten Database Design Tips -- Plan Ahead -- Draw Before You Click -- Choose Primary Keys Carefully -- Select Data Types with Space Efficiency in Mind -- Make Sure Your Fields Are Single Purpose -- Remember the Meaning of NULL -- Normalize when Possible -- Manage Your Relationships -- Use Descriptive Names -- Document Your Design -- Index.