Calling external REST endpoints from Azure SQL Database | Azure Friday

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 –   / shanselman  
■ Davide Mauri | @MauriDB –   / mauridb  
■ Azure Friday | @AzureFriday –   / azurefriday  
■ Azure | @Azure –   / azure  

#Microsoft #Azure #AzureFriday