책 이미지
eBook 미리보기
책 정보
· 제목 : Pro SQL Server 2019 Administration: A Guide for the Modern DBA (Paperback, 2)
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484250884
· 쪽수 : 940쪽
· 출판일 : 2019-10-19
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484250884
· 쪽수 : 940쪽
· 출판일 : 2019-10-19
목차
Introduction
Part I: Installation and Configuration
1. Planning the Deployment
2. GUI Installation
3. PowerShell Installation
4. Installation on Heterogeneous Operating Systems
5. Instance Configuration
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. AlwaysOn Availability Groups
15. Log Shipping
16. Scaling Workloads
Part IV: Performance and Maintenance
17. 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
