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…
Speaking at PASS Summit 2016
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…
Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)
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…
Columnstore Indexes – part 84 (“Practical Dictionary Cases”)
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…
Database Scoped Configurations
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…