Calling external REST endpoints from Azure SQL Database

Azure Friday

Jan 23 2023 • 0 seconds

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

You Might Like

Darknet Diaries
Darknet Diaries
Jack Rhysider
Marketplace Tech
Marketplace Tech
Marketplace
Hard Fork
Hard Fork
The New York Times
WSJ’s The Future of Everything
WSJ’s The Future of Everything
The Wall Street Journal
Acquired
Acquired
Ben Gilbert and David Rosenthal
Rich On Tech
Rich On Tech
Rich DeMuro
TechStuff
TechStuff
iHeartPodcasts
Fortnite Emotes
Fortnite Emotes
Lawrence Hopkinson
The Vergecast
The Vergecast
The Verge
Waveform: The MKBHD Podcast
Waveform: The MKBHD Podcast
Vox Media Podcast Network