TeaM Data office hours

Join us Thursdays for virtual TeamData Office Hours

Data management discussion 
TRaining

Learn about our online and in-person, hands-on training

Articles 

Latest Blog Posts

Click on Blog in the top menu to see all posts

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 () );
Open SourceSQL Server and Azure SQL DBVector Search

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.
by Karen Lopez
on Aug 18
Read more
AI generated graphic showing a shield, a lock, a map with alerts on it. It has a card that says SCANNING There are cards on the right that say NATIONAL ID NUMBER CREDIT CARD NUMBER DIAGNOSTIC REPORT
CopilotData ClassificationData SecurityDatabaseMicrosoft Purview

The Role of Data Governance in Risk Management

Keeping track of sensitive data across your organization can feel like a huge effort. Microsoft Purview is a great tool to prepare for eventual data breaches. Notice I said eventual, not potential. It's going to happen at some point and our work can be a key part of incident detection and response.
by Karen Lopez
on Jul 2
Read more
image of a generated skyline of Reykjavik featuring buildings and its iconic church. There are three symbol at the bottom: database cylinder, "AI" with a square around it, and a increasing bar chart with a upward trend arror.
Data GovernanceData QualityEthicsPresentationsSpeaking

Updating Data Programs with Responsible and Ethical AI: Highlights from Reykjavik

At the Global Data Summit, I discussed the use of ethical AI in data governance, emphasizing principles of fairness, accountability, sustainability, and transparency,
by Karen Lopez
on Jun 26
Read more