A couple of months a very exciting announcement has been made by Microsoft (that went totally ignored by the vast majority of the market) – the implementation of the Materialized Views in Azure SQL DW (Also known as Azure Synapse…
Continuation from the previous 128 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I would like to point the compatibilities with the immediately upcoming release of Sql Server 2019 and the Columnstore Indexes. In the…
Continuation from the previous 127 parts, the whole series can be found at https://www.nikoport.com/columnstore/. First of all and before everything else, I would like to extend my gratitude to Xiaoyu Li (Microsoft PM) for taking her time and exchanging long…
Continuation from the previous 126 parts, the whole series can be found at https://www.nikoport.com/columnstore/. With the appearance of the Batch Mode on the Rowstore Indexes (FINALLY!), the big question (aka Elefant) is in the room – DO WE STILL NEED…
I have a very special relationship with MDS (Master Data Services), and even though for some reason I have never blogged about it, I feel like SQL Server 2019 is bringing a good reason to blog about. To define my…