AI 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.

0

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

by Karen Lopez

July 2, 2025

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.

0

Title slide: Responsible and Ethical AI Frameworks: An Introduction

by Karen Lopez

June 23, 2025

Responsible and Ethical AI Frameworks

If you’re a data professional and you’re not brushing up on Responsible and Ethical AI frameworks, […]

1

by Karen Lopez

May 19, 2025

SQL Server 2025 & SSMS: New Bling

Microsoft Build 2025 unveiled new logos for SQL Server 2025 and SSMS, modernizing their look. The updates reflect a polished, consistent design, enhancing user experience. Upcoming features in SQL Server 2025 include vector functions, AI model management, and new T-SQL functions. SSMS will introduce dark mode, Git integration, and more.

0