Presentations & Blogging of 2016 in Review
For the 4th year in a row, I am keeping data on my professional engagements to help the others –
public...
2017-01-02
413 reads
Niko's blog
Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)
Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given that currently the Batch Execution Mode...
2016-12-28
968 reads
Announcing Tuga IT 2017
Its the right time & the right moment of the year to announce the 2nd edition of the ultimate portuguese IT...
2016-12-19
297 reads
Delivering workshop at SQLBits 17
Its the end of the another great year (2016) and I already have received an incredible news for the next...
2016-12-19
303 reads
CISL 1.4.1 is released
Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1...
2016-11-30
642 reads
Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
605 reads
Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)
Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of...
2016-11-20
618 reads
Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)
Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on a...
2016-11-20
604 reads
SQL Server 2016 Service Pack 1 – What’s New
With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...
2016-11-16
837 reads
SQL Server 2016 SP1 – Programmability Surface for everyone!
This is the most important blog post about SQL Server that I have ever written. As far as I am...
2016-11-16
558 reads
Blogs
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...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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