Embeddings and vectors are becoming common terms not only for engineers involved in AI-related activities but also for those using databases. Some common points of discussion that frequently arise among users familiar with vectors and embeddings include: Let’s tackle each one of these questions one by one starting from the very...
RAG - Retrieval Augmented Generation - is by far one of the most common patterns today as it enables the creation of chatbots that can chat on your own data, as I described in my previous "Retrieval Augmented Generation with Azure SQL" blog post. As soon as you start to use it excitement grows, as it provides a sort of a magical experience. Experie...
Chatbots are the hot topic lately, and now you can create them easily by downloading solutions like OpenWebUI, connect it to Ollama or any OpenAI compatible API, choose your favorite language model, and then run it. It just takes a few minutes and it's done. But building chatbots is not enough, you most likely want to build a chatbot on your own...
Latest update - 06 November 2024 Vector Support is now available as Public Preview! Read the announcement here: Public Preview of Native Vector Support in Azure SQL Database! Access to full documentation here: Vector functions. The new data type Not even 6 months ago we started the Early Adopter Preview vector data support in Azure SQL, and...
Retrieval Augmented Generation, or RAG, is one of the hottest topics at the moment as it opens up the possibility of interacting with data using natural language, which is a long-time dream finally coming true. It is very likely that a lot of your data is already stored or will be stored in Azure SQL, so a common request is to have an exampl...
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: KMeans Clu...
Latest update - 06 November 2024 Vector Support is now available as Public Preview! Read the announcement here: Public Preview of Native Vector Support in Azure SQL Database! Access to full documentation here: Vector functions. Vectors and Embeddings Vector databases are gaining quite a lot of interest lately. Using text embeddings and vector op...
