Kalen Delaney SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help... 07 December 2017 2 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need to preserve the existing data... 09 March 2016 34 min read
Artemakis Artemiou Introducing SQL Server In-Memory OLTP In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload, it then had certain restrictions... 30 September 2015 10 min read
Tony Davis Questions About SQL Server Transaction Log You Were Too Shy To Ask You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience will stare awkwardly at their... 11 February 2015 26 min read
Feodor Georgiev Curing Data-Obesity in OLTP Databases OLTP databases work best when data that becomes no longer current is then transferred to a separate database for analysis and reporting. There are many... 06 February 2015 13 min read
Jonathan Watts The Promise – and the Pitfalls – of In-Memory OLTP When SQL Server 2014 was released, it included Hekaton, Microsoft's much talked about memory-optimized engine that brings In-Memory OLTP into play. With memory-optimized tables 30... 04 February 2015 7 min read
Kalen Delaney Hekaton in 1000 Words The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is a radical change for relational databases. This article, an exerpt from Kalen Delaney's book "SQL... 22 October 2014 6 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables... 25 June 2013 12 min read
Database Administration Fabiano Amorim in Database Administration Statistics on Ascending Columns It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most... 01 September 2011 10 min read
