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…
There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit sessions for the PASS Summit and even more, when the notification of the selection/non-selection are being sent to those who…
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…