Overview
- Provides comprehensive coverage of the 2022 release
- Includes a focus on high availability and disaster recovery
- Covers privacy, security, and auditing features, such as Ledger
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (25 chapters)
-
Installation and Configuration
-
Database Administration
-
Security, Resilience, and Scaling Workloads
Keywords
- Static Data Masking
- Query Store
- Hybrid Buffer Pool
- SQL Server on Linux
- Always Encrypted Encryption Feature
- Secure Enclaves
- Hybrid Buffer Pool
- PowerShell
- Backup and Restore
- High Availability and Disaster Recovery
- AlwaysOn Availability Groups
- Log Shipping
- Extended Events
- Distributed Replay
- Azure Purview
- Policy-Based Management
- Professional SQL Server Administration
- SQL Server Ledger
- Azure Arc
- Managed Instance
About this book
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.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Pro SQL Server 2022 Administration
Book Subtitle: A Guide for the Modern DBA
Authors: Peter A. Carter
DOI: https://doi.org/10.1007/978-1-4842-8864-1
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Peter A. Carter 2023
Softcover ISBN: 978-1-4842-8863-4Published: 29 November 2022
eBook ISBN: 978-1-4842-8864-1Published: 27 November 2022
Edition Number: 3
Number of Pages: XXIII, 987
Number of Illustrations: 346 b/w illustrations
Topics: Microsoft and .NET, Database Management