SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets I recently ran across a poorly covered topic in regards SSRS development using MDX parameters and datasets. After...
2013-02-07
32 reads
HP Announcement: PDW V2 Appliance Features
New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server...
2012-11-16
2,201 reads
HP Announcement: PDW V2 Appliance Features New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server PDW have been announced! Highlights: Lower price point (backup...
2012-11-16
12 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,138 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
22 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,180 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
39 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,822 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
36 reads
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,420 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