Posts in Database

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 () );
by Karen Lopez
August 18, 2025

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

Traditional T-SQL queries are great for structured data and exact matches. But they struggle with nuance. That’s where vector search comes in.
0
read more
Schema Drift: The Quiet Killer of Data Trust How unnoticed changes in data structure erode trust in reliability Karen Lopez
by Karen Lopez
June 21, 2025

Schema Drift: The Quiet Killer of Data Trust

Discover how schema drift silently breaks data trust and what data architects can do to detect and prevent it. Practical tips and cultural insights included.
1
read more
by Karen Lopez
April 1, 2025

An Experiment with Copilot: On Azure SQL DB Security

Today at the Fabric Community Conference (FabCon) I presented a session “A Database Designer’s Favorite Security […]
0
read more