SQL Server Management Enabled by Azure Arc
34mAdvanced2024-05-21
Authors

Ben Weissman
Course details
Hybrid Computing is becoming the standard for many, if not most, organizations. This course provides guidance on developing the skills needed to manage and operate SQL server, one of the most widely used RDBMS, in a hybrid manner. The course provides a crucial puzzle piece in the context of SQL Server and the extension (Azure Arc), which has now matured enough that it is enterprise-ready and widely and being adopted by customers worldwide. Instructor Ben Weissman begins with a short intro to hybrid computing and Azure Arc, Microsoft’s solution for it. From there, he elaborates on the general idea of Azure Arc-enabled SQL Server and how to deploy it. The course concludes by exploring the added benefits and features provided for monitoring, security, authentication, and governance.
Skills covered
SQL ServerDatabase AdministrationCloud AdministrationDatabase ManagementAzureCloud PlatformsCloud ComputingMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Microsoft SQL Server enabled by Azure Arc
- 02 - Demo environment and prerequisites
1. Microsoft SQL Server Enabled by Azure Arc - The Basics
- 03 - What is Azure Arc
- 04 - What is a SQL Server enabled by Azure Arc
- 05 - How to enable a SQL Server by Azure Arc
2. Microsoft SQL Server Enabled by Azure Arc - Features
- 06 - Telemetry through Azure Arc-enabled servers and performance dashboards
- 07 - Basic instance settings and databases
- 08 - Entra ID authentication and Purview
- 09 - Patching
- 10 - Best practice assessments
- 11 - Backup and restore
- 12 - Availability groups
- 13 - Extended security updates and Defender for Cloud
Conclusion
- 14 - Next steps