SQL Virtual Machines

Leave a comment

October 22, 2020 by Kenneth Fisher

I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) and among the many cool things they discussed is the fact that a virtual machine with SQL Server installed can be handled differently in the portal than just a normal virtual machine. Here are some of the things that you can currently do through the portal (remember, this is the cloud so things change almost daily):

  • View properties. i.e. Version, edition, and license type.
  • Free space on your data drive.
  • Enable/disable SQL authentication and Azure key vault integration.
  • Some automated patching.
  • Database backups.
  • High availability (in preview).

When you create an Azure VM using one of the templates that already has SQL Server installed it will automatically be added to the SQL virtual machines list.

That said, if you install SQL on a VM yourself or have an older VM that you want to register it’s not overly difficult. You can see the instructions here.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,975 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013