Carter P.A. - Pro SQL Server 2022 Administrati
|
||||||||||||||||||||||||||||||||||||||||||
|
Home » Books and magazines » Computer literature » Database management system |
| DL-List and Torrent activity | |
| Size: 52 MB | Registered: 1 year 8 months | Completed: 2 times | |
|
Seeder not seen: 5 months 27 days |
|
|
|
| Author | Message | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Microsoft SQL Server ® Gender: Longevity: 9 years Posts: 677
|
Pro SQL Server 2022 Administration
Год издания: 2023 Автор: Carter P.A. Издательство: Apress ISBN: 978-1-4842-8864-1 Язык: Английский Формат: PDF Качество: Издательский макет или текст (eBook) Интерактивное оглавление: Да Количество страниц: 990 Описание: 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 history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You’ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL. 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 is secure and highly available. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server's hybrid cloud functionality. This book teaches you how to make the most of new SQL Server 2022 functionality, including integration for hybrid cloud scenarios. The book promotes best-practice installation, shows how to configure for scalability and high availability, and demonstrates the gamut of database-level maintenance tasks, such as index maintenance, database consistency checks, and table optimizations. What You Will Learn: - Integrate SQL Server with Azure for hybrid cloud scenarios - Audit changes and prevent malicious data changes with SQL Server’s Ledger - Secure and encrypt data to protect against embarrassing data breaches - Ensure 24 x 7 x 365 access through high availability and disaster recovery features in today’s hybrid world - Use Azure tooling, including Arc, to gain insight into and manage your SQL Server enterprise - Install and configure SQL Server on Windows, Linux, and in containers - Perform routine maintenance tasks, such as backups and database consistency checks - Optimize performance and undertake troubleshooting in the Database Engine ОглавлениеAbout the Author xixAbout the Technical Reviewer xxi Acknowledgments xxiii Part I: Installation and Configuration 1 Chapter 1: Planning the Deployment 3 Chapter 2: GUI Installation 31 Chapter 3: Server Core Installation 75 Chapter 4: Installation on Heterogeneous Operating Systems 105 Chapter 5: Configuring the Instance 135 Part II: Database Administration 173 Chapter 6: Database Configuration 175 Chapter 7: Table Optimizations 219 Chapter 8: Indexes and Statistics 263 Chapter 9: Database Consistency 315 Part III: Security, Resilience, and Scaling Workloads 351 Chapter 10: SQL Server Security Model 353 Chapter 11: Auditing and Ledger 381 Chapter 12: Encryption 415 Chapter 13: Backups and Restores 453 Chapter 14: High Availability and Disaster Recovery Concepts 505 Chapter 15: Implementing AlwaysOn Availability Groups 533 Chapter 16: Implementing Log Shipping 587 Chapter 17: Scaling Workloads 625 Part IV: Performance and Maintenance 677 Chapter 18: SQL Server Metadata 679 Chapter 19: Locking and Blocking 715 Chapter 20: Extended Events 755 Chapter 21: Monitoring and Managing a Hybrid Environment 795 Chapter 22: Query Store 823 Chapter 23: Automating Maintenance Routines 847 Chapter 24: Policy-Based Management 905 Chapter 25: Resource Governor 935 Index 965
 |
|||||||||||||||||||
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon} ![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon} |
||||||||||||||||||||
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
|
|
Home » Books and magazines » Computer literature » Database management system |
Current time is: 24-Feb 17:20
All times are UTC + 2
You cannot post new topics in this forum
You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum |