Press "Enter" to skip to content

Local Vector Search in SQL Server 2025

Andy Yun gives vector search a try:

With the announcement of SQL Server 2025 Public Preview, hopefully you are interested in test driving Vector Search.

Microsoft has already posted demo code, but it’s only for OpenAI on Azure. But many of us are wondering about running things locally. So I thought I’d share a step-by-step of getting Ollama setup and running locally on my laptop. End-to-end, these instructions should take less than 30 minutes to complete.

Andy’s process involves downloading and running an embedding model to generate the vectors, creating an external model pointing to Ollama, and using it to generate embeddings.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.