Time: 6:00~8:00PM Jan 27, 2014 Monday. Pizza time start at 5:30. It’s free, please RSVP
In Memory OLTP System Deep Dive
In Memory OLTP (a.k.a. Hekaton), is a new component introduced for SQL Server 2014. It can provide a 20 to 100 times speed improvement to your SQL Server systems. In this 2-hour session, we will overview SQL Server 2014 In Memory OLTP system, deep dive into internals of Hash indexes and BW- trees (the in memory data structure), discuss Hekaton concurrency controls and limitations, and explore Hekaton’s programmability, manageability and integration with other features.
About Our Speaker
John Huang is a Vancouver based independent SQL Server consultant specializing in complex data processing, data warehouse, distributed system design, performance tuning and database administration. He has been using SQL Server since 1994. He obtained his SQL MCM/MCSM certification in 2009 and received Microsoft SQL MVP award since 2011. He speaks at many events, local PASS chapters, global virtual chapters, DevTeach, TechFest, TechDays, and SQL Saturdays in many cities.