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…
Database Scoped Configurations in 2019
Continuing the tradition that I started with Sql Server 2016 and the original appearance of the Database Scoped Configurations (an incredible feature, I have to repeat) and that last year precisely in January I have blogged about the Database Scoped…
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…
In-Memory, Quo Vadis ?
In-Memory is dead, Long Live the In-Memory! In SQL Server 2019 without that much deserved fanfare (for me at least), Microsoft has released a couple of improvements that made me think about the current status (was apparently almost dead) and…