Pro SQL Server 2019 Administration: A Guide for the Modern DBA

Peter Carter

ISBN 10: 1484250885 / ISBN 13: 9781484250884

Verlag: Apress, 2019

Beschreibung

Bestandsnummer des Verkäufers U9781484250884

Bibliografische Details

• Titel: Pro SQL Server 2019 Administration: A Guide for the Modern DBA
• Verlag: Apress
• Veröffentlichungsdatum: 2019
• Sprache: Englisch
• ISBN-10: 1484250885
• ISBN-13: 9781484250884
• Bindung: Softcover
• Ausgabe: 1750424251.
• Zustand: Very Good
• Zustand des Schutzumschlags: 45975373
• Signiert: 6/20/2025 12:57:31 PM
• Verkäuferkataloge:
  • 9781484250884
  • 1
  • U

Über diesen Titel

Inhaltsangabe

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

Über die Autorin bzw. den Autor

Peter Carter is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.