To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days deep dive workshop on Columnstore Indexes. This public workshop will take place in Cologne on 10th & 11th of May…
Continuation from the previous 76 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I have written previously about SQL Server Integration Services and their interaction with Columnstore Indexes in Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer…
Continuation from the previous 75 parts, the whole series can be found at https://www.nikoport.com/columnstore/. While playing with SQL Server 2016 CTP 3.2, I have found some interesting feature being mentioned inside the engine. The strange thing was called a compression…
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post that would explain the current parameters and the way to use it are needed. Responding to this inner calling, here…
After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL Server 2014. The version 1.1.0 of the CISL (Columnstore Indexes Scrtips Library), free & open source is live and available…