Pro SQL Server 2022 Administration: A guide for the modern DBA 3rd Edition

Pro SQL Server 2022 Administration: A guide for the modern DBA 3rd Edition – Ebook Instant Download/Delivery ISBN(s): 9781484288634,1484288637,9781484288641, 1484288645

Product details:

• ISBN-10 ‏ : ‎ 1484288645
• ISBN-13 ‏ : ‎ 9781484288641
• Author: Peter A. Carter

Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data issecure and highly available. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server’s hybrid cloud functionality.

Table contents:

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 and 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 and Managing a Hybrid Environment

22. Query Store

23. Automating Maintenance Routines

24. Policy-Based Management

25. Resource Governor

People also search:

microsoft sql server 2016 adomd.net

pro admin services

pro sql server administration pdf

sql server 2019 administration

sql server 2022 azure

best practice sql server 2019 installation