Migrating Applications to the Cloud with Azure

Using your database in the portal

It's time to start using our Azure SQL instance. Find your SQL databases in the Azure portal and go to the Query editor (which is in preview at the time of writing). You'll need to log in using the admin user and password that you used when creating the server. Using Active Directory Single Sign-On (AD SSO) is supported, but is not in the scope of this chapter. Once you're logged in, you can create, save, open, and run queries, and you can edit data. The first thing we're going to do here is run a query to create a table. So, run the following query:

CREATE TABLE dbo.Person(  Id int NOT NULL IDENTITY (1, 1),  FirstName nvarchar(255) NOT NULL,  LastName nvarchar(255) NOT NULL,  PRIMARY KEY (Id))

If you're used ...