Книга "Pro SQL Server 2019 Administration. A Guide for the Modern DBA". IntroductionPart I: Installation and Configuration1. Planning the Deployment2. GUI Installation3. Server Core Installation4. Installation on Heterogeneous Operating Systems5. Configuring the InstancePart II: Database Administration6. Database Configuration7. Table Optimizations8. Indexes and Statistics9. Database ConsistencyPart III: Security, Resilience, and Scaling Workloads10. SQL Server Security Model11. Encryption12. Backups and Restores13. High Availability and Disaster Recovery Concepts14. Implementing AlwaysOn Availability Groups15. Implementing Log Shipping16. Scaling WorkloadsPart IV: Performance and Maintenance17. SQL Server Metadata18. Locking and Blocking19. Extended Events20. Query Store21. Distributed Replay22. Automating Maintenance Routines23. Policy-Based Management24. Resource Governor