Data is everywhere, and if you want to make sense of it, SQL (Structured Query Language) is your secret weapon. Whether it’s managing customer data or analyzing trends, SQL...
2024-04-19 (first published: 2024-04-06)
443 reads
I’ve watched teams spend a lot of time on backup strategy. They plan out the full, differential, and log backups to ensure they can successfully meet the recovery point...
2024-04-17 (first published: 2024-04-05)
332 reads
In today’s world, data is everywhere. Companies collect it, governments analyze it, and it influences everything from what products we buy to how we vote. But all that data...
2024-04-17 (first published: 2024-04-05)
198 reads
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
25 reads
Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...
2024-04-16
23 reads
There are so many choices and so little time. How do you go about deciding what to learn? I have to delicately balance everything I think I want to...
2024-04-15 (first published: 2024-04-02)
421 reads
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. It’s scheduled for 1 PM EDT / 5 PM UTC. Sign...
2024-04-15
25 reads
Your boss walks up to you one morning and says, “Hey, I wanna list of all of our databases and when they were last accessed”. If you’ve got some...
2024-04-15 (first published: 2024-04-02)
1,163 reads
the wends– n. the frustration that you’re not enjoying an experience as much as you should, which prompts you to try plugging in various through combinations to trigger anything...
2024-04-12
27 reads
I’m heading to the UK in a few weeks for the London Redgate Summit. This starts a wild period of travel for me, but I’m excited. This is the...
2024-04-12 (first published: 2024-04-03)
138 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