Pro SQL Server 2022 Administration
Apress (Verlag)
978-1-4842-8863-4 (ISBN)
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.
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
Who This Book Is For
SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features, such as integration with Azure, Query Store, Extended Events, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.
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.
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 & 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 & Managing a Hybrid Environment.- 22. Query Store.- 23. Automating Maintenance Routines.- 24. Policy-Based Management.- 25. Resource Governor.
Erscheinungsdatum | 01.12.2022 |
---|---|
Zusatzinfo | 346 Illustrations, black and white; XXIII, 987 p. 346 illus. |
Verlagsort | Berkley |
Sprache | englisch |
Maße | 178 x 254 mm |
Themenwelt | Informatik ► Datenbanken ► SQL Server |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Schlagworte | Always Encrypted Encryption Feature • AlwaysOn Availability Groups • Azure Arc • Azure Purview • Backup and Restore • Distributed Replay • Extended Events • High Availability and Disaster Recovery • Hybrid Buffer Pool • Log Shipping • Managed Instance • Policy-based Management • PowerShell • Professional SQL Server Administration • Query Store • Secure Enclaves • SQL Server Ledger • SQL Server on Linux • Static Data Masking |
ISBN-10 | 1-4842-8863-7 / 1484288637 |
ISBN-13 | 978-1-4842-8863-4 / 9781484288634 |
Zustand | Neuware |
Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
Haben Sie eine Frage zum Produkt? |
aus dem Bereich