Azure SQL Elastic Pools

• SQL Elastic Pool is a cost effecitve simple solution for managing the multiple databases.
• The SQL Databases in elastic pool will be on one Azure SQL Server and share resources at a fixed price.
• For more info

Azure CLI

• Azure CLI is a command line approach to use Azure, It enables automation.

• Azure CLI is developed to be executed from any platform

  • Windows
  • Mac
  • Linux

• Installing Azure CLI

  • Windows
  • MAC
  • Ubuntu, RedHat Others

• After Installation:

  • Launch a Terminal (Powershell/Bash) and execute az --version

• Approach for CLI:

  1. Know the steps using portal
  2. For each step find the command which can be used from azure cli

• Steps for creating Azure SQL Database

  1. Create a Resource Group => Note down parameter
  2. Then Create an Azure SQL Server => Note down parameters
  3. Then Create an Azure SQL Database => Note down parameters

• Now Navigate to here and Expand Reference

• Now find the command to create Resource Groups

az login
az group create --name sqlserverdemo --location 'centralus'

• Now find the command to create SQL Server

az sql server create --location 'centralus' --resource-group 'sqlserverdemo' --name 'qtsqlserverdemo' --admin-user qtdevops --admin-password admin@123

• Following sections are exercises
• Now find the commmand to create SQL Database
• Update the Database with any possible parameter
• Find the command for geo-replication
• Now find the command to delete all you have created (hint: delete the whole resource group)