I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL – Columnstore Indexes Scripts Library is finally public – the 1.3.0 version. The most important part of this release is…
I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called SQL Server Professional Configuration & Optimisation Workshop will be delivered by my friend André Batista & myself on…
Continuation from the previous 84 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I wanted to write a blog post on some of the changes that were implemented in SQL Server 2016, that might affect workloads migrated from SQL…
Continuation from the previous 83 parts, the whole series can be found at https://www.nikoport.com/columnstore/ In this blog post I wanted to focus on 2 practical aspects of Columnstore Dictionaries compression – the ones I have seen in the past months…
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations. This improvement allows you to control a number of parameterisations of the SQL Server, based on the database level. The…