DATE: Thursday, September 25, 2014
TIME: Noon - 1:00 pm
PLACE: RMCIC 4th Floor Panther Hollow Room

SPEAKER: Mike Zwilling, Microsoft, Hekaton

TITLE: Microsoft SQL Server’s In-Memory OLTP Architecture and Capabilities

In-Memory OLTP (formerly known as Hekaton) is a key feature in the In-Memory offerings of Microsoft’s SQL Server 2014 product. In this talk we will discuss the hardware trends, user scenarios, and history that prompted its key architectural pillars of main-memory optimization, lock/latch-free concurrency control and SQL compilation to native code, as well as how the technology is integrated into SQL Server. Along the way we will discuss some the myths around the technology, how customers are using it, and how it and column-store technology are influencing the evolution of SQL Server.

Mike Zwilling is a partner architect in Microsoft's Database Platform Group working on high performance in-memory transaction processing technology for SQL Server - aka Hekaton. The Hekaton project derives from technology developed by an advanced development team Mike led for 18 months exploring how SQL Server should adapt to hardware changes such as many-core, large main memories, non-volatile RAM, etc. Before that Mike, was the development manager for teams covering storage, transactions, recovery, security and transactional messaging in SQL Server. Mike joined Microsoft as a developer in the SQL Server product team in 1995, to work on the SQL Server 7.0 product where he had the opportunity to implement major components of the database storage engine. Prior to joining Microsoft, he worked in the database research group at the University of Wisconsin, developing database storage engines that formed the foundations of research projects (EXODUS and SHORE) and were incorporated into commercial products. He holds a Master of Computer Science degree from the University of Wisconsin - Madison and a Bachelor of Science from Purdue University - Indianapolis.

VISITOR COORDINATOR: Samantha Dinardo,, 8-7660

Karen Lindenfelser, 86716, or visit

*partially funded by

A joint seminar with MCDS.