Welcome to an exciting, new workshop where we blend the power of AI with the versatility of GraphQL and SQL databases in Microsoft Fabric. This guide will walk you through creating a set of GraphQL RAG (Retrieval-Augmented Generation) application APIs, leveraging relational data and Azure OpenAI. What You’ll Learn You’ll dive into querying and ma...

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: To execute sp_configure to change a configurat...

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 nativ...

Vanna.ai and Microsoft SQL Vanna.ai, in partnership with Azure SQL Database Product Management, bring you a collaboration for using Vanna's natural language to SQL (NL2SQL) agent with the Azure SQL Database. How does Vanna.ai work? First, Vanna is an open-source Python RAG (Retrieval-Augmented Generation) framework for SQL generation/natural lan...

Azure SQL Database Engineering and Product Management would like to announce that Azure SQL Trigger Binding for Azure Functions is now generally available (GA). Catching Up As a quick refresher, the Azure SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or...

LangChain is an open-source framework for creating applications that use and are powered by language models (LLM/MLM/SML). In this post, basic LangChain components (toolkits, chains, agents) will be used to create a natural language to SQL prompt that will allow interactions with an Azure SQL Database; just ask the database what you want as if ...

In my previous posts, I have covered using Azure OpenAI services with Azure SQL Database via REST endpoints. This post with further explore that pathway by creating stored procedures you can use to encapsulate the REST calls and combine them with custom business logic for AI content moderation with Azure SQL Database. A Quick Introduction The ser...

As December approaches, it's time for the winter 2023 update for External REST Endpoint Invocation. We have added four new Azure Service Endpoints: Bing Search, Azure Key Vault, Azure Communication Services, and Azure AI Search. Let's look at a few examples of using these new endpoints. Bing Search Endpoints Bing Seach has many useful API endpoin...

Following on the series of OpenAI posts I have done recently, here is a quick how-to on using DALL-E with External REST endpoint invocation in the Azure SQL Database. Using the OpenAI service in Azure, we can use the image generation REST endpoints to create new and wonderful images such as, if you remember, the cat in the data center. So ho...

Everyone loves OpenAI these days as it can do some amazing things. Here, I asked it to create a picture of a cat in a data center: (Go ahead and click the image to see a bigger version of this nightmare fuel) Incredible!!!! But how can we use OpenAI in real world applications and scenarios with Azure SQL Database? Using OpenAI with the Az...