SQL Triggers for Azure Functions

We dig into the preview bits of SQL Triggers that is now available for Azure Functions. Get a feed of data operations as they happen so that changes can be processed downstream into other systems.

▶️ Azure SQL bindings for Azure Functions docs
https://learn.microsoft.com/en-gb/azu...

▶️ mssql-cli: A command-line query tool for SQL Server
https://learn.microsoft.com/en-us/sql...

▶️ SQL Extensions for Azure Functions NuGet Package
https://www.nuget.org/packages/Micros...



00:00 - Intro
00:55 - Enabling change tracking in SQL
02:42 - Creating a new Azure Function app
03:23 - Adding the SQL extensions NuGet package
04:00 - Creating a function for the trigger
04:55 - Binding the trigger parameter
06:09 - Creating a model for the data
07:00 - Writing the data operations change feed to the log
09:37 - Adding the database connection string
10:07 - Running the function
11:57 - SQL Trigger configuration documentation
12:23 - Enable runtime-driven scaling in Azure
12:49 - Outro

#azure #serverless #sql #azurefunctions