Tag Archives: syndicated

Identity Columns Can’t Be Updated: #SQLNewBlogger

Posted on February 25, 2026 by way0utwest

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Rolling Back a Broken Release

Posted on February 23, 2026 by way0utwest

We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode and see what you think, but one thing that Pat asked … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Advice I Like: In 100 Years

Posted on February 20, 2026 by way0utwest

In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself today is “what might I be wrong about?” – from Excellent … Continue reading →

Posted in Blog | Tagged , | 4 Comments

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