If you have been following this blog closely in the past month, you might have noticed that I have started blogging actively about the Azure Synapse Analytics (Azure SQL DW) lately – (Azure SQLDW Result Set Caching, Azure SQL DW…
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 128 (“Ordering Columnstore Indexes in Azure SQL Datawarehouse”)
Continuation from the previous 127 parts, the whole series can be found at https://www.nikoport.com/columnstore/. First of all and before everything else, I would like to extend my gratitude to Xiaoyu Li (Microsoft PM) for taking her time and exchanging long…