I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released. The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups…
Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)
Continuation from the previous 109 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…
Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0! This version introduces the initial support for Memory Optimised Objects on SQL Server 2014 & SQL Server 2016. The biggest difference…
CISL 1.4.0 is released
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…
MOSL – Memory Optimised Scripts Library
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in that release were the Memory-Optimised tables (aka In-Memory, aka In-Memory OLTP aka Hekaton) and even though for me personally…