Calling external REST endpoints from Azure SQL Database

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.

Table of Contents

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

Read more here: Source link