Calling external REST endpoints from Azure SQL Database | Azure Friday

Video Description

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