Playing with SQL Server 2019 CTPs for some time, I have noticed some very exciting feature that I did not see mentioned by anyone before. The feature if you think about it, is so straight and obvious that after reading…
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…
CosmosDB: NOSQL – faster than relational databases
This blog post is a continuation in the little series about CosmosDB, that is started with the post CosmosDB: NoSQL, NoDBA & NoProblem? In this blog post I am going to research some common way of viewing about the default…
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…
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is dedicated to the Bulk Load API and the sudden changes that might take place and affect it during the loading process into…