Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for one of the cities in the USA and most of the times to Seattle. The reason behind it is the…
PASS Summit 2014 Recap
Porto.Data
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…
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…