As the continuation of the tradition, started 5 years ago, each year I will be continuing tracing the changes taking place in Database Scoped Configurations. Database Scoped Configurations in the year 2020 We did not have any new major product…
Striping Backups to Azure Blob Storage
I love Azure Blob Storage. It is a great source for the Data Disks for the Azure VMs (IaaS), Data Files for Azure SQL Database Managed Instance and of course for the key things that guarantees the business running –…
Columnstore Indexes – part 131 (“Rebuilding Rowstore Indexes ONLINE”)
Continuation from the previous 130 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost will be about older SQL Server versions (2016, 2017) and some implications that I have found that people rather do not understand, until they…
Database Scoped Configurations in 2019
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…
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,…