To create a new Azure SQL Database, we need to provide a standard set of information such as Database name, Subscription, and Resource group. Additional information is specific to Azure SQL Database; we need to Select source, provide Server, and Pricing tier. There is the option to select whether we want to use SQL elastic pool? which is directly connected to the Pricing tier, and we'll get to that in a moment. For the database source, we can select blank (empty database), sample (AdventureWorkLT, standard Microsoft sample database), and from backup (if this option is selected, we need to provide the storage information of where the backup is located).
The Collation of the database is always SQL_Latin1_General_CP1_CI_AS ...
