Installing SQL Server 2019 on Azure VM

Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below:

  • Windows 2016 +
  • Red Hat 7.3-7.6
  • SUSE v12 SP2+
  • Ubuntu 1.8

So, I am going to use my clicking skills and spin a Machine up in Azure utilizing the market place, so I can get an image of SQL Server installed on the VM already.

sqlimages

Once you have selected the image you want you will get routed to the create a virtual machine page.

sqliias

I noticed the Azure spot option, with this you can take advantage of our unused capacity at a significant cost savings. At any point in time when Azure needs the capacity back, the Azure infrastructure will evict Spot VMs. Therefore, Spot VMs are great for workloads that can handle interruptions like batch processing jobs, dev/test environments etc. That’s quite cool.

When it comes to sizing there are so many choices. You are probably best advised to select based on the family type you require.

whatsize

Obviously, I am going for General Purpose here but let’s look at the specs and cost of the more powerful ones, because I am curious. So, the M128-32ms VM size, a cool £23k / month.

highcosts

Next is disk setup where I opt for managed disks. What are managed disks? Why do I like them? Ultimately it simplifies disk management whilst having a vast choice of types to select from including Premium / standard SSDs to standard HDDs.

managedisks

Networking configuration should be done with network admins, so you are placing the VM in the correct subnet ranges etc.

NICs

Management section, I tend not to change too much here, just the auto shut down rules for dev machines really.

autosh

In the advanced section there are section about proximity placement groups and host groups. Check this link out for more details. https://azure.microsoft.com/en-ca/blog/introducing-proximity-placement-groups/

The Security section is quite self-explanatory.

sqlauth

Thats it – Before you create the machine grab the templates – JSON files for future deployments.

1 thought on “Installing SQL Server 2019 on Azure VM

  1. Pingback: Dew Drop – April 28, 2020 (#3185) | Morning Dew

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 )

Google photo

You are commenting using your Google 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