YouTube Video
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
✅ 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