Learning Microsoft Azure

Managing SQL Azure Servers and databases

Although we've just built our database using EF Code First Migrations, we still need to be able to view and sometimes modify our data and also perform activities such as adding users or creating federations.

To do this, we have a number of tools available:

• The SQL management portal
• SQL Server Management Studio (SSMS)
• Visual Studio SQL Server Object Explorer
• The PowerShell console

Managing a database through the portal

We're going to take a look at managing a database through the management portal:

1. In the database workspace, select the database we just created and click on MANAGE on the bottom toolbar:
   
2. We should see ...