Azure functions are a powerful, serverless way to automate tasks. They are an ideal way to handle small bits of functionality without having to worry about setting up any infrastructure.

In this short session we will set up an Azure Function using PowerShell and Visual Studio Code. This function will respond to HTTP requests, run a query against an Azure SQL DB, and return the results as JSON. From this template you will be able to expand your own functions to run any query against your Azure SQL DB and collect the results easily!

Presented by Neil Holmes at SQLBits 2020