Pro SQL Server 2019 Administration A Guide for the Modern DBA
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...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2019.
|
| Edición: | 2nd ed. 2019. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630821006719 |
Tabla de Contenidos:
- 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.
