Azure SQL October 2021 New Updates | Data Exposed Live

From the creator

Get the latest September news and updates in the world of data with Alexandra Ciortea, Andreas Wolter, Anna Hoffman, Cheryl Adams, Daniel Norman (Prisma), Pooja Kamath, Marisa Brasile, and Neetu Singh on Data Exposed Live. 0:00 Stream begins 0:51 Show begins 2:11 Product updates 4:44 Closer look... New Server Roles for Azure SQL Database 14:25 Product update - Scalar UDF inlining for Azure SQL PaaS 25:42 Closer look... DMA 5.5 and SSMA 8.22 38:34 Data Exposed 39:37 Blogs 45:46 Prisma & Azure SQL 54:32 Blogs 55:14 SQL in a Minute 1:00:15 Upcoming Events 1:01:42 Learn Module of the Month 1:02:12 Anna's Pick of the Month ✔️ Resources: Azure SQL News and Data Exposed Update - September 2021 Blog: https://aka.ms/NewsUpdate SQL Server 2019 Announcement: Introducing Scalar UDF Inlining: https://techcommunity.microsoft.com/t5/azure-sql/introducing-scalar-udf-inlining/ba-p/386270 Public documentation: Scalar UDF Inlining in Microsoft SQL Server: https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver15&viewFallbackFrom=sql-server-2017 The underlying techniques that describe how this feature works are described in a research publication titled " Froid: Optimization of Imperative programs in a Relational Database ": http://www.vldb.org/pvldb/vol11/p432-ramachandra.pdf Data Exposed Talks: SQL Server 2019 Improves Scalar UDF Performance | Data Exposed: https://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-2019-Improve

Published 2021-10-06 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.