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
Niko's blog
CISL 1.3.1 is released
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
595 reads
Speaking at SQLSaturday #555, Munich 2016
I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich...
2016-08-25
483 reads
1 Day Workshop – Columnstore Deep Dive (in German) on 6th of October 2016
To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive...
2016-08-24
413 reads
Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)
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
966 reads
CISL 1.3.0 is released
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL...
2016-07-24
435 reads
Announcing Workshop for SQLSaturday Porto 2016
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
Speaking at PASS Summit 2016
There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit...
2016-06-25
425 reads
Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)
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
Columnstore Indexes – part 84 (“Practical Dictionary Cases”)
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
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers