Dedication

For Jodster, Lachie, and Bella

Brief Table of Contents

 

Copyright

Brief Table of Contents

Table of Contents

Foreword

Preface

Acknowledgments

About this Book

About the Cover Illustration

About the Author

1. Planning and installation

Chapter 1. The SQL Server landscape

Chapter 2. Storage system sizing

Chapter 3. Physical server design

Chapter 4. Installing and upgrading SQL Server 2008

Chapter 5. Failover clustering

2. Configuration

Chapter 6. Security

Chapter 7. Configuring SQL Server

Chapter 8. Policy-based management

Chapter 9. Data management

3. Operations

Chapter 10. Backup and recovery

Chapter 11. High availability with database mirroring

Chapter 12. DBCC validation

Chapter 13. Index design and maintenance

Chapter 14. Monitoring and automation

Chapter 15. Data Collector and MDW

Chapter 16. Resource Governor

Chapter 17. Waits and queues: a performance-tuning methodology

Appendix A. Top 25 DBA worst practices

Appendix B. Suggested DBA work plan

Index