Azure SQL Devs’ Corner

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

Azure SQL - Azure SQL Devs’ Corner

Vector Search Optimization via KMeans, Voronoi Cells and Inverted File Index (aka “Cell-Probing”)

April 18, 2024 Apr 18, 2024 04/18/24
Davide Mauri
In a previous article I already mentioned how vectors can be easily stored in Azure SQL already and how to calculate dot product and cosine distance using just T-SQL. In this article I will show how to improve the performance in vector search by using a technique that has many name but is really based on something very well know already: ...

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

Introducing Regular Expression (Regex) Support in Azure SQL DB

March 22, 2024 Mar 22, 2024 03/22/24
Abhiman Tiwari
We are pleased to announce the private preview of regular expressions (regex) support in Azure SQL Database. Regex is a powerful tool that allows you to search, manipulate, and validate text data in flexible ways. With regex support, you can enhance your SQL queries with pattern matching, extraction, replacement, and more. You can also combine...

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

Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale

February 14, 2024 Feb 14, 2024 02/14/24
Asad Khan
Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale AI and cloud-native applications built for the future need a highly scalable, cloud native database with excellent price-performance. For applications operating on mission-critical relational data, Azure SQL Database Hyperscale provides the performance, reliability ...

Build your APIs with DAB using Containers – Part 2

February 13, 2024 Feb 13, 2024 02/13/24
Carlos Robles
Are you tired of spending countless hours building APIs from scratch? With Data API builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL...

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

Chat with your data in Azure SQL Database

February 6, 2024 Feb 6, 2024 02/6/24
Muazma Zahid
Welcome to the exploration of how to chat with your data in Azure SQL Database. Being able to interact with your data more intuitively and conversationally can significantly enhance your data analysis and decision-making processes. This blog post will guide you through the process of setting up a chat interface for your Azure SQL Database, ...