Microsoft generally available’d DiskANN vector indexes and vector search in Azure SQL Database, Azure SQL Managed Instance with the Always-up-to-date update policy, and SQL database in Microsoft Fabric (Hoffman, 2026-09-29; Learn). Framing: store vectors alongside operational rows under the same security model and T-SQL—no separate vector store to provision or sync.
This post covers DiskANN vector indexes only, not the other SQLCon and FabCon Europe announcements.
GA vs still preview
| Surface | Status |
|---|---|
| Azure SQL Database | GA |
| Azure SQL MI — Always-up-to-date | GA |
| Fabric SQL database | GA |
| SQL Server 2025 | Preview |
| Azure SQL MI — SQL Server 2025 update policy | Preview |
The preview engine and policy are separate from the cloud GA story (Learn).
What you get
DDL: CREATE VECTOR INDEX … WITH (METRIC = 'cosine'|'dot'|'euclidean', TYPE = 'DiskANN') — DiskANN is the only/default ANN type (Learn).
Latest-index query shape uses SELECT TOP (N) WITH APPROXIMATE … FROM VECTOR_SEARCH(…) (legacy TOP_N param retired for v3 indexes). Docs also note clustered PK on int, ≥100 non-NULL vector rows to build, and no partitioning of vector indexes.
DML + maintenance (vendor claims)
Thota (2026-09-28) says the vector index now has full DML support, with the index staying updated as data changes. Learn documents INSERT/UPDATE/DELETE/MERGE on the latest DiskANN format plus background index maintenance. These are Microsoft’s statements; no latency or recall comparison with dedicated vector stores is given, and this post makes no Hyperscale-vs-Aurora price claim.
Who should care
SQL-centric teams that want RAG / semantic search in-engine under existing RBAC, RLS, and backup regimes should start at the Hoffman SQLCon wrap and CREATE VECTOR INDEX. Confirm which products are GA and the Always-up-to-date policy, treat SQL Server 2025 as preview, and attribute DML and maintenance claims to Microsoft.

The Campfire
CommentsThanks. Your comment is waiting for the desk. Once it is approved it appears here within about a minute.
Add a comment