Tag Archives: SQLNewBlogger

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

The Challenge of Implicit Transactions: #SQLNewBlogger

Posted on September 24, 2025 by way0utwest

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another post for me that is simple and hopefully serves as an … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Sparse Columns Can Use More Space: #SQLNewBlogger

Posted on September 10, 2025 by way0utwest

I saw this as a question submitted at SQL Server Central, and wasn’t sure it was correct, but when I checked, I was surprised. If you choose to designate columns as sparse, but you have a lot of data, you … Continue reading →

Posted in Blog | Tagged , | 3 Comments