Cloud, Containers, and Microservices

T08 Further, Faster, with Azure Functions and Azure SQL Integrations

03/21/2023

9:30am - 10:45am

Level: Intermediate

Drew Skwiers-Koballa

Senior Program Manager

Microsoft

Azure SQL and Azure Functions are a powerful combination for building flexible and performant applications. In this session we will discuss and demo several ways to integrate Azure Functions and Azure SQL. By using the sp_invoke_external_rest_endpoint stored procedure in Azure SQL Database, you can call an Azure Function directly from T-SQL. You can also use SQL input/output bindings in Azure Functions to read and write from the database without a bunch of boilerplate code. Finally, the SQL trigger for Azure Functions utilizes lightweight change tracking in SQL to invoke Azure Functions on any data changes, enabling event-driven applications to be created easily. Whether you are improving an existing application or building from scratch, there are new developer tools for you with Azure SQL.