Microsoft SQL Server 2008 for dummies / by Mike Chapple.

If you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management -- read Microsoft SQL Server 2008 For Dummies!SQL Server 2008 lets you build pow...

Full description

Saved in:
Bibliographic Details
Main Author: Chapple, Mike
Format: eBook
Language:English
Published: Hoboken, NJ : Wiley, 2008.
Series:--For dummies.
Subjects:
Online Access:Click for online access
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.