The following article is interesting : using sql server (azure sql to be precise) as a store for vectors/embeddings built with openAI and use cosine distance to compute one kind of similarity :
https://github.com/Azure-Samples/azure-sql-db-openai
On another database planet, postgresql fans have quickly built a pgvector extension to benefit of special vector datatype and specials operator (<#>, @>,...)for distance calculation and some aggregates on t: https://github.com/pgvector/pgvector
I was wondering if C# and CLR could not help for building similar datatypes and operators in sql servers, waiting for a performant native sql server vector datatype...