Microsoft Developer: 1B row vector search in less than a second with Azure SQL Database Hyperscale | Data Exposed

Learn about vector indexing in Microsoft SQL from the PM and engineering team.



✅ Chapters:

0:00 Intro to Product Management and Engineering vector team

1:13 What things were customers asking for. Example scenario: support team looking for similar or related cases

2:02 Everything's fine but now it needs to scale better, so we built and index

2:37 Anna asks why can't we just use exact search?

2:59 Intro to DiskANN - a graph-based vector index

3:35 Why is it called DiskANN

4:30 Next customer asks for not just vector search but also iterative filtering

5:50 Anna reacts to iterative filtering vs post-filtering

6:33 Next customer asks for insert, update, delete, without needing to update the index

7:05 DML vector demo

8:00 Approximate vs exact vector search, handled by optimizer

10:20 Next customer asks to search on 1 billion rows

10:49 Vector search still returns within milliseconds

11:17 Pooja reacts to all the customers asks being met so far

12:05 Vector Index in Azure SQL PaaS and Fabric SQL is now generally available!



✅ Let's connect:

LinkedIn - Pooja Kamath

LinkedIn - Krithika Subramanian

Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna

Twitter - AzureSQL, https://aka.ms/azuresqltw



🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt



🔔 Subscribe to our channels for even more SQL tips:

Microsoft Azure SQL: https://aka.ms/msazuresqlyt

Microsoft SQL Server: https://aka.ms/mssqlserveryt

Microsoft Developer: https://aka.ms/microsoftdeveloperyt



#AzureSQL #SQL #LearnSQL