Vectors in SQL Server 2025

Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]

Odd Sequences

Identities and Sequences I

Fun with JSON II

String Similarity II

Find Duplicate Rows in SQL Server with a CTE

This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).

String Similarity I

Creating JSON III

Missing the Jaro Winkler Distance

Fun with JSON

Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]