Azure Classroom series – 30/Apr/2020

DTU vs vCore

• Refer Here for understanding vCore vs DTU
• For using DTU’s azure recommends users to use the calculator as mentioned over here
• vCore is all about choosing custom CPU and storage unlike DTU.
• In vCore we have two compute tiers
  • Provisioned:
    • Guaranteed Speed/Performance consistently so use this for databases which are used all the time
  • Serverless:
    • Use this for inconsistenly used datbases, Can save the bills if your database is not consistently used throughout the data

Reservations

• Microsoft further reduces the bills for reservations, you can give a commitment to use a database for 1 or 3 years and you can save a lot of amount. Refer Here

Azure CLI To create SQL Server

• Launch Cloudshell ]
• If you are creating cloud shell for first time, you will observe a prompt for storage creation and create it
• Select Bash for this exercise, but Azure cli works in powershell also
• Now create a SQL Server from Azure CLI following this document

Azure Powershell to Create SQL Server

• Launch Cloudshell ]
• If you are creating cloud shell for first time, you will observe a prompt for storage creation and create it
• Select Powershell for this exercise
• Now Create a SQL Server from Azure Powershell following this document