Tag Archives: T-SQL

Get a Range of Sequence Values: #SQLNewBlogger

Posted on April 22, 2026 by way0utwest

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Posted on April 15, 2026 by way0utwest

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not realize unless you remember this is an aggregate function. Another post … Continue reading →

Posted in Blog | Tagged , | Leave a comment

Finding the Next Sequence Value: #SQLNewBlogger

Posted on March 30, 2026 by way0utwest

I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I used some AI help to make it very quick to get … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Finding and Updating Duplicate IDs: #SQLNewBlogger

Posted on March 18, 2026 by way0utwest

Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I decided to write a couple of posts on the topic. This … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Finding and Updating Duplicate IDs: #SQLNewBlogger