BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....
2015-09-10
474 reads
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....
2015-09-10
474 reads
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure. Please read my blog here which was actually written...
2015-09-10
15 reads
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring...
2015-08-28
1,042 reads
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see...
2015-08-28
221 reads
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between...
2015-08-27
1,497 reads
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between different models. You can keep a single version of...
2015-08-27
348 reads
Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...
2015-08-21
702 reads
Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...
2015-08-21
253 reads
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data...
2013-08-18
588 reads
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...
2013-08-18
42 reads
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
We have a SQL Server installed. We have a 500GB drive for the database....
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers