SQL Server in an Azure VM – What’s New | Data Exposed

This post has been republished via RSS; it originally appeared at: Channel 9.

It is a pleasure to have Luis Vargas back on the show to show us what's new with SQL Server in an Azure Virtual Machine since the last time he was here 10 months ago.

No slides and all demo as Luis first provides a quick overview of the available SQL Server offering in Azure Virtual Machines via Azure Marketplace. He shows all the different SQL Server VM images of versions and editions in the gallery, including SQL Server 2016 SP1 Express and Developer as well as SQL Server vNext on Red Hat Enterprise Linux!

Luis also spends a minute showing the BYOL (Bring Your Own License) templates and discusses options as to when those would be useful.

At the [10:15] mark Luis walks us through the creation of a SQL Server 2016 SP1 virtual machine to highlight the new and improved features available, including monitoring of OS diagnostics, automated backups and patching with scheduling, and storage configuration and optimization for optimum performance!

At the [32:00] mark Luis shows off the cool feature of being able to download the configuration template of your configuration which can be used to automate the creation and deployment of the virtual machines. VERY cool.

Luis wraps up the show showing auto-shutdown to automatically stop VMs when not used to save money. He then shows how easy it is to connect to the SQL VM via SSMS.

Great show, and we look forward to having Luis back to discuss High Availability!