Creating the Azure SQL Database
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access