Jared Zagelbaum's Blog

Teaching good old SSRS a new trick…

Background
Not too long ago I had a client with a very simple, yet practical requirement: they...

2014-11-14

1,256 reads

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...

2014-11-10

476 reads

Hello, dear blog reader. Today’s post is coming to you straight from the home...

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

One of the things a customer asked recently about Redgate Data Modeler was how...

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Comments posted to this topic are about the item Removing TDE

Comments posted to this topic are about the item Poor Names

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;