Microsoft SQL Server 2005 Administrator's Pocket Consultant

Acknowledgments;
Introduction;
Who Is This Book For?;
How Is This Book Organized?;
Conventions Used in This Book;
Support;
Part I: Microsoft SQL Server 2005 Administration Fundamentals;
Chapter 1: Microsoft SQL Server 2005 Administration Overview;
SQL Server 2005 and Your Hardware;
Microsoft SQL Server 2005 Editions;
SQL Server and Windows;
Using the Graphical Administration Tools;
Using the Command-line Tools;
Chapter 2: Deploying Microsoft SQL Server 2005;
SQL Server Integration Roles;
Planning for Your SQL Server 2005 Deployment;
Running and Modifying SQL Server Setup;
Chapter 3: Managing the Surface Security, Access, and Network Configuration;
Getting Started with the Configuration Tools;
Using SQL Server 2005 Surface Area Configuration;
Configuring SQL Server Services;
Managing the Network and SQL Native Client Configuration;
Chapter 4: Configuring and Tuning Microsoft SQL Server;
Accessing SQL Server Configuration Data;
Techniques for Managing SQL Server Configuration Options;
Configuring SQL Server with Stored Procedures;
Part II: Microsoft SQL Server 2005 Administration;
Chapter 5: Managing the Enterprise;
Managing SQL Server Startup;
Using SQL Server Management Studio;
Managing SQL Server Groups;
Managing Servers;
Starting, Stopping, and Configuring SQL Server Agent;
Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator;
Starting, Stopping, and Configuring the Microsoft Search Service;
Working with Full-Text Search;
Managing Full-Text Catalogs;
Managing Server Activity;
Chapter 6: Configuring SQL Server with SQL Server Management Studio;
Managing the Configuration with SQL Server Management Studio;
Determining System and Server Information;
Configuring Authentication and Auditing;
Tuning Memory Usage;
Configuring Processors and Parallel Processing;
Configuring Threading, Priority, and Fibers;
Configuring User and Remote Connections;
Managing Server Settings;
Managing Database Settings;
Adding and Removing Active Directory Information;
Troubleshooting Configuration Problems;
Chapter 7: Core Database Administration;
Database Files and Logs;
Database Administration Basics;
Creating Databases;
Altering Databases and Their Options;
Managing Database and Log Size;
Manipulating Databases;
Tips and Techniques;
Chapter 8: Managing SQL Server 2005 Security;
Overview of SQL Server 2005 Security;
SQL Server 2005 Authentication Modes;
Special Purpose Logins and Users;
Permissions;
Roles;
Managing Server Logins;
Configuring Server Roles;
Controlling Database Access and Administration;
Managing Database Permissions;
Part III: Microsoft SQL Server 2005 Data Administration;
Chapter 9: Manipulating Schemas, Tables, Indexes, and Views;
Working with Schemas;
Getting Started with Tables;
Table Essentials;
Working with Tables;
Managing Table Values;
Using Views;
Creating and Managing Indexes;
Column Constraints and Rules;
Chapter 10: Importing, Exporting, and Transforming Data;
Working with Integration Services;
Creating Packages with the SQL Server Import and Export Wizard;
Understanding BCP;
BCP Scripts;
Using the BULK INSERT Command;
Chapter 11: Linked Servers and Distributed Transactions;
Working with Linked Servers and Distributed Data;
Managing Linked Servers;
Chapter 12: Implementing Snapshot, Merge, and Transactional Replication;
An Overview of Replication;
Planning for Replication;
Distributor Administration;
Creating and Managing Publications;
Subscribing to a Publication;
Part IV: Microsoft SQL Server 2005 Optimization and Maintenance;
Chapter 13: Profiling and Monitoring Microsoft SQL Server 2005;
Monitoring Server Performance and Activity;
Working with Replication Monitor;
Working with the Event Logs;
Monitoring SQL Server Performance;
Solving Performance Problems with Profiler;
Chapter 14: Backing Up and Recovering SQL Server 2005;
Creating a Backup and Recovery Plan;
Selecting Backup Devices and Media;
Using Backup Strategies;
Creating a Backup Device;
Performing Backups;
Restoring a Database;
Restoring the Master Database;
Mirroring Databases;
Chapter 15: Database Automation and Maintenance;
Overview of Database Automation and Maintenance;
Using Database Mail;
Using SQL Server Agent;
Managing Alerts;
Managing Operators;
Scheduling Jobs;
Automating Routine Server-to-Server Administration Tasks;
Multiserver Administration;
Database Maintenance;
Managing Log Shipping;
Using Mirroring and Log Shipping;
Appendix : William R. Stanek;