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…
Memory-Optimized TempDB Metadata
Besides In-Memory being declared by many people as a “dead feature”, it looks like Sql Server is bringing some stuff into the game, steadily improving the feature and integrating it with Microsoft is introducing something really daring in The feature…
Sql Server 2019 Supports Database Snapshots with In-Memory Filegroups
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,…
Sql Server 2019 Standard Edition Changes (Yeah, TDE-ah!)
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…
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…