Provisioning and configuring an Azure SQL database

In this demonstration, we are going to create and configure an Azure SQL database. You can create the database from the Azure portal, PowerShell, CLI, and ARM templates, and by using the .NET libraries. In this demonstration, we are going to create a single database in the Azure portal. Therefore, we need to take the following steps:

  1. Navigate to the Azure portal by opening https://portal.azure.com.
  2. Click Create a resource, type SQL Database in the search bar, and create a new database server.
  1. Add the following values:
    1. Subscription: Pick a subscription.
    2. Resource group: Create a new one, and call it PacktSQLResourceGroup.
    3. Database name: PacktSql.
    4. Server: Create a new one, and add the following values:
      1. Server name: packtsqlserver
      2. Server admin login: PacktAdmin
      3. Password: P@ss@word123
      4. Location: East US
    5. Want to use SQL elastic pool: No, we are going to use a single database.
    6. Compute + storage: Keep the default setting here. 
  2. Click Review + create, and then Create.
  3. The database is now being created. 

Now that we have created the database, we can configure a server-level firewall rule. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset