UPDATE 25th of June 2019: The item related to this topic on Azure Feedback: Allow Updating Statistics on the Secondary Replicas of the Availability Groups We all love and use the wonderful features of the Availability Groups on the secondary…
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…
Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)
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…