I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November 2014. Porto.Data is a new User Group & a Community dedicated to the Microsoft Data Platform that will be operating…
Porto.Data
Clustered Columnstore Indexes – part 42 (“Materialisation”)
Continuation from the previous 41 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Important Disclaimer – I have started writing this blog post over 1 months ago, but because of all engagements such as SQLSaturday Portugal, only today at night managed to finally finish…
SSIS ReportGenerator Task
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some strange hour, such as 4:30 AM because of the different timezones involved or because it takes so much time and…
Clustered Columnstore Indexes – part 41 (“Statistics”)
Continuation from the previous 40 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Note: This article is in’s 2nd version, after correcting comments done by Hugo Kornelis Since I have started writing & doing presentations on Columnstore Indexes there have been a number of…
Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)
Continuation from the previous 39 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ It’s time to take a look into the algorithms that Microsoft is using to compress Columnstore Indexes. I have presenting on this topic for quite some time and especially during Workshops…