
Sign up to save your podcasts
Or


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) Azure-Samples/azure-sql-db-invoke-external-rest-endpoints Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Davide Mauri | Twitter: @MauriDB Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure
By Scott Hanselman4.7
3838 ratings
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) Azure-Samples/azure-sql-db-invoke-external-rest-endpoints Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Davide Mauri | Twitter: @MauriDB Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

16,740 Listeners

271 Listeners

383 Listeners

289 Listeners

3,704 Listeners

626 Listeners

302 Listeners

987 Listeners

203 Listeners

245 Listeners

13 Listeners

9,904 Listeners

24 Listeners

608 Listeners

64 Listeners