Speaking at SQLSaturday Rheinland, Germany 2015
It is always a very special moment whenever you receive a notification of being selected to present at any event....
2015-05-22
356 reads
It is always a very special moment whenever you receive a notification of being selected to present at any event....
2015-05-22
356 reads
I am extremely happy to share that I shall be delivering a workshop at the amazing SQLSaturday Cambridge on 10th...
2015-05-12
487 reads
Continuation from the previous 51 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Microsoft has launched Service Pack 1 for...
2015-04-28
482 reads
It is always feels like a great honour to be invited to speak at a big conference, but when this...
2015-04-26
395 reads
One more project can be finally revealed – on the 5th of May of 2015, SQLPort is invading the home base...
2015-04-24
443 reads
Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This post is dedicated to usage of...
2015-04-19
1,111 reads
É com uma enorme felicidade e orgulho que gostava de partilhar a notícia sobre a criação de um evento Português...
2015-04-06
608 reads
Continuation from the previous 49 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This blogpost is focused on the reading part of the IO subsystem...
2015-04-04
881 reads
On 21st of April 2015, SQLPort is preparing a very special event. The reason for this is that on 21st...
2015-03-30
1,097 reads
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the...
2015-03-19
870 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