Completed
Migration Challenges
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Winning with Column Store in SQL Server 2016 - A Customer Story
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Technical Assistance
- 3 SQL Server Migration Assistant (SSMA)
- 4 Business Scenario Graphic
- 5 Initial Situation
- 6 Migration Challenges
- 7 Dealing with Partitioning Differences
- 8 Best Practices for Migrating to SQL Server
- 9 Data Loading Audit Report
- 10 NCI: Non-Clustered Index (Rowstore)
- 11 Deltastore Basics
- 12 CCI: Clustered Columstore Index
- 13 Index Compatibility
- 14 Initial Changes to SQL 2016 Database / Server
- 15 Changes on SQL 2016 Side
- 16 Traditional DW Design
- 17 Fact Table
- 18 Related Tables
- 19 The Contestants
- 20 Test Results
- 21 Future Considerations
- 22 Summary
