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
SQL Server 2019: Feature Restrictions
UPDATE 2020-02-28: It looks that by RTM this feature has been disabled, check out blog by Solomon Rutzky for more information. With the release of the Sql Server 2019 CTP 3.2 we have received a new SECURITY feature, that is…
Batch Mode – part 5 (“TPC-H Queries”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. With the appearance of the CTP 3.2 of the Sql Server 2019 and being almost a year of…
SQL Graph, part VI – Closeness Centrality
This is the 6th blog post in the growing series of blogpost on the Graph features within SQL Server and Azure SQL Database that started at SQL Graph, part I. This time I want to focus on one of the…
SQL Graph, part V – Shortest Path
This is the 5th blog post in the growing series of blogpost on the Graph features within SQL Server and Azure SQL Database that started at SQL Graph, part I. This time we are focusing on the one of the…