SQL training provides instruction in Azure database security

2 September 2014

Many database administrators have worked with Microsoft SQL Server to set up databases, but some are unfamiliar with setting up such environments in the cloud.

There's a natural compatibility between Microsoft Azure and and SQL Server, but those who want to learn more about protecting cloud hosted servers would benefit from enrolling in a Microsoft training course. A number of these programs outline how to encrypt information within Azure databases, issue connection protection and a list of other actions. 

The era of the cloud 
According to SQL Server Magazine contributor and Madeira SQL Server Services CEO Guy Glantser, the role of DBAs is undergoing a fundamental transformation in the time of the cloud. Some early adopters of the technology believed cloud computing would effectively eliminate the need for administrators.

However, such critics are mistaken. In fact, due to the number of options Azure and other enterprise-class counterparts provide enterprises with, DBAs must be able to confidently make decisions pertaining to the cloud architectures. 

For instance, if a person wants to create a new database in Azure, he or she can either set up a virtual machine through a conventional SQL Server instance or implement the environment with a SQL database. While the former action subscribes to the Infrastructure-as-a-Service model, the latter is categorized under Platform-as-a-Service. If the DBA chose to set up a VM, he or she would have to clarify its job, the amount of storage, network address and so on.

A quick preview 
TechNet Magazine contributor Joshua Hoffman outlined a few common security tasks DBAs will be expected to conduct when managing access to Azure databases. Given the complexity of the environment highlighted above, one can imagine the amount of protection options he or she has to work with.

Hoffman detailed how to manage network access. Before a database can be accessed, an administrator must follow the steps below:

  • Log in to the Windows Azure Platform Management Portal
  • In the left pane, select Database
  • From there, broaden your subscription and select the SQL Azure server for which you want to set up firewall regulations
  • Select Firewall Rules to detail them in a list
  • When you want to add a new rule, click Add
  • To enable other Windows provisions to access the database, choose "Allow other Windows Azure services to access this server." This implements a regulation with an Internet Protocol range. The process also allows DBAs to update and delete rules. 

This is just a glimpse at some of the functions Microsoft training course enrollees will learn how to use. 

Leave a Reply

Your email address will not be published. Required fields are marked *