A Gentle Introduction to In-Memory OLTP in SQL Server 2014
With the release of SQL Server 2014, Microsoft has introduced a new relational technology as part of the SQL Server database engine. Their ACID-compliant, in-memory relational solution (code-named Hekaton, now known as In-Memory OLTP) promises up to a 30-fold improvement in transactional throughput in comparison to the current database engine. This talk will walk through In-Memory OLTP from the standpoint of a database developer implementing the solution, and show both the promise and the "version 1.0" problems with this product.
Kevin Feasel is a database engineer at ChannelAdvisor, where he specializes in database design, performance tuning, and pulling rabbits out of hats on demand. He can be found cycling the trails of the Research Triangle whenever the weather's nice enough.