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…
ETL Optimisation Workshop @ SQLBits 2019
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 https://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 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…