The life of the vast number of human beings is marked by the principle “… and THEN …” Yes, that is correct – the word then is written in capital letters with an emphasis, because that is how it is…
And THEN …
Striping Backups to Azure Blob Storage
I love Azure Blob Storage. It is a great source for the Data Disks for the Azure VMs (IaaS), Data Files for Azure SQL Database Managed Instance and of course for the key things that guarantees the business running –…
Delivering a precon on Columnstore Indexes at SQLSaturday Israel 2020
UPDATE: GIVEN THE CURRENT SITUATION WITH COVID-19 THIS EVENT HAS BEEN POSTPONED. This week seems like a line of announcements, but mostly because they have been in works hidden for quite some time – on the 6th of May in…
SQL Server 2019: Session Context & Parallel Plans
You might have heard about the wonders of Context functions (SESSION_CONTEXT, CONTEXT_INFO) – they can offer some interesting solutions for the access control, but do you know what it can mean for the integration with the high performing queries? Session…
Columnstore Indexes – part 131 (“Rebuilding Rowstore Indexes ONLINE”)
Continuation from the previous 130 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost will be about older SQL Server versions (2016, 2017) and some implications that I have found that people rather do not understand, until they…