Tag Archives: T-SQL

Refactoring SQL Code

Posted on December 12, 2025 by way0utwest

One of the things I see software developers often talking about is how they refactor code. As they touch a class, method, etc., they may take the time to refactor the code to make it cleaner, perform better, or just … Continue reading →

Posted in Editorial | Tagged | 1 Comment

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 , , | Leave a comment

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 , , , | Leave a comment