Episode
Use AI and REST with Azure SQL Database | Data Exposed
with Anna Hoffman, Brian Spendolini
The ability to simply call REST endpoints with a single line of code opens up the world of Azure Services to an Azure SQL Database. A single stored procedure call can access event hubs, blob storage, functions, and even AI. In this episode, Anna Hoffman and Brian Spendolini discuss how the newly generally available feature, External REST Endpoint Invocation can be used to call Azure services, popular use cases, and how to call OpenAI right within the database to generate answers using your data.
Chapters
- 00:16 - Introductions
- 00:49 - What is the REST Endpoints feature?
- 01:44 - How can you use them?
- 02:41 - How do you use them in Code?
- 05:37 - Security!
- 08:45 - Demonstrations
- 16:25 - Tips and Tricks
- 17:07 - Closing
Recommended resources
- Azure SQL DB: Invoke external REST endpoints | GitHub
- System stored procedures (Transact-SQL) | Microsoft Learn
- Azure SQL Devs' Corner | Microsoft DevBlogs
Related episodes
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
The ability to simply call REST endpoints with a single line of code opens up the world of Azure Services to an Azure SQL Database. A single stored procedure call can access event hubs, blob storage, functions, and even AI. In this episode, Anna Hoffman and Brian Spendolini discuss how the newly generally available feature, External REST Endpoint Invocation can be used to call Azure services, popular use cases, and how to call OpenAI right within the database to generate answers using your data.
Chapters
- 00:16 - Introductions
- 00:49 - What is the REST Endpoints feature?
- 01:44 - How can you use them?
- 02:41 - How do you use them in Code?
- 05:37 - Security!
- 08:45 - Demonstrations
- 16:25 - Tips and Tricks
- 17:07 - Closing
Recommended resources
- Azure SQL DB: Invoke external REST endpoints | GitHub
- System stored procedures (Transact-SQL) | Microsoft Learn
- Azure SQL Devs' Corner | Microsoft DevBlogs
Related episodes
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Have feedback? Submit an issue here.