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.
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
📌 Let's connect:
Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
✔️ Additional Resources:
https://github.com/Azure-Samples/azure-sql-db-invoke-external-rest-endpoints
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql?view=azuresqldb-current&tabs=request-headers
https://devblogs.microsoft.com/azure-sql/
🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #Security #LearnSQL
