Azure SQL Database Web & Business Migration Recommendations


In this episode of Data Exposed, Scott welcomes Veljko Vasic, Program Manager on the SQL Server team. Today, Veljko shows us an exciting new feature in the Azure preview portal that provides recommendations when migrating from a Web and Business edition Azure SQL Database to the new V12 service tiers of Basic, Standard, and Premium. The challenge with migrating from a Web and Business edition is which pricing tier to select in the new service model, and Veljko shows us that in just a few clicks we can get an appropriate recommendation based on previous database usage. Veljko shows us the plethora of information provided in the portal, such as information that compares current usage with recommended pricing tiers. Veljko wraps up the demo by walking us through the upgrade and recommendation process using both the preview portal as well as PowerShell. Very powerful and useful if you are currently Web and Business editions and are considering moving to the new service tiers and are wondering which one to select to give you the appropriate performance.


Source link

, , , , , , , ,