No tags yet.

SEARCH BY TAGS: 

RECENT POSTS: 

FOLLOW ME:

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle

Powershell: Create Azure SQL Database


While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database.

The first step allows you to login to your Azure account. It gives you a neat little prompt.

Once logged in, the powershell window will provide you with some information regarding your subscription.

The next two commands sections provide a way to list your subscriptions and then select the one that you want to use. In my case, I only have one subscription and thus it's my default.

The final section of the script creates the database in the server and resource group of my choosing. I decided to use the ones that I had already created. If you want to utilize powershell to create new resource groups and servers look into the New-AzureRmSqlServer cmdlet.

#azure #cloud #sqlserver #powershell