Table of Contents:
  • pt. I. Welcome to SQL Serve: 2008
  • Ch. 1. Introducing SQL Server 2008
  • Ch. 2. Building Your SQL Server
  • Ch. 3. Working with SQL Server Tools
  • pt. II. Building SQL Server 2008 Databases
  • Ch. 4. Planning Your Database
  • Ch. 5. Creating Databases and Tables
  • Ch. 6. Imposing Constraints and Relationships
  • pt. III. Retrieving Data from Databases
  • Ch. 7. Constructing Simple Database Queries
  • Ch. 8. Joins and Other Advanced Queries
  • Ch. 9. Turning Data into Information with SOL Server Reporting Services
  • pt. IV. Inserting and Manipulating Your Data
  • Ch. 10. Inserting, Updating, and Deleting Data
  • Ch. 11. Saving Time with Functions, Stored Procedures, and Triggers
  • pt. V. SQL Server Administration
  • Ch. 12. Keeping Your SQL Server Running Smoothly
  • Ch. 13. Automating SQL Server 2008 Administration
  • Ch. 14. Troubleshooting SOL Server 2008 Problems
  • Ch. 15. Replicating Data across Multiple Servers
  • pt. VI. Protecting Your Data
  • Ch. 16. Protecting Your Data from Prying Eyes
  • Ch. 17. Preserving the Integrity of Your Transactions
  • Ch. 18. Preparing for Disaster
  • Ch. 19. Staying Alive: High Availability in SQL Server 2008
  • Ch. 20. Implementing Policy-Based Management with the Declarative Management Framework
  • pt. VII. The Part of Tens
  • Ch. 21. Ten Ways to Keep Your SQL Server 2008 Databases Humming
  • Ch. 22. Ten Database Design Tips