Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join any 2 or more given data sources together, while in the real world it might the biggest pain in…
Data Quality Matching in SQL Server
Hekaton 2014 – The Saviour vs The Lost Cause
With the release of the SQL Server 2014, Microsoft has finally unleashed their long-time in work In-Memory solution (codenamed XTP for Extreme Transaction Processing, old codename Hekaton). Note: I will be keep on using the name Hekaton since Dr Devitt…
Modern DataWarehouse: The Weakest Link
It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many data professionals and publications around the world. Some people describe this term as a conjunction of many different types of…
Clustered Columnstore Indexes – part 29 (“Data Loading for Better Segment Elimination”)
Continuation from the previous 28 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ One of the key performance factors for Columnstore Indexes is Segment Elimination. I have been presenting on this matter for quite a while, but never actually blogged about it. Every Columnstore…
Co-Delivering a full-day precon on SQLBits
This week I have got some very exciting news – together with Andreas Wolter I will be delivering a full-day precon at the biggest European Microsoft Data Platform Conference – SQLBits. On 17th of July 2014 we shall be delivering…