Azure – IAAS + SQL

Hi there

in this article I’ll demonstrate how to spin up a SQL server 2019 Standard version on Azure IAAS on a standard VM (Windows 2019 from marketplace).

Setup your environment

I used this Terraform main.tf 

Quick review

  1. download Terraform from https://www.terraform.io/downloads.html
  2. edit your Windows PATH variable to point to your terraform main folder (I have a main folder for Azure deployments with a folder on C:\TERRAFORM\ where I extract my Terraform downloaded file into)
  3. quick commands
    1. az login
    2. terraform init
    3. terraform plan -out myplanName
    4. terraform apply myplanName
    5. follow up your console output to check for any warnings, errors and its deployment
    6. terraform destroy

Today’s challenge is: Add a data disk to the SQL vm

Let’s work on this on github repository

download SQL trial from https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019 to continue your SQL on IAAS setup.

Check my Github repository

Reference

Thanks,

Thiago Beier
TwitterLinkedInFacebookRSS