SQL Server and Windows Server Better together on Azure
summary
Demonstrations show Windows Server Azure Edition hot patching that applies two real updates in seconds with no reboot versus minutes and downtime for traditional updates, and Azure Update Manager that installs cumulative SQL updates from the portal at scale. Azure Arc inventory surfaces 43 servers and 118 SQL instances with edition, cores and compat level and runs a migration assessment that flags cross-database queries as incompatible with Azure SQL DB. AMD on Azure reports up to 15% better perf per dollar on V5 and a 2.7M TPC result vs ~2M on Intel; Defender for Cloud flags lateral attack paths from VM exploit to database.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:51Customer feedback
- 2:54Patching on Azure
- 6:47SQL updates via Update Manager
- 8:55Azure Arc for hybrid
- 13:30Migration assessment with Arc
- 16:00Q&A
- 22:01AMD and SQL performance
- 31:59Security with Defender
- 34:05Future of Windows & SQL
- 36:51AI for SQL management
- 44:39SSMS updates
- 46:23SQL Server 2014 end of support
- 47:50Summary
related talks
49mOperational insights in your hybrid-cloud multi-cloud SQL inventory outside azure using Arc SQL Serv
01h 05mHow to Get the Best Out of Your SQL Server on Azure
01h 01mSQL Server in the Cloud - The available options
22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
01h 11mConnect your servers to the Cloud using Azure Hybrid Management
48mAzure Stack HCI and Microsoft Hybrid Data Services
44mSQL Managed Instance: Fully managed SQL Server in Azure
22mKeynote