Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You''ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL.
Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data i
Table of Contents
Part I: Installation and Configuration1. Planning the Deployment2. GUI Installation3. Server Core Installation4. Installation on Heterogeneous Operating Systems5. Configuring the Instance
Part II: Database Administration6. Database Configuration7. Table Optimizations8. Indexes and Statistics9. Database Consistency
Part III: Security, Resilience, and Scaling Workloads10. SQL Server Security Model11. Auditing & Ledger12. Encryption13. Backups and Restores14. High Availability and Disaster Recovery Concepts15. Implementing AlwaysOn Availability Groups16. Implementing Log Shipping17. Scaling Workloads
Part IV: Performance and Maintenance18. SQL Server Metadata19. Locking and Blocking20. Extended Events21. Monitoring & Managing a Hybrid Environment22. Query Store23. Automating Maintenance Routines
24. Policy-Based Management25. Resource Governor
