Continuation from the previous 35 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ At the 12th Edition of SQLBits around 1 week ago I have had a short but interesting conversation about Columnstore Indexes, its sizes and its importance for rebuild processes with Ola…
SSIS Project Deployment under different name
I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version without any doubt, even though the RTM bits were not production ready. There is one issue with the SSIS Project…
SQLSaturday Porto Edition 2014 Selection Process Results & Voting
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that we decided to do for SQLSaturday Portugal Oporto 2014 Edition, that I have initially blogged about at SQLSaturday Porto edition…
SQLBits XII Recap
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones. There is a technological event that is called SQLBits. It’s 12th edition last weekend was a different one. For me it was…
Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)
Continuation from the previous 34 parts, starting from https://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/ This blog post is about controlling some of the Columnstore Indexes behaviours in less obvious ways – by using Trace Flags & Query Optimiser Rules. I will be looking into updating…