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

What is Page Density

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

Adding and Dropping Columns I

Learning From Breakage

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

Learning from Mistakes: T-SQL Tuesday #194

We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have...

Who’s the Winningest Coach (with AI Help)

I was listening to the radio the other day and the hosts were discussing the NFL playoffs in 2026. Someone mentioned the winningest coach was Nick Sirianni of the...

Stupid Things I Did With AI: ASCII Art

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece of ASCII Art. I have a screenshot here: For some reason, I thought, “I should...