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
-
After Installation:
- Launch a Terminal (Powershell/Bash) and execute
az --version
- Launch a Terminal (Powershell/Bash) and execute
-
Approach for CLI:
- Know the steps using portal
- For each step find the command which can be used from azure cli
-
Steps for creating Azure SQL Database
- Create a Resource Group => Note down parameter
- Then Create an Azure SQL Server => Note down parameters
- 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)