Tag Archives: T-SQL

Database Collation Matters for Unicode: #SQLNewBlogger

Posted on December 3, 2025 by way0utwest

While trying to work with Unicode data, I found some issues with collation. This post showcases what I’ve seen, with probably not enough answers. The collation/UTF stuff is still slightly confusing to me. Another post for me that is simple … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Database Collation Matters for Unicode: #SQLNewBlogger

Finding the Last Last Name in SQL: #SQLNewBlogger

Posted on November 19, 2025 by way0utwest

I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting “Paolino” from “Miguel Angel Paolino”. This post will show how you … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

SQL Server 2025 RegEx and AI

Posted on November 12, 2025 by way0utwest

One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take a few minutes and try to examine how this feature works, … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server 2025 RegEx and AI

T-SQL Tuesday #191 Round Up

Posted on October 28, 2025 by way0utwest

I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at the blogs people published. First as always, Rob Farley writes about the complexity of string parsing, using TVFs. He also … Continue reading →

Posted in Blog | Tagged , , | 1 Comment