Over the years, I have contributed with a reasonably big number of posts on the topic of In-Memory OLTP (aka Hekaton) and I did a couple of focused presentations on this wonderful feature as well. I love the idea, I…
Continuation from the previous 133 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this post we are going to test one of the more promising technologies in SQL Server-based offerings – Vector data types and its relationship with…
Continuation from the previous 132 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In the Columnstore Indexes space, there is a long-standing “tradition” in Microsoft to ignore the needs of the customers for data replication. It has started with…
Continuation from the previous 131 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Note: the original post was written on the 3rd of December 2025 in a moment of inspiration and a significant rewrite was done on the 7th…
This is the the 9th blog post in the series about Azure Arc enabled Data Services. The initial post can be found at Azure Arc for Data Services, part 1 – Intro and the whole collection can be found at…