SQL Server 2025 for Architects: The Vector Type and Native JSON

SQL Server 2025 vector and json types as observed at CU4: the types and exact search work with no switch; the vector index, VECTOR_SEARCH and float16 need PREVIEW_FEATURES

What the SQL Server 2025 vector and json types do when you run them: exact and approximate search, what still needs the preview switch, what an index costs on writes, and when one engine is enough. Every result comes from the container image in a CI pipeline.

Read more →