Creating Database Server

• Go to: https://portal.azure.com/#create/Microsoft.AzureSQL
• SQL databases > Resource type: Database Server (direct link: https://portal.azure.com/#create/Microsoft.SQLServer)
• Fillup details
• Create

Creating Single Database

• Go to: https://portal.azure.com/#create/Microsoft.AzureSQL
• SQL databases > Resource type: Single Database (direct link: https://portal.azure.com/#create/Microsoft.SQLDatabase)
• Fillup details
• Create
• Note: if you use “sample” for “use existing data”, then AdventureWorksLTS data will be used to fillup your newly created databases

Creating Elastic Pool

• Go to: https://portal.azure.com/#create/Microsoft.AzureSQL
• SQL databases > Resource type: Elastic Pool (direct link: https://portal.azure.com/#create/Microsoft.SQLElasticDatabasePool)
• Fillup details
• Create

Adding Database to Elastic Pool

• Select Elastic Pool
• Add database
• Fillup details > Create

Adding Existing Database to Elastic Pool

• Select Elastic Pool
• Configuration > Databases
• Add databases > Select databases
• Apply
• Save (don’t forget to save)