DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,224 reads
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,224 reads
Paul Turley
Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...
2011-05-23
3,612 reads
I’ve seen a few cases where reports exported or rendered to PDF have distorted charts and images. We’ve played with...
2011-05-05
1,690 reads
…continued from part 1:
Building a Report
For the remainder of this article, I will demonstrate query and report design techniques by...
2011-05-04
1,678 reads
Start at part 1
…continued from part 2:
Handling Parameters
When an MDX query is created using the graphic query designer, parameters can...
2011-05-04
1,214 reads
It’s often true that “a picture is worth a thousands words” but sometimes a picture can be such an effectively...
2011-04-23
1,340 reads
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,374 reads
Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to...
2011-03-07
627 reads
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,324 reads
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,088 reads
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...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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