Category Archives: Blog

A New Word: Soufrise

soufrise – . The maddening thrill of an ambiguous flirtation, which quivers in tension halfway between platonic and romantic – maybe, but no, but maybe – leaving you guessing what’s going on inside their chest, forced to assume that at … Continue reading

Posted in Blog | Tagged | Leave a comment

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

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

Changing the Cardinality of a FK in Redgate Data Modeler

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