Published by Microsoft Press (May 17, 2023) © 2023
Randolph West | William Assaf | Elizabeth Noble | Meagan Longoria | Joseph D'Antoni | Louis DavidsonConquer SQL Server 2022 and Azure SQL administration from the inside out!
Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery.
- Identify low-hanging fruit and practical, easy wins for improving SQL Server administration
- Get started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data Studio
- Upgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux
- Design and implement modern on-premises database infrastructure, including Kubernetes
- Leverage data virtualization of third-party or non-relational data sources
- Monitor SQL instances for corruption, index activity, fragmentation, and extended events
- Automate maintenance plans, database mail, jobs, alerts, proxies, and event forwarding
- Protect data through encryption, privacy, and auditing
- Provision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed Instance
- Understand and enable new Intelligent Query Processing features to increase query concurrency
- Prepare a best-practice runbook for disaster recovery
- Use SQL Server 2022 features to span infrastructure across hybrid environments
Part I: Introduction
Chapter 1 Get started with SQL Server tools
Chapter 2 Introduction to database server components
Chapter 3 Design and implement an on-premises database infrastructure
Part II: Deployment
Chapter 4 Install and configure SQL Server instances and features
Chapter 5 Install and configure SQL Server on Linux
Chapter 6 Provision and configure SQL Server databases
Chapter 7 Understand table features
Part III: SQL Server management
Chapter 8 Maintain and monitor SQL Server
Chapter 9 Automate SQL Server administration
Chapter 10 Develop, deploy, and manage data recovery
Chapter 11 Implement high availability and disaster recovery
Part IV: Security
Chapter 12 Administer instance and database security and permissions
Chapter 13 Protect data through classification, encryption, and auditing
Part V: Performance
Chapter 14 Performance tune SQL Server
Chapter 15 Understand and design indexes
Part VI: Cloud
Chapter 16 Design and implement hybrid and Azure database infrastructure
Chapter 17 Provision Azure SQL Database
Chapter 18 Provision Azure SQL Managed Instance
Chapter 19 Migrate to SQL Server solutions in Azure