Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features - page 1
- Table of Contents
- Table of Contents
- Back Cover
- Microsoft SQL Server 2005-The Complete Reference
- Introduction
- A Book for All Teammates
- Whats Inside
- Work in Progress
- Part I: SQL Server 2005 System and Platform Architecture
- Chapter 1: Getting to Know SQL Server 2005
- Line-of-Business Applications
- The Distributed Network Application
- So, What Is SQL Server 2005?
- Central Design Themes
- Overview of the Core Architectures
- The Collateral Services
- Chapter 2: Database Architecture
- Introduction to SQL Server Databases
- The Logical Database Architecture
- The Physical Database Architecture
- The Network Ahead
- Chapter 3: RDBMS Architecture
- The TPC Benchmarks
- An Overview of the DBMS Components
- The Relational Database Engine
- Memory Architecture
- SQL Server I0 Architecture
- SQL Servers Thread and Task Architecture
- SQL Server Transaction Architecture
- Reading and Writing the Data Pages
- SQL, Query Optimization, and Query Processing
- Inside Data Streams, Again
- Pulling the Relational Train
- Chapter 4: Connecting to and Administering the Database Engine
- Connecting to SQL Server
- SQL Server 2005 Administrative Architecture
- Introducing SQL Server Tools
- Getting Started with SQL Server Management Studio
- SQL Servers Automated Administration Architecture
- SQL Server Agent
- Using the SQL Server Agent
- Configuring SQL Servers Mailing Engines
- Maintenance Plans
- The Network Ahead
- Part II: Administering SQL Server 2005
- Chapter 5: Security
- Data Security Primer
- SQL Server Access
- Kerberos Tickets: The Keys to Trusted Access
- Secure Sockets Layer
- Microsoft Certificate Services
- Trusted Access Versus Nontrusted Access
- SQL Server Security: The Internal Environment
- Managing SQL Server Security
- Auditing
- The SQL Server Security Plan
- In Review
- Chapter 6: Databases, Tables, and Indexes
- The New SQL Server 2005 File System
- Understanding Filegroups
- Creating a SQL Server Database
- Tables
- Moving Data, Log, and Full-Text Files
- Indexes
- Performance, Optimization, and Tuning
- In Review
- Chapter 7: SQL Server Disaster Recovery
- Establishing Baselines for Disaster Recovery
- Transaction Recovery
- SQL Server 2005 Recovery Architecture
- SQL Server 2005 Backup and Restore Architecture
- Types of Database Backups for SQL Server 2005
- Backup Devices
- Backing Up SQL Server
- SQL Server Backup Bandwidth
- SQL Server Backup by Design
- Creating a Backup Maintenance Plan
- In Review
- Chapter 8: Distributed Database Architecture
- SQL Server 2005 Replication Services