Introducing “X on XMLA”
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
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
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
570 reads
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
510 reads
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
564 reads
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
788 reads
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
460 reads
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
398 reads
Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...
2011-10-16
491 reads
Here is the summary of the session I attended while at my 4th day at the Summit. (Technically, this is...
2011-10-16
423 reads
Got to David DeWitt’s Keynote a bit late so this will not cover as much as normal. (For the record,...
2011-10-14
488 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers