Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
800 reads
Niko's blog
Columnstore Indexes – part 99 (“Merge”)
Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on the...
2017-02-26
841 reads
Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
468 reads
SQLPort V2
The new site of SQLPort is finally live. This is not just a redesign of the original site, published in...
2017-02-06
301 reads
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
662 reads
CloudProPT – The New Cloud/Azure Community in Portugal
I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...
2017-01-27
460 reads
Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)
Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on a...
2017-01-22
694 reads
The most underrated show on Data Platform – SQL Unplugged
I would like to write a blog post about by far the most underrated online show about Data Platform – SQL...
2017-01-20
705 reads
Columnstore Indexes – part 95 (“Basic Query Patterns”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...
2017-01-07
498 reads
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
581 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers