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