SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DB developer focused session, we discuss the new memory-optimized tables and indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.
William Emmert, Technical Director/Technology Architect, Microsoft Technology Center, Microsoft Corporation
Technical Director and SQL\BI Architect in the Philadelphia Microsoft Technology Center (MTC) in Malvern, PA. He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he joined the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC in 2011.
Bill has worked in the computer industry for 28 years with experiences in mainframe software support & development, network architecture and administration, client server application development, project management, consulting, IT management and database administration, development and architecture.
He has a bachelor’s of Business Administration in Marketing from Adelphi University (NY) and a Master’s of Science in Information Systems from Penn State University (PA).