Azure Serverless Computing Cookbook - Second Edition

Getting ready

This recipe requires us to create the Azure Functions (with the V1 runtime) and the SQL Database in the same resource group. If you haven't created these, create them and come back to this recipe to continue. Here are the steps that we will be performing in this recipe:

1. First, we will create a function app using Visual Studio 2017 with V1 runtime.
2. Then, we will create a Logical SQL Server and a SQL database.
3. Then, we will enable Managed Service Identity from the portal.
4. Afterwards, we will retrieve Managed Service Identity information using the Azure CLI.
5. Then, we will allow SQL Server access to the new Managed Service Identity.
6. Finally, we will execute the HTTP trigger and testing.