In this episode of Data Exposed, Scott Welcomes Ken Van Hyning, a Principle Software Engineer in the SQL Server team. Today Ken introduces us to the SQL Server 2016 Upgrade Advisor, code named DBA Workbench, a tool that consists of a suite of advisors for upgrading to SQL Server 2016. Ken begins by walking us through a high-level upgrade workflow to help us put the process in perspective by breaking down the upgrade process.
Ken then introduces us to the SQL Server 2016 Upgrade Advisor, a single consistent tool that contains three categories of advisors: Upgrade, New Features, and Best Practices, with an extensibility option to add new scenarios over time. Ken explains that the goal of this tool is consistency to help customers get to the information they need quickly.
From there, Ken quickly jumps into several demos showcasing the Database Upgrade Analyzer to show the process of analyzing and upgrading. A really neat feature that Ken shows off is how much they invested in analysis results and recommendations to help people really understand the rules during an upgrade process.