Feature request

[EnablSiteAdmin]

Hi Pamela,

I really enjoy your talks and explanations about RAG in real-world scenarios!

I was wondering, since SQL Server now has vector support in preview, could this setup be easily adapted to work with it?

Description

What is wrong or what would you like to see improved?

Azure sql support

Environment

Describe your OS and dev environment (Codespaces, Dev Container, etc):

Deployed to Azure and Dev container for local testing

[pamelafox]

I would probably do that as a separate repo since there's so much Postgres-specific setup in this one, but generally, yes, you should be able to do RAG on Azure SQL. You'd need to change the infrastructure, the SQLAlchemy connection setup, and the vector search functions.

These two repos would be good sources of inspiration, since they both have RAG-like flows:
* https://github.com/Azure-Samples/azure-sql-db-session-recommender-v2
* https://github.com/Azure-Samples/azure-sql-langchain

I am new to Azure SQL myself, so I'm actually going to be working through those two repos myself to learn what's different across the databases.