Well now, the explosion of vector databases is overwhelming (yes, not just “whelming”).

I have been playing around with PostgreSQL pg-vector but if you use Microsoft SQL for your main day-to-day stuff, then vector support is coming! It is in preview for Azure SQL databases as well as SQL 2025 (preview).

Okay, if you are not sure what a vector even is (in AI terms) then:

In artificial intelligence (AI), a vector is a mathematical representation of data, such as words, images, or other entities, in a multi-dimensional space. Each vector consists of a list of numbers that capture the essential features or characteristics of the data it represents. This numerical representation allows AI models to process and analyze complex information more effectively.

Vectorizing Words:

To enable AI systems to understand and manipulate human language, words are converted into vectors through a process called word embedding. This process involves mapping each word to a high-dimensional vector space, where words with similar meanings are positioned closer together. For example, the words "king" and "queen" would be represented by vectors that are near each other in this space, reflecting their semantic similarity.

Link to the MS announcement

Hey, subscription to this podcast is FREE if you want to subscribe! I hadn’t realised before it forced you to pay ;) Of course, if you wish to or must pay, then please feel free with a paid subscription or via Patreon

Or just buy a unicorn a coffee here!

Oh, and yes, I have ended up on YouTube (doesn’t everyone eventually?):

https://www.youtube.com/@justfifteenmins but don’t worry, no ugly face to worry about (yet!).

Unicorn University:

https://applied-ai-services.kit.com/020c6040f2