SQL Server 2016 has made significant investment In-Memory OLTP technology introduced in SQL Server 2014. This talk provides an overview of the In-Memory technology and the common use cases. We then take an in-depth look at the new changes in SQL Server 2016 such as increased TSQL surface area for native procedures, storage scalability and the common maintenance operations.
Seasoned professional with 30+ years of industry experience in databases. He has worked as developer/lead building relational database engine technology, as a tool designer/lead building backup/restore tools, as an application developer/manager enabling B2B commerce as e-learning, and now as a principal program manager for SQL Server for the last 13+ years. He currently works in SQL Server Tiger Team. He has led some key features/technology such as columnstore indexes, In-Memory OLTP, AlwaysON, Data Compression and concurrency related changes over the past several releases of SQL Server. Experienced in leading development teams both for in-house and offshore engagements. Equally at ease both with drill-down discussion with engineers as well as working with customers and partners. He has authored many technical white papers/blogs, co-authored two books in SQL Server and has presented database technologies in numerous national/international conferences. Sunil enjoys teaching and has taught programming courses at University of Rhode Island and University of Colorado.