Table of Contents

1 Introduction to the SQL Server Platform
2 SQL Server Architecture
3 Installing and Configuring SQL Server
4 Database Objects
5 Security
6 Data Access and Transaction Control
7 Backup and Recovery
8 Performance Tuning and Optimization
9 High Availability and Disaster Recovery
10 Scheduling, Automation and Alerting
11 Data Movement
12 Upgrading and Migrating to SQL Server
Index

About the Author

Mark Anderson is a data platform technical specialist for Microsoft in the UK working with its largest enterprise customers. He holds certifications in both the SQL Server and Oracle platforms and has trained Oracle DBAs in SQL Server administration.

James Fox is an independent consultant providing database administration, support, and consulting services to enterprise customers using primarily Oracle databases. He has delivered SQL Server training to experienced Oracle DBAs.

Christian Bolton is the Technical Director for Coeo Ltd., a Microsoft Gold Partner focused on large-scale and complex SQL Server projects in EMEA. He is a Microsoft Certified Architect and MVP for SQL Server.