Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit

on YouTube ↗22m

" summary

Azure Arc adds a central control plane for on‑prem and non‑Azure SQL Server instances by running a single PowerShell script or bash installer that deploys an agent that sends metadata and telemetry into the Azure portal. Requirements: valid SQL license with Software Assurance or Dev/Express/pay‑as‑you‑go; minimal telemetry storage costs. Live demos show dashboards, best‑practice assessments, automated patching, Defender alerts, Azure AD auth, Purview policies, portal‑initiated availability‑group failover and a managed point‑in‑time restore using 1–35 day retention.

AI-written summary · about

" chapters (12)

1. 0:00Welcome
2. 2:38Azure Arc for SQL Server
3. 4:46Arc enabled servers setup
4. 7:16Demo: Arc SQL instances
5. 11:08Telemetry for SQL instances
6. 12:13SQL instance management
7. 13:37Azure AD for SQL auth
8. 15:25Security updates
9. 17:56Defender integration
10. 18:38Availability groups
11. 20:00Performance dashboards
12. 21:02Summary

" related talks

• 49mSQL Server and Windows Server Better together on AzureBob Ward, Dilip Ramachandran · SQLBits 2022
• 47mUnleashing the Potential of Hybrid CloudWolfgang Ofner · DevDays Europe 2024
• 52mExploring The Multi-Cloud Paradigm Through Azure ArcJanakiram MSV · AzConf 2020
• 53mAzure Hybrid - Learn about Hybrid Cloud Management with AzureThomas Maurer · Global Azure Austria 2021
• 17mThe Microsoft Intelligent Data Platform andRobert Sonders, Dilip Ramachandran, Stephen McMaster, Kenny Lowe · SQLBits 2022
• 48mAzure Stack HCI and Microsoft Hybrid Data ServicesRobert Sonders, Dilip Ramachandran, Stephen McMaster, Kenny Lowe · SQLBits 2023
• 54mKeynote: SQL Edge to CloudBob Ward, Anna Hoffman, Buck Woody · DEVintersection 2021 Orlando
• 18mData Modernization in a Hybrid WorldRobert Sonders, Stephen McMaster, Kenny Lowe · SQLBits 2022