
- 464 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
SQL Server 2008 Administration in Action
About this book
SQL Server 2008 Administration isn't a standard SQL Server tutorial-thereare dozens of those to choose from. Instead, this book breaks down the role of"SQL Server Administrator" into its key focus areas and tasks and details thetechniques and best practices that make an administrator effective.In this book, a reader can quickly identify a task and find the best practiceassociated with it. For example, a reader looking for information about indexingwould find step-by-step procedures for identifying and dropping unusedindexes, creating missing indexes, selecting the appropriate clustered index, and so forth.Each technique is presented in a clear, straightforward style and in the order ofthe typical lifecycle of a SQL Server system. This allows a reader to easily openthe book at the appropriate page and focus on what you need to know for eachspecific situation.While most techniques will work for all versions of SQL Server, this book is currentfor the recent final release of SQL Server 2008. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Copyright
- Dedication
- Brief Table of Contents
- Table of Contents
- Foreword
- Preface
- Acknowledgments
- About this Book
- About the Cover Illustration
- About the Author
- Part 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
- Part 2. Configuration
- Chapter 6. Security
- Chapter 7. Configuring SQL Server
- Chapter 8. Policy-based management
- Chapter 9. Data management
- Part 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
- Appendix C. Common Performance Monitor counters
- Appendix D. Top 10 Management Studio enhancements
- Appendix E. Date/time data types in SQL Server 2008
- Index
- List of Figures
- List of Tables
- List of Listings