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 –…
Continuation from the previous 130 parts, the whole series can be found at http://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…
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…
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,…
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…