SQL Server: Upgrading and Migrating to SQL Server 2016
This course will teach you how to correctly prepare for and perform an upgrade/migration to SQL Server 2016. You'll learn how to plan considerations, tools for finding upgrade blockers, and various methods for moving the data.
What you'll learn
When moving to a new version of SQL Server, it's important to plan and test the upgrade process and use a risk-free migration approach that limits application downtime. In this course, SQL Server: Upgrading and Migrating to SQL Server 2016, you'll learn how to do all of these things. First, you'll discover how to choose the correct Edition of SQL Server 2016, install it correctly, and how to use various tools to find upgrade blockers and breaking changes. Next, you'll explore some of the ways to make a migration go more quickly and find problems after the migration. Finally, you'll learn the methods available for migrating databases to SQL Server 2016. When you've finished with this course, you'll have the skills and knowledge needed to plan and execute an upgrade/migration to SQL Server 2016 successfully.
Table of contents
- Introduction and SQL Server 2016 Editions 2m
- SQL Server 2016 License Differences and Limits 3m
- Key Performance Differences and Examples 2m
- Demo: Columnstore Index Performance Differences 3m
- Feature Differences and Key New Features in SQL Server 2016 2m
- Demo: Query Store 2m
- Demo: Database Scoped Configurations 3m
- Hardware Selection Planning and Resources 3m
- Storage Upgrade Opportunity, Storage Choices, and Module Summary 3m
- Introduction and Correctly Preparing the Server 2m
- Install and Patch Windows Server 2016 1m
- Correctly Installing and Configuring SQL Server 2016 2m
- Selecting Which Features to Install 1m
- Finding Upgrade Issues and System Configuration Checker 2m
- Demo: Installing SQL Server 2016 5m
- Breaking Changes in SQL Server 2016 and Data Migration Assistant 1m
- Demo: Microsoft Data Migration Assistant 3m
- Application Testing and Module Summary 2m
- Introduction and Making the Migration Smoother and Quicker 4m
- Cleanup the Legacy Databases 2m
- SQL Server Backup Compression and Striped Backups 2m
- Demo: Using Backup Compression 3m
- Demo: Using Striped Backups 3m
- Instant File Initialization and Local Group Policy Editor 2m
- Demo: Database Instant File Initialization 2m
- File Copy Methods and Considerations 2m
- Demo: Microsoft RoboCopy 2m
- Migration Planning Summary and Module Summary 1m
- Introduction and Microsoft Database Experimentation Assistant 2m
- Post-migration Steps and Checking for Performance Regressions 2m
- Demo: Using DMV Queries to Compare Performance 3m
- Demo: Using Query Store to Find Performance Regressions 2m
- Mitigating Performance Regressions 2m
- Alter Database Scoped Configuration 1m
- Cardinality Estimation Issues and Query Tuning 2m
- Demo: Query Store Plan Forcing 3m
- Other Key Configuration Issues and Module Summary 2m
- Introduction and Upgrade in Place 3m
- Demo: Upgrade in Place 3m
- Side-by-Side Installation 2m
- Demo: Side-by-Side Installation 5m
- Detach/attach 1m
- Demo: Detach/attach 2m
- Backup/restore 1m
- Demo: Backup/restore 3m
- Using Log Shipping for Migration 2m
- Demo: Using Log Shipping for Migration 4m
- Using Database Mirroring for Migration 2m
- Demo: Using Database Mirroring for Migration 3m
- Post-migration Tasks 1m
- Demo: Post-migration Tasks 2m
- Module and Course Summaries, Next Steps, and Resources 4m
About the author
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher P... more