Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Modernizing Applications with SQL Server 2022 and Azure SQL Innovations

Microsoft via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Effort

51 minutes
Sessions

Self-Paced
Level

Intermediate

Found in

This course surveys new SQL Server 2022 and Azure SQL capabilities for security, performance, high availability, hybrid analytics, application development, and data governance. Demonstrations cover intelligent query processing, Azure Synapse Link, Azure SQL integrations, ledger, and Microsoft Purview dynamic lineage.

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.