X on XMLA: ii. Basic Structure of XMLA
The second post in the XMLA series focuses on the basic structure of XMLA. At its heart, XMLA is XML. ...
2012-03-27
699 reads
The second post in the XMLA series focuses on the basic structure of XMLA. At its heart, XMLA is XML. ...
2012-03-27
699 reads
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
583 reads
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
673 reads
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
577 reads
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
593 reads
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
597 reads
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
988 reads
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
632 reads
In my previous blog, I introduced the “X on XMLA” series. In this blog, I will do more of an...
2012-01-26
663 reads
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
548 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