Description
Pro SQL Server 2022 Administration (3rd Ed., 3rd ed.)
A Guide for the Modern DBA
Author: Carter Peter A.
Language: EnglishSubject for Pro SQL Server 2022 Administration:
Keywords
Static Data Masking; Query Store; Hybrid Buffer Pool; SQL Server on Linux; Always Encrypted Encryption Feature; Secure Enclaves; Hybrid Buffer Pool; PowerShell; Backup and Restore; High Availability and Disaster Recovery; AlwaysOn Availability Groups; Log Shipping; Extended Events; Distributed Replay; Azure Purview; Policy-Based Management; Professional SQL Server Administration; SQL Server Ledger; Azure Arc; Managed Instance
987 p. · 17.8x25.4 cm · Paperback
Description
/li>Contents
/li>Biography
/li>Comment
/li>
- Integrate SQL Server with Azure for hybrid cloud scenarios
- Audit changes and prevent malicious data changes with SQL Server?s Ledger
- Secure and encrypt data to protect against embarrassing data breaches
- Ensure 24 x 7 x 365 access through high availability and disaster recovery features in today?s hybrid world
- Use Azure tooling, including Arc, to gain insight into and manage your SQL Server enterprise
- Install and configure SQL Server on Windows, Linux, and in containers
- Perform routine maintenance tasks, such as backups and database consistency checks
- Optimize performance and undertake troubleshooting in the Database Engine
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.