Category Archives: Blog

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

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

Posted on April 14, 2026 by way0utwest

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 , , | Leave a comment

Changing the Cardinality of a FK in Redgate Data Modeler

Posted on April 13, 2026 by way0utwest

One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this  easy, and this post will show you how. This is part of … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Advice I Like: Rewards from Work

Posted on April 10, 2026 by way0utwest

The greatest rewards come from working on something that nobody has words for. If you possibly can, work where there are no names for what you do.” – from Excellent Advice for Living I work for a software company, trying … Continue reading →

Posted in Blog | Tagged , | 4 Comments