Episode

Calling external REST endpoints from Azure SQL Database

with Scott Hanselman, Davide Mauri

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

Connect

Azure
Azure SQL Database