Open Source Archives

Screenshot of the code in the post for creating a table. -- Create a table to store product data, including vector embeddings CREATE TABLE Product ( ProductID INT PRIMARY KEY, Name NVARCHAR (255), Category NVARCHAR (50), Description NVARCHAR (MAX), ProductDescriptionVector VECTOR (768), -- Assuming 768-dimensional embeddings CreatedAt DATETIME2 DEFAULT GETDATE () );

Traditional T-SQL queries are great for structured data and exact matches. But they struggle with nuance. That’s where vector search comes in.

Decorative graphi with black backgound and pink networking and node lines spraying out from the words "DocumentDB is Back!" AI Generated

by Karen Lopez

March 31, 2025

Microsoft’s DocumentDB is Back

Microsoft's got a new local version of DocumentDB, an open-source NoSQL database built on PostgreSQL. It's designed to give developers complete visibility and features like CRUD operations and indexing to meet their data needs.

Posts in Open Source

Vector Search in SQL Server 2025: What It Is and Why It Matters

Microsoft’s DocumentDB is Back

Karen Lopez