Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress L. P.,
2022.
|
| Edición: | Third edition. |
| Colección: | ITpro collection
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
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.