Pro SQL Server 2022 Administration A Guide for the Modern DBA
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 his...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2023.
|
| Edición: | 3rd ed. 2023. |
| Colección: | ITpro collection
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009724839306719 |
Tabla de Contenidos:
- 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.
