Search This Blog & Web

Tuesday, March 12, 2013

Working with SQL Azure Management Portal

In previous posts we have installed and connect our Azure database using Azure Management portal and SQL Server Management Studio.

In this post we will how can we perform SQL related tasks on Azure Management Portal

Connect Azure database Management portal using your credentials

Database Overview

Querying your tables

Creating table using Azure portal. every table must have Primary Key Index

Creating Indexes and Keys

Looking at your table data

Querying your data. Look at the left panel and you will see recently history.

Looking at the execution Plan screen 1

Looking at the execution Plan screen 2 (Graphical Execution Plan)

Your recent work history shows in tabs as database dashboard

Running store procedure

No comments: