Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Calling external REST endpoints from Azure SQL Database | Azure Friday

Microsoft Azure
337K subscribers
<__slot-el>
<__slot-el>
11K views 2 years ago #Azure #Microsoft #AzureFriday
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  …...more
...more
Calling external REST endpoints from Azure SQL Database | Azure Friday
229Likes
11,478Views
2023Jan 23
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

Follow along using the transcript.

Microsoft Azure

337K subscribers