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 →

EF Core 10: Vector Search, LeftJoin/RightJoin, and Full-Text Search on Cosmos DB

Entity Framework Core 10, released alongside .NET 10, introduces features that position it as a first-class choice for AI-powered applications. The headline addition—vector search support—enables semantic similarity queries directly in LINQ, while new LeftJoin/RightJoin operators and Cosmos DB full-text search round out a release focused on modern data access patterns. This comprehensive guide explores each […]

Read more →