Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
summary
Azure Arc enables Azure features for on‑prem and multi‑cloud SQL by running one PowerShell script that installs an agent, sends metadata to a chosen Azure region, and registers instances so the portal shows CPU, memory, patch level and SQL‑specific telemetry. It requires appropriate licensing or pay‑as‑you‑go (Software Assurance for no extra charge), exposes Defender, AAD auth, Purview controls, patching, assessments across ~30 Arc offerings, portal AG failover, and the ability to restore to any point in time within a 1–35 day retention window.
AI-written summary · about
chapters (12)
- 0:00Welcome
- 2:38Azure Arc for SQL Server
- 4:46Arc enabled servers setup
- 7:16Demo: Arc SQL instances
- 11:08Telemetry for SQL instances
- 12:13SQL instance management
- 13:37Azure AD for SQL auth
- 15:25Security updates
- 17:56Defender integration
- 18:38Availability groups
- 20:00Performance dashboards
- 21:02Summary
related talks
22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
49mOperational insights in your hybrid-cloud multi-cloud SQL inventory outside azure using Arc SQL Serv
46mBusiness continuity of on-prem SQL Servers using Azure services through Arc
50mArc, Arc and Arc: De-mystifying Azure Arc for Data
49mDell and Azure Arc-enabled data services - SQL MI Business Critical
53mAzure SQL Anywhere: An Introduction to Azure Arc-enabled Data Services
40mAzure Arc enabled data Services - Run Azure SQL MI & PostgreSQL
50mAdvancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance