Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

development - Azure SQL Devs’ Corner

Private Preview for External REST Endpoint Invocation with Azure SQL Managed Instance

April 22, 2024 Apr 22, 2024 04/22/24
Brian Spendolini
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 ...

Vanna.ai and Azure SQL Database

April 3, 2024 Apr 3, 2024 04/3/24
Brian Spendolini
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/...

Azure SQL Trigger Binding for Azure Functions goes GA

March 14, 2024 Mar 14, 2024 03/14/24
Brian Spendolini
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, ...

NL2SQL with LangChain and Azure SQL Database

February 19, 2024 Feb 19, 2024 02/19/24
Brian Spendolini
(image) 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 ...

Using AI for Content Moderation with Azure SQL Database

February 12, 2024 Feb 12, 2024 02/12/24
Brian Spendolini
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 ...

REST Endpoint Invocation is now Generally Available

August 28, 2023 Aug 28, 2023 08/28/23
Brian Spendolini
(image) On behalf of the Engineering and Product Management teams, we are happy to announce that External REST Endpoint Invocation is now GA!   What is External REST Endpoint Invocation? External REST Endpoint Invocation makes it possible for developers to call REST/GraphQL endpoints from other Azure Services from right in the ...

Change Tracking in Azure SQL Database

May 1, 2023 May 1, 2023 05/1/23
Brian Spendolini
The Azure SQL Database has two main ways to track changes with data (rows/DML) as well as table changes. One of those methods is Change Tracking with the other being Change Data Capture. Today’s post will be going into depth on Change Tracking. Change Tracking and Change Data Capture So, what’s the difference between the two? Change Data...

Connecting the Dots of Azure SQL CICD Part 2: Local Development

November 7, 2022 Nov 7, 2022 11/7/22
Brian Spendolini
Join us for part two of our Azure SQL database change management (CICD) series. This post covers local development environments with Visual Studio Code. Prerequisites Check For Database Projects to deploy correctly, we need to have the .NET Core SDK installed. You can get it here with a direct link for windows x64 here. You can also ...