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…
Continuation from the previous 82 parts, the whole series can be found at https://www.nikoport.com/columnstore/ A lot of things were changed in SQL Server 2012, which was quite a ground-breaking release if you look at it with a lot of attention…
As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will take place on 25th & 26th of May. This time its main topic is the evolution of Data Platform, with…
Continuation from the previous 81 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Previously, I have blogged about about the Extended Events in SQL Server 2014 3 times: Columnstore Indexes – part 44 (“Monitoring with Extended Events”) served as…