Modernizing Applications with SQL Server 2022 and Azure SQL Innovations

Modernizing Applications with SQL Server 2022 and Azure SQL Innovations

Microsoft Developer via YouTube Direct link

Customer feedback; Lenovo

35 of 42

35 of 42

Customer feedback; Lenovo

Class Central Classrooms beta

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.