Tag Archives: syndicated

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 as an example for people trying to get blogging as #SQLNewBloggers. … Continue reading

Posted in Blog | Tagged , , | Comments Off on Get a Range of Sequence Values: #SQLNewBlogger

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 at sqlmonitormetrics.com, it’s a feature that’s used by many. It has … Continue reading

Posted in Blog | Tagged , , | Comments Off on Monday Monitor Tips: Oracle Custom Metrics

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 realize unless you remember this is an aggregate function. Another post … Continue reading

Posted in Blog | Tagged , | Comments Off on JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on Wheels blog for a long time and I appreciate all that he does, especially given his struggles with ALS. I kicked myself a few times for … Continue reading

Posted in Blog | Tagged , , | 1 Comment