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
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…
Clustered Columnstore Indexes – part 28 (“Update vs Delete + Insert”)
Continuation from the previous 27 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is all about the architectural specifics & performance optimizations for the Clustered Columnstore Indexes. It is known that Inserts are mostly faster than pure Update operations, since we…
Analysing SQL Server Agent Job Results through Power Query by reading Exchange Mails
This is my all time first post on the matter of PowerQuery, even though I have been playing and presenting it since it was publicly available almost a year ago (March 2013). First of all I have to recognise Andreas…