Tag Archives: SQLNewBlogger

RANK() vs DENSE_RANK(): #SQLNewBlogger

Posted on February 18, 2026 by way0utwest

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way. You’ll see how I checked on RANK() vs DENSE_RANK() below. Another … Continue reading →

Posted in Blog | Tagged , , , | Leave a 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

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