Completed
Two world records in performance and price/performance
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Modernizing Applications with SQL Server 2022 and Azure SQL Innovations
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction
- 2 Bob Ward, Principal Architect, Azure Data Team, Microsoft
- 3 Announcing SQL Server 2022 public review
- 4 Download link for SQL Server 2022 public review
- 5 Major features of SQL Server 2022
- 6 Two world records in performance and price/performance
- 7 Setting up and maintaining a disaster recovery site
- 8 Solution; Link feature for Azure SQL Managed Instance
- 9 Industry proven database engine; Secure
- 10 Industry proven database engine; Scalable
- 11 Industry proven database engine; Available
- 12 Challenge; Query tuning is expensive and time-consuming
- 13 Solution; Query Store enhancements and the next generation of Intelligent Query Processing (IQP)
- 14 Intelligent Query Processing (IQP) NexGen
- 15 Demo; IQP examples in SQL Server (Parameter sensitive plant optimization)
- 16 Demo; IQP examples in SQL Server (DOP feedback)
- 17 Customer feedback; IT Director for DBA and BI Services
- 18 Announcement; Azure Synapse Link for SQL public review
- 19 Challenge; ETL is expensive, data is out of date, and this impacts operational workloads
- 20 Solution; Azure Synapse Link for SQL
- 21 Demo; How Azure Synapse Link for SQL works
- 22 Chuck Heinzelman, Principal PM Manager, Microsoft
- 23 Customer feedback; Data Architect
- 24 Azure SQL Database
- 25 Challenge; Developers need easy integration with services and support DevOps
- 26 Local development experience
- 27 Azure Functions integration
- 28 JSON enhancements
- 29 HTTPS Endpoints integration
- 30 Drew Skwiers-Koballa, Senior Program Manager, Microsoft
- 31 Demo; New features for developers working with Azure SQL Database
- 32 SP Invoke External Rest Endpoint
- 33 Announcement; Azure SQL Database ledger
- 34 Demo; ice cream company example
- 35 Customer feedback; Lenovo
- 36 Microsoft Purview; data analysis
- 37 Challenge; root cause analysis for issues related to data is difficult
- 38 Solution; Dynamic Lineage for SQL
- 39 Sunetra Virdi, Senior Program Manager, Microsoft
- 40 Dynamic Lineage example
- 41 Related sessions
- 42 Resources
