I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for Portugal) is born. This new community will focus on the Cloud and on Microsoft Azure in particular. This new community…
Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)
Continuation from the previous 95 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online…
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 Unplugged. Leaded by Scott Klein (One of the best tech evangelist that Microsoft has), this show focuses on talking…
Columnstore Indexes – part 95 (“Basic Query Patterns”)
Continuation from the previous 94 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I am continuing showing some of the solutions for the common problematic places for the Columnstore Indexes. Here I will focus on…
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post will talk about some of the common problematic practices for the Columnstore Indexes and how to avoid or solve them. It is not…