Explore a customer's journey of migrating to SQL Server 2016 and leveraging Column Store technology in this 50-minute PASS Data Community Summit presentation. Dive into the business scenario, initial challenges, and migration strategies, including best practices for transitioning to SQL Server. Learn about partitioning differences, data loading audits, and the nuances of various index types such as Non-Clustered Index (Rowstore), Deltastore, and Clustered Columstore Index. Examine the changes made to the SQL 2016 database and server, compare traditional data warehouse design with new approaches, and analyze test results. Gain insights into future considerations and key takeaways for successful implementation of Column Store in SQL Server 2016.