Continuing our work on Azure SQL Database management, over this weekend we released a new version of Cloud Portam. In this release we included support for managing elastic database pools and some other enhancements. In the previous releases, we included support for managing database servers and databases. In this blog post we will talk about the features we released and our immediate roadmap.

In order to manage SQL Databases in Cloud Portam, first you would need to add the Azure Subscription account. Please see this blog post to get started with adding an Azure Subscription in Cloud Portam:http://blog.cloudportam.com/cloud-portam-updates-announcing-the-availability-of-azure-subscription-management-in-cloud-portam/.

Summary of Enhancements

In this release we included the following enhancements:

Elastic Database Pool Features

  • List elastic database pools in a database server.
  • Create new elastic database pool.
  • Delete elastic database pools.
  • Add databases to elastic pool.
  • View/remove databases from elastic pool.
  • View elastic database pool properties.
  • Change elastic database pool DTU.
  • Manage elastic database pool tags.
  • View permissions on elastic database pool.
  • Manage locks on elastic database pool.

Database Enhancements

  • Add one or more databases to elastic database pool.

Storage Queue Enhancements

  • Viewing message contents inline.

 

Now let’s talk about these enhancements in more details.

Elastic Database Pool Features

List Elastic Database Pools

In order to list elastic database pools in a database server, simply click on the “Elastic Pools” link in the row for database server as shown below.

SNAGHTML4e38d944

You will then see all the elastic database pools in that database server.

image

When listing pools, Cloud Portam shows you information like elastic database pool edition (Basic, Standard or Premium), pool eDTU, eDTU setting / database, and storage size.

Create New Elastic Database Pool

Cloud Portam enables you to create a new elastic database pool in the database server. Creation of an elastic database pool is controlled by Role-based access control (RBAC) thus you will only be able to create an elastic database pool if you have permission to do so.

From the elastic database pools dashboard, there are three ways by which you can initiate creation of a new elastic database pool as shown below.

image

Creating new elastic database pool been extensively covered in our previous blog post and I would highly recommend reading about them there.

Another thing I want to mention is that creation of an elastic database pool is an asynchronous process. So when you create an elastic database pool using Cloud Portam, Azure accepts the request and queues it. So it may take a little while for the new elastic database pool to show up in the list of elastic database pools.

image

 

Delete Elastic Database Pools

Cloud Portam enables you to delete one or more elastic database pools from your Azure Subscription.

Please note that deleting an elastic database pool is again backed by role-based access control thus you will only be able to delete an elastic database pool if you have the permission to do so.

Furthermore if an elastic database pool, database server or the database server resource group is locked, you will not be able to delete that elastic database pool.

image

Deleting an elastic database pool is an irreversible process. To ensure that you really want to delete an elastic database pool we have included a simple CAPTCHA on the delete confirmation box.

image

 

Manage Databases

Cloud Portam enables you to manage databases in an elastic database pool. You can add a new or an existing database to the elastic database pool. You can also view the databases in the elastic database pool and remove them from the pool.

image

image

Add Database to Pool

First, let’s talk about how you can add a database to the pool. As mentioned above, you can create an empty database and add it to the pool. You can also select an existing database in that database server and make that as a part of the pool.

image

image

When you add an empty database, all you’re asked to provide is the database name and its collation. Other properties of the database are taken from that of the elastic database pool. When an existing database is added to the elastic database pool, its edition and performance tier are changed to match that of the elastic database pool.

Please note that from these screens, you can only add a single database to an elastic database pool. To add more than one databases to an elastic database pool, you would need to go to databases dashboard (more on this below under “Database Enhancements” section).

Viewing Pool Database

Cloud Portam also enables you to view the databases in an elastic database pool. When viewing databases in an elastic database pool, you can select one or more databases and remove them from the pool. Please note that removing a database from an elastic database pool does not delete that database. Simply the edition/performance tier of the database is changed as per your selection.

image

To remove databases from an elastic database pool, simply select one or more databases and then for each selected databases specify the edition/performance tier as shown above.

Change eDTU

Cloud Portam enables you to change eDTU of an elastic database pool.

image

When it comes to changing eDTU, there are two things you could do: 1) You could change the eDTU for the elastic database pool or 2) change the maximum/minium eDTU / database. Please note that currently there’s an issue with Azure REST API thus after changing the pool eDTU, you must wait for some time and then try to change the maximum/minimum eDTU / database.

image

 

View Elastic Database Pool Properties

Cloud Portam enables you to view properties of an elastic database pool.

image

image

 

Manage Elastic Database Pool Tags

Cloud Portam enables you to manage tags on an elastic database pool. You can create new tag entries (key/value pair) and update or remove existing entries from an elastic database pool.

image

image

 

View Elastic Database Pool Permissions

Cloud Portam enables you to view the permissions you have on an elastic database pool from the perspective of management of that elastic database pool.

image

image

 

Manage Elastic Database Pool Locks

Azure Resource Manager API allows you to lock your elastic database pools to prevent them from being accidentally deleted or updated. Cloud Portam enables you to manage locks on elastic database pools. Using Cloud Portam, you can create locks on an elastic database pool. You can also view locks on an elastic database pool or even delete the locks on an elastic database pool.

Again, managing locks on elastic database pool is protected by role-based access control thus you will only be able to perform this operation only if you permissions to do so.

image

image

image

 

Database Enhancements

Add Databases to Elastic Database Pool

From the elastic database pools dashboard, you can only add a single database to an elastic database pool at a time. If you want to add multiple databases to an elastic database pool, you can do so from the databases dashboard.

image

image

image

image

 

Storage Queue Enhancement

Credit for this enhancement goes to our user Allison! Earlier when you view messages in a storage queue, you would need to click on every message to see the contents of that message. In this version we have changed the functionality and now you will see the message contents on the grid itself. Since a message in a queue can be large (up to 64KB), we are only showing the 1st 250 characters. But with a single click, you can see the entire message contents.

SNAGHTML4e916905

What’s Next

With this release, we believe that we have covered basic functionality for managing Azure SQL Databases. Now we will go back and add some more features for managing SQL Databases. So please stay tuned for those features in the coming days.

Try It Out!

We humbly request you to try out these updates in Cloud Portam. This is available in both “Personal” and “Team” editions of Cloud Portam. Though extreme care has been taken regarding testing the current functionality, it is quite possible that we may have overlooked something. If you find something missing or implemented incorrectly, please feel free to reach out to us and tell us. We will fix the issues ASAP.

Closing

As you can see we’re constantly investing in making the product more and more useful. Do try out Cloud Portam and these features and let us know what you think. If you think, we can improve it in any way, please feel free to share your thoughts. The link to our website is http://www.cloudportam.com.