SQLSaturday Portugal 2015 – Above & Beyond
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
442 reads
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
442 reads
Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...
2014-12-16
657 reads
With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...
2014-12-12
652 reads
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
435 reads
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
363 reads
Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the monitoring aspects of the Columnstore Indexes,...
2014-11-23
404 reads
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
278 reads
Continuation from the previous 42 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the Transaction Log behaviour, which might explain...
2014-11-19
423 reads
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
448 reads
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
308 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