Pro SQL Server 2019 Administration A Guide for the Modern DBA /

• Κύριος συγγραφέας: Carter, Peter A. (Συγγραφέας, http://id.loc.gov/vocabulary/relators/aut)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2019.
• Έκδοση: 2nd ed. 2019.
• Θέματα: Database management.; Database Management.

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure...

Πίνακας περιεχομένων:

• Introduction
• 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. Encryption
• 12. Backups and Restores
• 13. High Availability and Disaster Recovery Concepts
• 14. Implementing AlwaysOn Availability Groups
• 15. Implementing Log Shipping
• 16. Scaling Workloads
• Part IV: Performance and Maintenance
• 17. SQL Server Metadata
• 18. Locking and Blocking
• 19. Extended Events
• 20. Query Store
• 21. Distributed Replay
• 22. Automating Maintenance Routines
• 23. Policy-Based Management
• 24. Resource Governor.