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

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