SQL Server upgrade process could be challenging especially in environments that hold mission critical applications or have complex highly available configurations. Understanding the technical steps, planning, testing and analysing the result is critical for a successful upgrade, which is the one that switches the environments with minimal downtime and no data loss. The class teaches the attendees how to go through all the migration steps no matter how complex the SQL Server environment could be and how to achieve a performant SQL Server at the end

• Solution Architects, consultants and IT professionals who want to gain knowledge necessary to make architectural decisions in SQL Server Platform.
• DBAs who are responsible for planning and implementing SQL Server Upgrades.

• Plan the SQL Server Upgrade for complex, mission critical environments
• Perform proper assessments and plan for pre-upgrade actions
• Build deployment plans for production migration
• Understand how to migrate different SQL Server configurations with minimal downtime
• Perform all the post-upgrade tasks required for building performant environment and a sucesful migration

Module 1. Planning for an upgrade

Module 2. Upgrade assessment

Module 3. Upgrade methodologies – In-Place, Side by Side, Migration, moving to Azure Cloud

Module 4. Instance Services Upgrades

Module 5. Considerations for patching

Module 7. Choosing an upgrade strategy

Module 8. Performing production upgrades

Module 9. Post-upgrade tasks

Upgrading SQL Server Solutions