Get a Range of Sequence Values: #SQLNewBlogger

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...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

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...

Monday Monitor Tips: Oracle Custom Metrics

One of the popular features of Redgate Monitor has been the ability to add custom mertics for various purposes. This has been popular, and along with our curated list...

Multiple Sequence Values

Other IDEs

This editorial was originally published on Jun 17, 2020. It is being republished as Steve is out of town. Let us know if you've changed your SQL IDEs since then. Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us […]

Questions and Answers from Running a Local LLM

I had a few random questions from my Running a Local LLM on Your Laptop session at the Houston AI-lytics 2026 event last week, so this post looks at...

Spring Connections and Learning at PASS On Tour

The spring PASS On Tour event is coming to Chicago in a few weeks.

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.

Writing Before Reading

We often learn to write code before we really learn to read it, which seems like a problem to Steve.

Houston AI-Lytics 2026–Powerpoint Slides

Thanks to everyone for attending my session on running a Local LLM. If you have any questions, please feel free to reach out with them. The slides with links...