One more project can be finally revealed – on the 5th of May of 2015, SQLPort is invading the home base of the 10th eldest university in europe (Unesco World Heritage Site) – Coimbra. This will be an epic 66th…
SQLPort in Coimbra
Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)
Continuation from the previous 50 parts, the whole series can be found at https://www.nikoport.com/columnstore/ This post is dedicated to usage of one of the most important technologies in ETL space – SQL Server Integration Services and its integration with the…
Clustered Columnstore Indexes – part 50 (“Columnstore IO”)
Continuation from the previous 49 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blogpost is focused on the reading part of the IO subsystem of the Columnstore Indexes. I will try to explain the improvements in the reading process as well as some…
Azure SQLDatabase v12 Premium Editions and Available Cores
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the leadership trio consisting of Shawn Bice, Nigel Ellis, and Rohan Kumar and was lucky enough to have them answered. The…
Clustered Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”)
Continuation from the previous 48 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Note: Updated on 05th of March 2015 with information on SQL Server 2012. Having blogged a couple of times on the matters of Segment Elimination (“Data Loading for Better Segment Elimination”,…