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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: