Azure SQL Devs’ Corner

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

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

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