Monthly Archives: April 2026

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 , , | 1 Comment

Poor Names

Posted on April 13, 2026 by way0utwest

It’s always interesting to me when I give product feedback to engineers at Redgate on their demos. Quite often they’ve built a feature that uses AdventureWorks or Pagila (PostgreSQL) or some other well known schema to evaluate how their particular … Continue reading →

Posted in Editorial | 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