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…
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 119 (“In-Memory Columnstore Location”)
Continuation from the previous 118 parts, the whole series can be found at https://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…
Parallelism in Hekaton (In-Memory OLTP)
Recently I have made some very interesting discoveries about Hekaton (aka In-Memory OLTP) that I felt absolutely necessary to share with the world. I assume that the most people already know about this specifics, but discovering these details has helped…