November 2017
Intermediate to advanced
276 pages
7h 6m
English
Content preview from Learning Microsoft Azure Storage
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,
Start your free trial
Creating an Azure SQL Database using the Azure CLI 2.0
To create an Azure SQL Database using the Azure CLI 2.0, we have to create an Azure SQL Server first, which can be done by running the following command:
az sql server create --name packtpubsqlcli --resource-group PacktPub --location westeurope --admin-user “SQL Admin User” --admin-password “SQL Admin Password”
Then, the following command will be run to create the database:
az sql db create --resource-group PacktPub --server packtpubsqlcli --name PacktPubDBCLI --service-objective S3 --collation SQL_Latin1_General_CP1_CI_AS
When you create an Azure SQL Server via the Azure CLI 2.0, access from other Azure services to that SQL Server is not allowed by default.