We previously copied a BACPAC to our Azure storage. Now, we'll import it into the newly created server. From the Azure portal, go to the Azure SQL servers blade; we now see our newly created SQL Server, as shown in the following screenshot:

When we click on it, the adfv2book blade opens. In the top-middle of it, we click on the Import database icon, as shown in the following screenshot:

This brings us to the import blade. Select the adfv2book storage account and navigate to the database-bacpac blob. Select WideWorldImporters-Standard.bacpac and click Select.

Now, select the Pin to dashboard option and click on Select to restore the BACPAC, as shown in the following screenshot:

Now, back to the SQL servers blade, we'll click on the Firewall / Virtual Networks icon at the left to open the server firewall blade. As show in the following screenshot, we click on Add client IP to whitelist our network and therefore be able to query the server's databases. Once our IP is added, we click Save to keep it:

To query the database easily, we'll use SSMS. This program is available freely from Microsoft at the following URL: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.

Choose the latest version (17.5 at time of writing), download, and install it. Once installed, start SSMS and connect to the server in Azure. Once done, we expand the databases node and we can query tables as shown in the following screenshot: