Modernizing Applications with SQL Server 2022 and Azure SQL Innovations

Overview

Explore the latest innovations in SQL Server 2022 and Azure SQL in this comprehensive conference talk from Microsoft Build 2022. Discover new features that enhance security, performance, and high availability in SQL Server 2022, and learn how Azure SQL Database empowers developers to build modern, intelligent applications more efficiently. Gain insights into hybrid scenarios enabled by the integrated data platform, including near real-time intelligence with Azure Synapse Link and improved data governance with Azure Purview. Watch demonstrations of Intelligent Query Processing, Azure Synapse Link for SQL, and new developer features in Azure SQL Database. Learn about the Azure SQL Database ledger and Dynamic Lineage for SQL, which address challenges in data analysis and root cause investigation. Benefit from expert presentations by Microsoft's Principal Architects and Program Managers, and hear customer feedback on these new technologies.

Syllabus

Introduction.
Bob Ward, Principal Architect, Azure Data Team, Microsoft.
Announcing SQL Server 2022 public review.
Download link for SQL Server 2022 public review.
Major features of SQL Server 2022 .
Two world records in performance and price/performance.
Setting up and maintaining a disaster recovery site.
Solution; Link feature for Azure SQL Managed Instance.
Industry proven database engine; Secure.
Industry proven database engine; Scalable.
Industry proven database engine; Available.
Challenge; Query tuning is expensive and time-consuming.
Solution; Query Store enhancements and the next generation of Intelligent Query Processing (IQP).
Intelligent Query Processing (IQP) NexGen.
Demo; IQP examples in SQL Server (Parameter sensitive plant optimization) .
Demo; IQP examples in SQL Server (DOP feedback).
Customer feedback; IT Director for DBA and BI Services.
Announcement; Azure Synapse Link for SQL public review.
Challenge; ETL is expensive, data is out of date, and this impacts operational workloads.
Solution; Azure Synapse Link for SQL .
Demo; How Azure Synapse Link for SQL works.
Chuck Heinzelman, Principal PM Manager, Microsoft.
Customer feedback; Data Architect.
Azure SQL Database.
Challenge; Developers need easy integration with services and support DevOps.
Local development experience.
Azure Functions integration.
JSON enhancements.
HTTPS Endpoints integration.
Drew Skwiers-Koballa, Senior Program Manager, Microsoft.
Demo; New features for developers working with Azure SQL Database.
SP Invoke External Rest Endpoint.
Announcement; Azure SQL Database ledger.
Demo; ice cream company example.
Customer feedback; Lenovo.
Microsoft Purview; data analysis.
Challenge; root cause analysis for issues related to data is difficult.
Solution; Dynamic Lineage for SQL.
Sunetra Virdi, Senior Program Manager, Microsoft.
Dynamic Lineage example.
Related sessions.
Resources.