Adding and Dropping Columns II

Deploying an Updated Model with SQL Compare 16

In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this...

Looking Back at the Redgate 2026 Company Kickoff

Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I...

More Documentation is Needed

AI is everywhere, and if you spend any amount of time looking for answers on the Internet to your coding challenges, you've likely encountered a lot of poor, average, good, bad, amazing, and just-helpful-enough AI content. For awhile, I was avoiding the AI summary from Google as the quality seemed slightly off, but lately it's […]

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