Pro SQL Server 2019 administration : a guide for the modern DBA /: a guide for the modern DBA. ([2019])

• Record Type: Book
• Further Information: Note: Peter A. Carter.
• Authors: Carter, Peter A
• Contents: 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.
• Edition: Second edition
• Publisher Details: New York : Apress
• Publication Date: 2019
• Copyright Date: 2019
• Extent: 1 online resource, illustrations
• Subjects: 005.74; Client/server computing; SQL (Computer program language); Electronic books; Electronic books
• Languages: English
• ISBNs: 9781484250891; 1484250893
• Related ISBNs: 9781484250884
• Notes: Note: Online resource; title from PDF title page (SpringerLink, viewed October 25, 2019).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.