20 years of blogging. With interruptions (voluntary or forced – but all in my responsibility), with blocks of high activity and relatively low activity. I have started on the 13th of January 2006 and today, on the 18th of January…
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…