Continuation from the previous 134 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Not since SQL Server 2008 that Microsoft has added a new base data type to SQL Server, but in SQL Server 2025 they have added not…
I have worked with Master Data Services (aka MDS) extensively, especially during the engagement at OH22 around a decade ago, and I my interest in the area and that specific is documented in my blog – with the following examples:…
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…