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…
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…
Resumable Transparent Data Encryption (TDE) Scan
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…
Columnstore Indexes – part 129 (“Compatibility with the New Features of Sql Server 2019”)
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…
Accelerated Database Recovery
If you remember yourself being a new kid on the block to the databases and the concept of the transaction and rollback, or if you have ever worked or working with the people who are new to the principles and…