SQLPort in Aveiro
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
433 reads
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
433 reads
I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...
2016-08-28
596 reads
I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich...
2016-08-25
484 reads
To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive...
2016-08-24
414 reads
Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/
With the release of SQL Server 2016,...
2016-07-29
967 reads
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL...
2016-07-24
436 reads
I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called
SQL...
2016-06-27
457 reads
There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit...
2016-06-25
426 reads
Continuation from the previous 84 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I wanted to write a blog post...
2016-06-21
499 reads
Continuation from the previous 83 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this blog post I wanted to...
2016-06-20
616 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