Continuing the trend started last year with the post My Favourite Books that I read in 2018, I wanted to share my favourite books from the past year 2019. I have not been even as productive as I wished to…
My Favourite Books that I read in 2019
Azure SQL DW Materialized Views (part 2)
This blog post is a continuation of a small series of posts that I am writing about Azure SQL DW Materialized Views, and you can catch up the initial things in Azure SQL DW Materialized Views (part 1). In this…
Azure SQL DW Materialized Views (part 1)
A couple of months a very exciting announcement has been made by Microsoft (that went totally ignored by the vast majority of the market) – the implementation of the Materialized Views in Azure SQL DW (Also known as Azure Synapse…
Azure SQLDW Result Set Caching
The main idea about Result Set Caching is very simple – you take the already processed results from the complex expensive queries and store it accessible so when the very same query arrives asking for the result again, the server…
Columnstore Indexes – part 130 (“Columnstore Indexes on Azure SQL DB”)
Continuation from the previous 129 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Almost 2 years ago (22nd of March 2018) in Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”) I have already…