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.

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

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

Monday Monitor Tips: Learning While Using the Tool

A customer was asking about what certain items in Redgate Monitor mean. They have a variety of skills on their staff, and they have developers accessing Redgate Monitor. This...

Representative Data Challenges

We need data that represents the problem we want to solve, or we might not achieve our aims.