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

SEARCH BY TAGS: 

Please reload

RECENT POSTS: 

FOLLOW ME:

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

Powershell: Create Azure SQL Database

September 19, 2017

 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. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Share on Facebook
Share on Twitter
Please reload