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…
Accelerated Database Recovery
Batch Mode – part 4 (“Some of the limitations”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. This post will focus on some of the initial limitations of the Batch Execution Mode on the Rowstore…
Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Since the very first version of the Columnstore Indexes in 2012, there has been no support for LOB (large objects binaries). The reason behind not focusing…
Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)
Continuation from the previous 89 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focusing on a very important improvement to the limitation of the In-Memory Columnstore Indexes that was existing in SQL Server 2016, but…
SQL Server 2016 SP1 – Programmability Surface for everyone!
This is the most important blog post about SQL Server that I have ever written. As far as I am concerned this is the most epic moment in the history of the SQL Server since its inception (yeah, you could…