For Jodster, Lachie, and Bella
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