Good article, and good point about the difficulty in getting non-technical people to realize how much they can contribute. I recall that an Auditor once complimented us on the consistent...

"it needs to be escaped using the forward-slash character "\"."

Sorry to be picky, but you mean the back-slash character. :hehe:

The real use of OPENJSON will be for structured JSON messages,...

MS could well implement this as a VM - sort of like a windows-based-docker thing. That would simplify compatibility and versioning.

As someone whose job involves using linux, mysql, windows, sql-server...

I am firmly in the "flag exceptions" camp. So normally I have columns like [disabled], [exclude], [unsubscribed] which default to zero, and are set to 1 to mark the exception....

Interesting idea Larry, thanks. Ques: would it be more efficient to do the MIN() and MAX() in one UPDATE?