What would be a good candidate for the very first blog post in 2019? The blog post I started writing in 2018 and did not finish. To be more precise I was planning & opened a draft with some notes…
Database Scoped Configurations in 2018
ETL Optimisation Workshop @ SQLBits 2019
The biggest in the Europe & the craziest (in the very best sense) in the World conference for the Microsoft Data Platform has always been the SQLBits. I can not deny that every year I can, I am delighted to…
Batch Mode – part 4 (“Some of the limitations”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. This post will focus on some of the initial limitations of the Batch Execution Mode on the Rowstore…
Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”)
Continuation from the previous 120 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Yesterday, Kevin Farlee (Program Manager for Columnstore Indexes) announced that Columnstore Indexes have finally found their way into Standard Tier of the Azure SQL Database, I…
Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)
Continuation from the previous 118 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This is a rather simple blog post that is dedicated to the theme of the In-Memory Columnstore Indexes location. This has been a constant topic of…