At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert thresholds in Redgate Monitor and decided to write a little about this. This is part...
2026-04-06 (first published: 2026-03-23)
190 reads
los vidados – n. the half-remembered acquaintances you knew years ago, who you might have forgotten completely if someone hadn’t happened to mention them again – friends of friends,...
2026-03-20
22 reads
Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
219 reads
I come to Heathrow often. Today is likely somewhere close to 60 trips to this airport in my lifetime. After over 19 years of working with Redgate (plus a...
2026-03-18 (first published: 2026-03-17)
15 reads
I had a great time at SQL Saturday Atlanta 2026 this past weekend. I had some good comments and a few questions. I’ll write a bit more on this,...
2026-03-16
3 reads
Learn how to tie a bowline knot. Practice in the dark. With one hand. For the rest of your life, you’ll use this knot more times than you would...
2026-03-13
14 reads
One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...
2026-03-20 (first published: 2026-03-11)
307 reads
This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...
2026-03-10
11 reads
AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....
2026-03-09
17 reads
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
34 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers