Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more...

2010-05-15

10 reads

Opportunities in (I.T.) Chaos

I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a...

2010-04-18

8 reads

The Web 3.0 has finally arrived… It’s The Cloud

The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...

2010-04-02

14 reads

2001-01-01

14 reads

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

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  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;