Continuation from the previous 70 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In the SQL Server world of data modification tracking, there are 2 very important features, which are called Change Data Capture (CDC) and Change Tracking (CT).…
Columnstore Indexes – part 70 (“Filtered Indexes in Action”)
Continuation from the previous 69 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is the continuation from the previous one, where I have described the Operational Analytics for Rowstore. I have tried to create a filtered…
Columnstore Indexes – part 69 (“Operational Analytics – Disk Based”)
Continuation from the previous 68 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost is dedicated to one of the key improvements in Columnstore Indexes in SQL Server 2016 – the Operational Analytics. This blog post is focused…
My PASS Summit 2015
Its just a bit over a week until PASS Summit 2015 will start. If you are a Microsoft Data Platform professional, then there is no other more important event in the universe than this one. There are some amazing workshops…
Speaking at SQLSaturday #459, Madrid 2015
Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a row. The first Spanish SQLSaturday took place in 2014 in Barcelona, and this was definitely one of the most remarkable…