Play all

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

Description:

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.

Modernizing Applications with SQL Server 2022 and Azure SQL Innovations

Microsoft

Add to list

#Programming #Domain-Specific Languages (DSL) #SQL #Azure SQL #Computer Science #Information Technology #IT Governance #Data Governance #Database Management #Database Security #Software Engineering #Software Architecture #High Availability #Intelligent Query Processing