Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL DB to call any HTTP REST API securely: call an Azure Function, send a message to Event Hub, execute a DAX query in Power BI, enrich data with Cognitive Services, etc.
Chapters:
00:00 – Introduction
02:15 – Background discussion
06:21 – Demo 1: Calling an Azure Function
10:02 – Demo 2: Query a GraphQL service
12:05 – Demo 3: Update a page in real time with SignalR
15:05 – Demo 4: Power BI executeQueries
17:20 – Demo 5: Event Hub
19:05 – Wrap-up
19:41 – Bonus demo: Cognitive Services
Recommended resources:
■ sp_invoke_external_rest_endpoint (Transact-SQL) (Preview) – https://aka.ms/azfr/739/01
■ Azure-Samples/azure-sql-db-invoke-external-rest-endpoints – https://aka.ms/azfr/739/02
■ Azure SQL Database – https://aka.ms/azfr/739/03
■ Create a Pay-as-You-Go account (Azure) – https://aka.ms/azfr/739/payg
■ Create a free account (Azure) – https://aka.ms/azfr/739/free
Connect with us:
■ Scott Hanselman | @SHanselman – https://twitter.com/SHanselman
■ Davide Mauri | @MauriDB – https://twitter.com/MauriDB
■ Azure Friday | @AzureFriday – https://twitter.com/AzureFriday
■ Azure | @Azure – https://twitter.com/Azure
#Microsoft #Azure #AzureFriday
