Today I want to touch on rather obscure and unfairly under appreciated features in Sql Server – Hekaton (aka In-Memory) and Database Snapshots. Database Snapshots can serve for so many great purposes, such as Quick Restores and DWH/BI/Reporting reading operations,…
This time I would like to write about Transparent Data Encryption (TDE) and more specifically a new feature that is available in Sql Server 2019 and as a Azure SQL Database. The already announced and available feature is called Resumable…
The upcoming release of Sql Server 2019 which is largely expected to take place during PASS Summit 2019 & Ignite 2019 simultaneously (and given that Rohan Kumar (Microsoft VP) seems to be present only at the PASS Summit, I am…
Continuation from the previous 128 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I would like to point the compatibilities with the immediately upcoming release of Sql Server 2019 and the Columnstore Indexes. In the…
20+ years ago I have discovered something something important about how I see people giving permissions to other people being themselves (André Hamaoka, if you are reading this post – this is a logical continuation of our long conversation last…