You are previewing SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond.
O'Reilly logo
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Book Description

The ideal on-the-job reference guide for SQL Server 2008 database administrators

If you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.

And, if you're preparing for MCTS or MCITP certification in SQL Server 2008 administration, this book is the perfect supplement to your preparation, featuring a CD with practice exams, flashcards, and video walkthroughs of the more difficult administrative tasks

  • Delves into Microsoft's SQL Server 2008, a rich set of enterprise-level database services for business-critical applications

  • Explores the skills you'll need on the job as a SQL Server 2008 administrator

  • Shows you how to implement, maintain, and repair the SQL Server database, including bonus videos on the CD where the authors walks you through the more difficult tasks

  • Covers database design, installation and configuration, creating databases and tables, security, backup and high availability, and more

  • Supplements your preparation for MCTS and MCITP SQL Server 2008 certification with in-depth coverage of the skill sets required for certification, as defined by Microsoft

  • Uses hands-on exercises and real-world scenarios to keep what you're learning grounded in the reality of the workplace

Make sure you're not only prepared for certification, but also for your job as a SQL Server 2008 administrator, with this practical reference!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Dear Reader,
  5. Dedication
  6. Acknowledgments
  7. About the Author
  8. Contents at a Glance
  9. Contents
  10. Table of Exercises
  11. Introduction
    1. Who Should Read This Book
    2. What Is Covered in This Book
    3. How to Contact the Author
  12. Part I: Introducing SQL Server 2008
    1. Chapter 1: Understanding SQL Server's Role
      1. What Is Information Technology?
      2. Introduction to Databases
      3. Database Servers and Applications
      4. SQL Server's Role
      5. Summary
      6. Chapter Essentials
    2. Chapter 2: Installing SQL Server 2008
      1. Installation Planning
      2. Installing a Default Instance
      3. Installing Named Instances
      4. Installing to a Cluster
      5. Installing Extra Features
      6. Upgrading from Previous Versions
      7. Removing an Installation
      8. Summary
      9. Chapter Essentials
    3. Chapter 3: Working with the Administration Tools
      1. SQL Server Configuration Manager
      2. SQL Server Management Studio (SSMS)
      3. SQL Server Business Intelligence Development Studio
      4. SQL Server Profiler
      5. Books Online
      6. Windows Server Administration for the DBA
      7. Summary
      8. Chapter Essentials
    4. Chapter 4: SQL Server Command-Line Administration
      1. Introducing the Command Prompt
      2. General Commands
      3. Batch Files
      4. Mastering SQLCMD
      5. Introducing Windows PowerShell
      6. Using SQL Server PowerShell Extensions
      7. Windows Scripting Host
      8. Summary
      9. Chapter Essentials
  13. Part II: Designing Database Solutions
    1. Chapter 5: Database Concepts and Terminology
      1. Relational Database Theory
      2. Database Design Processes
      3. Project Management for the DBA
      4. Summary
      5. Chapter Essentials
    2. Chapter 6: ERD and Capacity Planning
      1. Planning a Database
      2. Understanding Entity Relationship Diagramming
      3. Building an ERD
      4. Capacity Planning
      5. Summary
      6. Chapter Essentials
    3. Chapter 7: Normalization: Enough Is Enough
      1. Normalization Defined
      2. Normal Forms
      3. Normalizing a Database
      4. Denormalizing a Database
      5. Designing for Performance
      6. Designing for Availability
      7. Designing for Security
      8. Summary
      9. Chapter Essentials
  14. Part III: Implementing Database Solutions
    1. Chapter 8: Creating SQL Server Databases
      1. SQL Server Databases
      2. Database Storage
      3. Database Options and Properties
      4. Creating Databases in the GUI
      5. Creating Databases with T-SQL
      6. Creating Databases with PowerShell
      7. Attaching and Detaching Databases
      8. Database Snapshots
      9. Summary
      10. Chapter Essentials
    2. Chapter 9: Creating Tables
      1. Data Types
      2. Collations
      3. Creating Tables
      4. Data Partitioning
      5. Summary
      6. Chapter Essentials
    3. Chapter 10: Indexes and Views
      1. Understanding Indexes
      2. Creating Basic Indexes
      3. Creating Advanced Indexes
      4. Managing Indexes
      5. Understanding Views
      6. Creating Views
      7. Summary
      8. Chapter Essentials
    4. Chapter 11: Triggers and Stored Procedures
      1. Triggers Defined
      2. Using Triggers
      3. Creating Triggers
      4. Understanding Stored Procedures
      5. Creating Stored Procedures
      6. Summary
      7. Chapter Essentials
    5. Chapter 12: Implementing Advanced Features
      1. Understanding and Installing Analysis Services
      2. Understanding Integration Services
      3. Understanding and Installing Reporting Services
      4. Implementing Database Mail
      5. Configuring Full-Text Indexing
      6. Summary
      7. Chapter Essentials
  15. Part IV: Administration and Maintenance
    1. Chapter 13: Creating Jobs, Operators, and Alerts
      1. Standardize, Automate, and Update
      2. Understanding SQL Server Jobs
      3. Creating T-SQL Jobs
      4. Creating SSIS Jobs
      5. Creating Windows Command Jobs
      6. Creating and Using Operators
      7. Creating and Using Alerts
      8. Using WSUS for SQL Server 2008
      9. Summary
      10. Chapter Essentials
    2. Chapter 14: Performance Monitoring and Tuning
      1. Performance and Troubleshooting Tools
      2. Blocks, Locks, and Deadlocks
      3. SQL Server Profiler
      4. Database Engine Tuning Advisor
      5. Performance Monitoring with System Monitor
      6. Using the New Resource Governor
      7. Performance Studio
      8. Advanced Monitoring Tools
      9. Summary
      10. Chapter Essentials
    3. Chapter 15: Policy-Based Management
      1. Policy-Based Management (PBM)
      2. Centralized Server Management
      3. Standardizing with PBM and CMS
      4. Summary
      5. Chapter Essentials
    4. Chapter 16: Backup and Restoration
      1. Backing Up a Database
      2. Back Up System Databases
      3. Restore a Database
      4. Back Up the Environment
      5. Summary
      6. Chapter Essentials
  16. Part V: SQL Server Security
    1. Chapter 17: Security Threats and Principles
      1. Security Defined
      2. Security Threats
      3. Security Principles
      4. Summary
      5. Chapter Essentials
    2. Chapter 18: Authentication and Encryption
      1. Understanding Authentication
      2. SQL Server Authentication Methods
      3. Logins, Users, and Roles
      4. Understanding Encryption
      5. Summary
      6. Chapter Essentials
    3. Chapter 19: Security Best Practices
      1. Establishing Baselines
      2. Implementing Least Privilege
      3. Auditing SQL Server Activity
      4. Configuring the Surface Area
      5. Understanding Common Criteria and C2
      6. Summary
      7. Chapter Essentials
  17. Part VI: High Availability and Data Distribution
    1. Chapter 20: SQL Server Failover Clustering
      1. Understanding Windows Failover Clustering Service
      2. Implementing a Windows Cluster
      3. Installing SQL Server 2008 to a Cluster
      4. Monitoring and Managing a SQL Server Cluster
      5. Summary
      6. Chapter Essentials
    2. Chapter 21: Database Mirroring and Snapshots
      1. RAID-Based Data Redundancy
      2. Using Database Mirroring
      3. Understanding Log Shipping
      4. Implementing Database Snapshots
      5. Summary
      6. Chapter Essentials
    3. Chapter 22: Implementing Replication
      1. SQL Server Replication
      2. Importing and Exporting Data
      3. Summary
      4. Chapter Essentials
    4. Appendix A: Microsoft's Certification Program
      1. How Do You Become Certified on SQL Server 2008?
      2. Certification Objectives Map
    5. Appendix B: About the Companion CD
      1. What's on the CD
      2. System Requirements
      3. Using the CD
      4. Troubleshooting
    6. Glossary
      1. A
      2. B
      3. C
      4. D
      5. E
      6. F
      7. G
      8. I
      9. L
      10. N
      11. O
      12. P
      13. R
      14. S
      15. T
      16. U
      17. V
      18. X
  18. Index