SQL Server BI Blog

What lessons have we learned about managing report projects and what are the best
practices?

Since each report is stored in a...

2010-03-11

1,245 reads

MDX Datasets with Date Parameters

How should date type parameters be prompted? There are two common approaches
depending on how you want the parameter to appear. ...

2010-03-11

408 reads

Article from the Architecture Journal ? 12-15-2009
by Paul Turley

Once upon a time, there was a big company whose IT department

wanted...

2010-03-11

866 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 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;