Azure : Enterprise Grade SQL Provisioning

Introduction

The mailinglist of Luper’s learning featured the following article ;

Introducing a simplified configuration experience for SQL Server in Azure Virtual Machines

To me, this is a very cool and shows the innovation that’s going on in the whole Azure landscape. Underneath, any azure enthousiast, will see that this is powered by the ARM JSON templates. Though from a business perspective, the right questions are posed!

  • Who should be able to access it and how?
  • What are the storage capacity & performance expectations?
  • What about (technical) maintenance aspects like backup & patching?

How to find the machine?

Go to the marketplace in the Azure portal and find the following SQL server ;

2016-01-08 08_27_27-Microsoft Edge

What will it bring to the table?

In addition to a plain SQL deployment, you are also able to configure ;

Storage Performance

2016-01-08 08_30_56-New notification

Automated Backup

2016-01-08 08_31_51-Microsoft Edge

Automated Patching

2016-01-08 08_31_11-Microsoft Edge

Keyvault Integration

2016-01-08 08_32_06-Microsoft Edge

Despite what the referenced article suggests, you are able to secure your database in a private network ;

2016-01-08 08_29_55-Microsoft Edge

2016-01-08 08_30_12-Microsoft Edge

Any gotcha’s?

  • Be aware that this is a “hit & run” type of deployment and not a full “as-a-service” offering. You will still be responsible for the maintenance and any type of management. This does not replace your system engineer / administrator / architect… They will still have a role, though the deployment will consume less time.
  • The licensing is based on the “PAYG” (pay-as-you-go) model. So you cannot leverage your own (existing) licenses.
  • At this point, the deployment does not have a “High Availability” option. Though you are able to configure an availability group. Though at this point I’m not sure how feasible it is to extend this deployment towards an AlwaysOn setup.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s