Azure SQL Devs’ Corner

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

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

Vector Similarity Search with Azure SQL database and OpenAI

June 4, 2023 Jun 4, 2023 06/4/23
Davide Mauri
Vector databases are gaining quite a lot of interest lately. Using text embeddings and vector operations makes extremely easy to find similar “things”. Things can be articles, photos, products...everything. As one can easily imagine, this ability is great to easily implement suggestions in applications. From providing suggestions on ...