February 12th, 2025

External REST Endpoint Invocation in Azure SQL Managed Instance is now in Public Preview

Brian Spendolini
Senior Product Manager, Azure SQL Database

External REST Endpoint Invocation is available in Azure SQL Managed Instance with the Always-up-to-date update policy configured. Call Azure Services such as functions, Azure OpenAI, event hubs, content safety and more!

To enable this feature in Azure SQL Managed Instance, run the following code:

sp_configure 'external rest endpoint enabled', 1;
RECONFIGURE WITH OVERRIDE;

To execute sp_configure to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.

Examples and sample code can be found here and a workshop here. You can also find all about the latest advancements with SQL and AI here.

Category
Azure SQL

Author

Brian Spendolini
Senior Product Manager, Azure SQL Database

0 comments