Table of Contents

Part I: Installation and Configuration.- 1. Planning the Deployment.- 2. GUI Installation-3. Server Core Installation.- 4. Installation on Heterogeneous Operating Systems.- 5. Configuring the Instance.-.- Part II: Database Administration.- 6. Database Configuration.- 7. Table Optimizations.- 8. Indexes and Statistics.- 9. Database Consistency.-.- Part III: Security, Resilience, and Scaling Workloads.- 10. SQL Server Security Model.- 11. Auditing & Ledger.- 12. Encryption.- 13. Backups and Restores.- 14. High Availability and Disaster Recovery Concepts.- 15. Implementing AlwaysOn Availability Groups.- 16. Implementing Log Shipping.- 17. Scaling Workloads.- Part IV: Performance and Maintenance.- 18. SQL Server Metadata.- 19. Locking and Blocking.- 20. Extended Events.- 21. Monitoring & Managing a Hybrid Environment.- 22. Query Store.-  23. Automating Maintenance Routines.- 24. Policy-Based Management.- 25. Resource Governor.

About the Author

Peter Carter is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.