{"id":3108,"date":"2024-04-22T08:12:33","date_gmt":"2024-04-22T15:12:33","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=3108"},"modified":"2024-04-24T17:12:01","modified_gmt":"2024-04-25T00:12:01","slug":"private-preview-for-external-rest-endpoint-invocation-with-azure-sql-managed-instance","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/private-preview-for-external-rest-endpoint-invocation-with-azure-sql-managed-instance\/","title":{"rendered":"Private Preview for External REST Endpoint Invocation with Azure SQL Managed Instance"},"content":{"rendered":"<p>We have an exciting opportunity for customers and partners to use External REST Endpoint Invocation with Azure SQL Managed Instance in a private preview.<\/p>\n<h2 id=\"what-is-azure-sql-managed-instance\">What is Azure SQL Managed Instance?<\/h2>\n<p>Azure SQL Managed Instance is a PaaS service that has near 100% compatibility with the latest Enterprise Edition SQL Server database engine, providing a native\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/virtual-network\/virtual-networks-overview\" data-linktype=\"absolute-path\">virtual network (VNet)<\/a>\u00a0implementation that addresses common security concerns, and a\u00a0<a href=\"https:\/\/azure.microsoft.com\/pricing\/details\/sql-database\/\" data-linktype=\"external\">business model<\/a>\u00a0favorable to existing SQL Server customers. SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance provides all PaaS capabilities (automatic patching and version updates,\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/automated-backups-overview?view=azuresql\" data-linktype=\"relative-path\">automated backups<\/a>,\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/high-availability-sla?view=azuresql\" data-linktype=\"relative-path\">high availability<\/a>) to drastically reduce management overhead and the total cost of ownership (TCO).<\/p>\n<p>SQL Managed Instance is designed for customers looking to migrate a large number of apps from an on-premises or IaaS, self-built, or ISV provided environment to a fully managed PaaS cloud environment, with as low a migration effort as possible. Using the fully automated\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/dms\/tutorial-sql-server-to-managed-instance#create-an-azure-database-migration-service-instance\" data-linktype=\"absolute-path\">Azure Data Migration Service<\/a>, or the\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/managed-instance-link-feature-overview?view=azuresql\" data-linktype=\"relative-path\">Managed Instance link<\/a>, customers can lift and shift their existing SQL Server database or SQL Server instance to Azure SQL Managed Instance, which offers compatibility with SQL Server and complete isolation of customer instances with native VNet support.<\/p>\n<p>If you&#8217;re new to Azure SQL Managed Instance, check out the\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/shows\/azure-sql-for-beginners\/azure-sql-managed-instance-overview-6-of-61\" target=\"_blank\" rel=\"noopener\"><em>Azure SQL Managed Instance<\/em>\u00a0video<\/a> from our in-depth\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/shows\/Azure-SQL-for-Beginners\/?WT.mc_id=azuresql4beg_azuresql-ch9-niner\" target=\"_blank\" rel=\"noopener\" data-linktype=\"absolute-path\">Azure SQL video series.<\/a><\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/shows\/azure-sql-for-beginners\/azure-sql-managed-instance-overview-6-of-61\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"wp-image-3110 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/video6_960.jpg\" alt=\"Image video6 960\" width=\"533\" height=\"300\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/video6_960.jpg 960w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/video6_960-300x169.jpg 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/video6_960-768x432.jpg 768w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<h2>What is\u00a0External REST Endpoint Invocation?<\/h2>\n<p><a href=\"https:\/\/learn.microsoft.com\/sql\/relational-databases\/system-stored-procedures\/sp-invoke-external-rest-endpoint-transact-sql?view=azuresqldb-current&amp;tabs=request-headers\" target=\"_blank\" rel=\"noopener\">External REST Endpoint Invocation<\/a> makes it possible for developers to call REST\/GraphQL endpoints from <a href=\"https:\/\/learn.microsoft.com\/sql\/relational-databases\/system-stored-procedures\/sp-invoke-external-rest-endpoint-transact-sql?view=azuresqldb-current&amp;tabs=request-headers#allowed-endpoints\" target=\"_blank\" rel=\"noopener\">other Azure Services<\/a> from right in the Azure SQL Database. With a quick call to the system stored procedure <strong>sp_invoke_external_rest_endpoint<\/strong>, you can have data processed via an Azure Function, update a PowerBI dashboard, or even talk to Cognitive Services. In fact, in the most recent update, we enabled access to OpenAI, Azure Blob Storage, Azure Files, Azure Queue Services and Azure Table Services. This feature also supports header and managed identity authentication, so you can get rid of passing pesky passwords.<\/p>\n<p>Use cases for this feature are many and here are a few to get your creative spark going:<\/p>\n<p><strong>Activate workflows<\/strong><\/p>\n<ul>\n<li>Send an email \/ notification using Azure Logic Apps<\/li>\n<\/ul>\n<p><strong>Azure OpenAI Tasks<\/strong><\/p>\n<ul>\n<li>Call Azure OpenAI service endpoints for chat sessions, content safety evaluation, PII detection, and more<\/li>\n<\/ul>\n<p><strong>Data enrichment <\/strong><\/p>\n<ul>\n<li>Determine if a value is an outlier or not using Azure Cognitive services<\/li>\n<li>Perform reverse geocoding using Azure Functions<\/li>\n<li>Call a REST\/GraphQL service to add external information (eg: weather, reviews, etc) to your data<\/li>\n<\/ul>\n<p><strong>Cache invalidation \/ update<\/strong><\/p>\n<ul>\n<li>For cache invalidation or update by calling an Azure Function<\/li>\n<\/ul>\n<p><strong>Start complex processing<\/strong><\/p>\n<ul>\n<li>Call a Durable Function to kick of some complex process<\/li>\n<\/ul>\n<p><strong>Update websites<\/strong><\/p>\n<ul>\n<li>Broadcast a SignalR message<\/li>\n<\/ul>\n<p><strong>Integrate with event-based architectures<\/strong><\/p>\n<ul>\n<li>Send data to Event Hubs for further integration options<\/li>\n<\/ul>\n<p><strong>Create a data stream <\/strong><\/p>\n<ul>\n<li>Send data to Stream Analytics for further investigation\/fraud detection<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>Private Preview Sign-up Form<\/h2>\n<p>We are currently accepting customers and partners who would like to participate in the private preview and try out the External REST Endpoint Invocation in Azure SQL Managed Instance. If interested, please fill out this <a href=\"https:\/\/aka.ms\/rest-mi\" target=\"_blank\" rel=\"noopener\">form<\/a>.<\/p>\n<p>Or use this QR Code!<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up.png\"><img decoding=\"async\" class=\"wp-image-3113 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up.png\" alt=\"Image QRCode for External REST Endpoint Invocation in Azure SQL Managed Instance Private Preview Sign up\" width=\"473\" height=\"473\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up.png 1890w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-300x300.png 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-1024x1024.png 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-150x150.png 150w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-768x768.png 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-1536x1536.png 1536w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-24x24.png 24w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-48x48.png 48w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/04\/QRCode-for-External-REST-Endpoint-Invocation-in-Azure-SQL-Managed-Instance-Private-Preview-Sign-up-96x96.png 96w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have an exciting opportunity for customers and partners to use External REST Endpoint Invocation with Azure SQL Managed Instance in a private preview. What is Azure SQL Managed Instance? Azure SQL Managed Instance is a PaaS service that has near 100% compatibility with the latest Enterprise Edition SQL Server database engine, providing a native\u00a0virtual [&hellip;]<\/p>\n","protected":false},"author":95874,"featured_media":3115,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,572,576,577],"tags":[510,465,469,30,449,410],"class_list":["post-3108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-managed-instance","category-rest","category-rest-endpoint-invocation","tag-azure-sql-database","tag-azuresql","tag-azuresqldb","tag-developers","tag-development","tag-rest"],"acf":[],"blog_post_summary":"<p>We have an exciting opportunity for customers and partners to use External REST Endpoint Invocation with Azure SQL Managed Instance in a private preview. What is Azure SQL Managed Instance? Azure SQL Managed Instance is a PaaS service that has near 100% compatibility with the latest Enterprise Edition SQL Server database engine, providing a native\u00a0virtual [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/3108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/95874"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=3108"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/3108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/3115"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=3108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=3108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=3108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}