Speaker:

Michael Zwilling

Date:

Thu Sep 25, 2014 @ 12:00pm EDT

Date:

Thu Sep 25, 2014

Time:

12:00pm EDT

Location:

CIC - 4th floor (ISTC Panther Hollow Room)

Title:

Microsoft SQL Server's In-Memory OLTP Architecture and Capabilities

System:

SQL Server

Video:

YouTube

---

Talk Info:

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.

Part of the “Seven Databases in Seven Weeks” Seminar Series: http://db.cs.cmu.edu/seminar2014

Bio:

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.

More Info: http://www.pdl.cmu.edu/SDI/2014/092514.html

---