What would be a good candidate for the very first blog post in 2019? The blog post I started writing in 2018 and did not finish. To be more precise I was planning & opened a draft with some notes…
Database Scoped Configurations in 2018
Announcing “Columnstore & Batch Execution Mode” Channel
It is time. I have been thinking about this for about a year and playing with the idea for way too long, with the concrete plans for the January of 2018, than August 2018 … Anyway – here we go…
Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)
Continuation from the previous 125 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have a huge love for the DBCC CLONEDATABASE command – it has been made available (backported) to every SQL Server version starting with SQL Server…
Resumable Online Index Creation
It is quite strange to write an article about Resumable Online Index Creation 14 months after writing about Resumable Online Index Rebuild operation, because from the physical world logic there should be first the initial creation and then rebuild process,…
CosmosDB: NOSQL – faster than relational databases
This blog post is a continuation in the little series about CosmosDB, that is started with the post CosmosDB: NoSQL, NoDBA & NoProblem? In this blog post I am going to research some common way of viewing about the default…