You are previewing SQL Server® 2008 Administration: Instant Reference.
O'Reilly logo
SQL Server® 2008 Administration: Instant Reference

Book Description

Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals

System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues. This convenient guide offers you quick referencing for the product and database topics you need most.

If you're an IT administrator looking for the essentials in the day-to-day tasks of administering SQL Server 2008, you'll appreciate this book's design for providing quick and easy look up of solutions and tables, lists, and step-by-step instructions for answers on the spot. SQL Server 2008 Instant Administration Reference is a guide that you want to keep within reach.

  • SQL Server is Microsoft's bestselling database manager; the 2008 version offers enhanced security and high availability, encouraging users to upgrade

  • Features thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists to provide answers on the spot

  • Covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting

SQL Server 2008 Administration Instant Reference answers the questions you encounter most often in your daily work.

Table of Contents

  1. Copyright
  2. Dear Reader
  3. Dedication
  4. Acknowledgments
  5. About the Authors
  6. Introduction
  7. SQL Server Basics
    1. Installing SQL Server 2008
      1. Prepare for Installation
      2. Install SQL Server 2008
    2. Configuring SQL Server 2008
      1. Configure the Server Platform
      2. Configure SQL Server 2008
    3. Creating Databases, Files, and Tables
      1. Perform Capacity Planning
      2. Create and Alter Databases
      3. Manage Database Files
      4. Create and Alter Tables
    4. Executing Basic Queries
      1. Use SQL Server Schemas
      2. Select Data from a Database
      3. Modify Data
      4. Use the SQL Server System Catalog
  8. Data Integrity and Security
    1. Managing Data Integrity
      1. Implement Entity Integrity
      2. Implement Domain Integrity
      3. Implement Referential Integrity
      4. Understand Procedural Integrity
    2. Managing Transactions and Locks
      1. Manage SQL Server Locks
      2. Manage Transactions
      3. Implement Distributed Transactions
      4. Manage Special Transaction Situations
    3. Managing Security
      1. Implement User Security
      2. Implement Roles
      3. Implement Permissions
      4. Encrypt Data with Keys
  9. Data Administration
    1. Implementing Availability and Replication
      1. Implement Availability Solutions
      2. Implement Replication
    2. Extracting, Transforming, and Loading Data
      1. Use the Bulk Copy Program Utility
      2. Use the SQL Server Import and Export Wizard
      3. Create Transformations Using SQL Server Integration Services (SSIS)
    3. Managing Data Recovery
      1. Understand Recovery Concepts
      2. Perform Backup Operations
      3. Perform Restore Operations
  10. Performance and Advanced Features
    1. Monitoring and Tuning SQL Server
      1. Monitor SQL Server
      2. Tune SQL Server
    2. Planning and Creating Indexes
      1. Understand Index Architecture
      2. Create and Manage Indexes
      3. Manage Special Index Operations
    3. Policy-Based Management
      1. Understand Policy-Based Management
      2. Manage Policies in the Enterprise
    4. Automating with the SQL Server Agent Service
      1. Configure the SQL Server Agent Service
      2. Create and Configure Automation Objects
  11. Index