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.
Winning with Column Store in SQL Server 2016 - A Customer Story
PASS Data Community Summit via YouTube
Overview
Syllabus
Intro
Technical Assistance
SQL Server Migration Assistant (SSMA)
Business Scenario Graphic
Initial Situation
Migration Challenges
Dealing with Partitioning Differences
Best Practices for Migrating to SQL Server
Data Loading Audit Report
NCI: Non-Clustered Index (Rowstore)
Deltastore Basics
CCI: Clustered Columstore Index
Index Compatibility
Initial Changes to SQL 2016 Database / Server
Changes on SQL 2016 Side
Traditional DW Design
Fact Table
Related Tables
The Contestants
Test Results
Future Considerations
Summary
Taught by
PASS Data Community Summit
