T-SQL in SQL Server 2025: Fuzzy String Search I

Comparing strings has always been hard when we don't have great data quality. If we need exact matches, SQL Server works great. However, we often expect users to enter values without typos and know what values they want to find. Or at least know part of the string. However, matching with wildcards or partial strings […]

Deep Learning and Craftsmanship Matter

GenAI technology is going to change coding, but there is still a lot of work available for humans.

Encoding Strings

Chopping Off Data

An ETL issue with Excel causes issues, because the users didn't realize a limitation.

T-SQL in SQL Server 2025: Fuzzy String Search II

In the last article, we examined fuzzy string matching in SQL Server 2025 with a few new functions. We know comparing strings has always been hard when we don't have great data quality. If we need exact matches, SQL Server works great. However, we often expect users to enter values without typos and know what […]

Using Prompt AI to Help Setup Data Analysis

I used Claude to build an application that loaded data for me. However, there were a few others things I needed done to help me get the data ready...

Using SQL Compare with Redgate Data Modeler

Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take...

What is Page Density

Adding and Dropping Columns I

Learning From Breakage

We learn a lot when systems break, and we should appreciate that.