Skip to content
CSA Loom — the Microsoft Fabric experience for Azure tenants where Fabric isn't yet available: lakehouses, warehouses, notebooks, semantic models, Activator rules, Data Agents, across Commercial, GCC, GCC-High, and DoD IL5

Tutorial: SQL Server 2025 vector index editor

CSA Loom sql-server-2025-vector-index editor — verified working against a live console by the UAT harness on 2026-07-01.

Open the editor

  1. Sign in to your CSA Loom Console (for example https://<your-console-host>).
  2. Open or create a workspace from the Workspaces page.
  3. Click + New item and choose SQL Server 2025 vector index from the catalog.
  4. The editor opens at /items/sql-server-2025-vector-index/<id>:

SQL Server 2025 vector index editor

What this editor does

A SQL Server 2025 vector index is the native VECTOR type and index — CREATE VECTOR INDEX, JSON_AGG, regex, similarity search — for RAG without a separate vector store. In Loom it probes the SQL Server 2025 features against the target database.

Getting started

  1. Confirm support — The editor probes the database for SQL Server 2025 vector feature availability.
  2. Create a vector index — Run CREATE VECTOR INDEX over a VECTOR column.
  3. Store embeddings — Insert embedding vectors alongside your relational data.
  4. Similarity search — Query nearest neighbors for RAG grounding without a separate store.

Learn more

Verified by the UAT harness