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…
SQLBits 20 Workshop – Migrating & Running SQL Server on Azure VMs
UPDATE: The event has been moved to 29th of September to 3rd of October 2020 My love for the SQLBits is long (and so far I can be sure it was – how can one not admire the group who…