This whitepaper illustrates the SQL Server 2016 business intelligence/data warehouse upgrades, the memory-optimized tables, and the columnstore indexes. We also discuss the performance comparison of in-memory tables and columnstore indexes and outline how to do a performance comparison with Azure. Finally, we conclude by examining the performance comparison caveats.