SQL Azure Database Manager – Part 2 : Now you’re in, take a tour

Posted by on Comments (0)

This is the second part of the SQL Azure Database Manager series. The first part is here.

So, now you're connected to your database by using the SQL Azure Database Manager.

Here is the detailed interface provided :

 

The different parts of the interface are :

A toolbar :

Here from the Database toolbar, you can have access to the most common tasks that I'll explain gradually.

Note that on the top of the toolbar, I've a small buttons panel. The second button will change depending on the content currently loaded in the designer/editor view.

In the case I'm working on a table with the table designer, the buttons will then be Database and Table :

In the case I'm working on a view with the view designer, the buttons will then be Database and View :

So you understood that the second button will be contextualized. And by clicking the first one, you can come back to the Database Toolbar.

A navigation pane :

This is where you'll find your Tables, Views and Stored Procedures.

This is an accordion control, so you can choose the detail to deploy.

At the top of the pane is a filter text box. So if I type the term Stored, here will be the filtered result of the previous snapshot: 

 

The editor/designer view.

This is a multi-tab view where you will :

  • Design your tables.
  • Edit your data.
  • Edit/Run your queries.
  • Edit your stored procedures.
  • Edit your views.

The start page show information (inside a beautiful cube) about your database like the status, the collation, the compatibility level, …

And if you turn the cube, you'll have a 3D chart displaying the data storage used.

The status bar

In the status bar, you'll find information about: the server FQN & the database you're connected to, the user you're logged in and a support ID.

You can logout from the SQL Azure Database Manager by using the small upper right link.

More to come in the next part! :)

Posted in: Windows Azure | SQL Azure   Tags:

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading