Sunil Agarwal is a Principal Program Manager in SQL Server Storage Engine Group for the last 12 years. Prior to joining Microsoft, Sunil had worked at Digital Equipment Corp, Sybase, BMC Software, Asera and at DigitalThink with primary focus on core database engine technology and related applications. Sunil holds a BS in Electrical Engineering from IIT, Kanpur, India, and has done graduate work in Computer Science at University of Rhode Island and at Brown University
In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance.
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database