Over this weekend, we released a new version of Cloud Portam where we included support for managing Azure SQL 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 following features:

  • List database servers
  • Create new database servers
  • Delete database servers
  • Manage firewall rules on database servers
  • Manage administrator login password for database servers
  • Upgrade database servers
  • View database server properties
  • Manage tags on database servers
  • View deleted databases and restore them
  • View permissions on a database server
  • Manage locks on database servers
  • Create new databases in a database server
  • Create new database elastic pool in a database server

Please note that management features for Azure SQL databases are huge and in this release we have only focused on database servers. In the subsequent releases, we will work on features that will enable you to manage databases and elastic pools from Cloud Portam itself.

Now let’s talk about these features in detail.

Database Server Management

List Database Servers

Cloud Portam enables you to list SQL database servers in your Azure Subscription.

SNAGHTML5e9c85

When listing database servers, Cloud Portam shows you the database server version, resource group and the location of the database servers.

Create Database Server

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

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

SNAGHTML6c255d

You can create a new database server in 3 easy steps:

Step 1: Specify Resource Group

First, you need to specify a resource group in which this database server will go. You could either pick from the existing resource groups in your subscription or create a new resource group all together.

image

image

A few things I would like to point out here:

  • When you choose to create a database server in an existing resource group, Cloud Portam checks if you have the permission to create resources (database server in this case) in the selected resource group. If you don’t have the permission, Cloud Portam will tell you about this right here in this step so that you can choose another resource group.
  • When you choose to create a database server in a new resource group, Cloud Portam will try to create that resource group in this step only. You will only be able to proceed if Cloud Portam is able to create a resource group successfully.

 

Step 2: Specify Database Server Information

Next step would be to provide information about database server you’re trying to create. You need to provide information like database server name, server location, server version, administrator username and password. Optionally you can also set a database server firewall setting to allow applications running in Azure to  access databases in this server.

image

 

Step 3: Review

In this step Cloud Portam will show you the information you have specified in the previous steps. You can go back to any step and make the changes or proceed with database server creation.

image

 

That’s it! After you hit “Save” button, Cloud Portam will create a database server for you in your Azure Subscription.

Delete Database Servers

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

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

Furthermore if a database server is locked or the resource group where this database server is contained, you will not be able to delete a database server.

SNAGHTMLea62fd

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

SNAGHTMLeb2dcf

 

Manage Firewall Rules on Database Servers

Cloud Portam enables you to manage firewall rules on a database server. When it comes to managing firewall rules, one neat thing in Cloud Portam is that it allows you to manage multiple firewall rules in one go. You can add new firewall rules, update existing firewall rules and even delete those rules.

SNAGHTMLee97f4

 

image

 

To add a new firewall rule, simply click “Add Rule” button and a new empty row will be created for you where you can specify the rule name, start and end IP address.

To remove one or more firewall rules, simply select the checkboxes before the firewall rule you wish to remove and click on “Remove Selected” button. This will remove those rules from the UI.

To update an existing firewall rule (Name, start/end IP address), simply change the values.

Don’t forget to click on “Update” button to actually update the firewall rules. When you click on this button, Cloud Portam will make multiple requests to Azure and make firewall rule changes.

Change Administrator Login Password

Cloud Portam enables you to change the administrator login password.

SNAGHTMLfd4f69

image

Upgrade Database Server

When you create a database server, you get two options for the server version – Version 12.0 (recommended) and 2.0. If you have a version 2.0 database server, using Cloud Portam you can upgrade the server version to 12.0.

SNAGHTMLf8d0a7

 

image

To ensure that you really want to upgrade a database server we have included a simple CAPTCHA on the delete confirmation box. Once you click “Upgrade” button, Cloud Portam will send a request to Azure to start upgrading the database server. Please note that it may take some time for the upgrade process to actually complete.

View Database Server Properties

Using Cloud Portam you can view properties of the database server.

image

image

Manage Database Server Tags

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

SNAGHTML10682d1

 

image

 

View Deleted Databases

Cloud Portam enables you to view deleted databases that are still restorable in a database server. You can view the these deleted databases and restore them to create a new database.

SNAGHTML10eef40

image

 

image

 

Once you click “Restore” button, Cloud Portam will send a request to Azure to start restoring this deleted database.

View Permissions on Database Server

Using Cloud Portam, you can view the permissions you have on a database server. The permissions include the ability to update/delete the database server, create database/elastic database pools, manage firewall rules and more, and permissions for role assignments and locks.

SNAGHTML11689e8

 

image

 

Manage Locks on Database Server

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

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

SNAGHTML12e305a

image

 

image

 

Database Management

In the current release, we’re offering very limited functionality as far as managing databases are concerned. Only thing we’re including in this release is the ability for you to create a new database. In the subsequent releases, we will be offering more features.

Create Database

There are many ways by which you can create a database in a SQL Database Server. You can create an empty database, or restore a deleted database or import a bacpac file. Creating a database using Cloud Portam is super easy!

SNAGHTML144912c

 

SNAGHTML1813d46

 

In the current release of Cloud Portam, we’re offering 3 ways by which you can create a database.

 

Create “Empty” Database

To create an empty database all you need to do is specify database name, database edition/performance tier and database collation.

image

image

image

 

Based on the information you provide, Cloud Portam will send a request to Azure to create an empty database.

Create Database from Backup

Cloud Portam also enables you to create a database using latest full and differential backups of the specified source database. Please note that this source database need not be in the same server where you’re trying to create the database. It can be in any database server in your Azure Subscription.

SNAGHTML152d96c

SNAGHTML1546fea

SNAGHTML155d093

Based on the information you provided, Cloud Portam will send a request to Azure to create a new database from the latest backup of the source database.

Restore a Deleted Database

Cloud Portam also enables you to restore a deleted database. Unlike previous option where source database server can be different than the database server where you are creating the database, in this case both source and target database need to be the same.

image

 

image

 

image

 

Based on the information you provided, Cloud Portam will send a request to Azure to create a new database by restoring a deleted database.

Elastic Database Pool Management

In the current release, we’re offering very limited functionality as far as managing elastic database pools are concerned. Only thing we’re including in this release is the ability for you to create a new elastic database pool. In the subsequent releases, we will be offering more features.

Create Elastic Database Pool

SNAGHTML15ce36e

SNAGHTML15dc7e2

 

To create a new elastic database pool, all you need to do is specify the pool name, service tier (basic/standard/premium), and configure eDTU for the pool.

image

image

 

Based on the information you provided, Cloud Portam will send a request to Azure to create a new elastic database pool.

What’s Next

This is just a start for SQL Database management in Cloud Portam. We need to provide support for managing databases and elastic database pools so we will be working on those in next few releases.

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.