Between 19th-21st of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT. Targeting Microsoft Data Platform, BizTalk, SharePoint, Office365, Azure Infrastructure & much more, this event will be one of the biggest IT…
Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Continuation from the previous 66 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Continuing from the last couple of blog posts on the improvements for the DataWarehouse scenario with Clustered Columnstore Indexes, I want to turn this time to…
Speaking at SQLSaturday #446, Oregon 2015

I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as Shanghai or Trinidad & Tobago, but there is one of the biggest countries in the world, where even though I…
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)

Continuation from the previous 65 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Continuing writing about the improvements added to Clustered Columnstore Indexes (DataWarehousing & Business Intelligence) in SQL Server 2016, this blog post is a direct continuation from…
Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)

Continuation from the previous 64 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This article is dedicated to the improvements to Clustered Columnstore Index in SQL Server 2016. The Clustered Columnstore Index is designed for DataWarehouse & Decision Support…