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,…
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…
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…