SQL Server 2025 introduces native vector support, enabling AI-powered semantic search directly inside the database engine. But what does that mean for data professionals, how does it actually work, and why should you care?
In this session, we’ll break down the fundamentals of vector search and show exactly how SQL Server stores, indexes, and queries embeddings to deliver intelligent search capabilities.
We’ll cover:
What embeddings are and how the vector data type works in SQL Server
How to generate and store embeddings using an external LLM
Performing searches using vector_search() and vector_distance()
How vector indexes (aka the DiskANN algorithm) work under the hood
We'll then bring it all together to build an intelligent, AI-driven application.
This session is ideal for data professionals and developers who want a practical understanding of SQL Server’s vector capabilities, with real demos and real use cases.