Sunday, September 07, 2014

SQL Server Deployment in Azure Cloud

Cost benefits, flexibility and Scale are the hall marks of cloud deployment. Microsoft SQL Server runs without a hitch in the cloud.

SQL Servers can be deployed to a private cloud, hybrid cloud or a public cloud.

In the public cloud SQL Server can be run in different ways:
  • Windows Azure SQL Database - this is a cloud-based to build relational database applications that scale out to millions of users
  • Windows Azure Virtual Machine- this is just like a on-premises SQL Server
Features of running on Windows Azure VMs

Running SQL Server in a Windows Azure VM is no different from running SQL Server in a on-premises VM. The businesses have complete control over the server and they can install applications and run almost any work load. This mode of running SQL Server is fully supported by Microsoft.
Businesses can create a cloud server using prebuilt virtual machine images from the Microsoft Windows Azure Gallery.

After creating and starting the server they can migrate the database server using any of the well documented methods such Attach/detach, or backup and restore, etc..
Another method is to upload the entire on-premises virtual machine and upload it to Windows Azure.
Sign in to Windows Azure.
Get on to Windows Azure .

Click on the subscription you want use this time.

Click on Virtual Machines.

Presently there are no virtual machines.
Click +NEW at the very bottom to display this pane.

The following are the images available (Scroll to review the complete list on the portal) either on Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2:

SQL Server 2008 R2 SP2 WEB
SQL Server 2008 R2 SP2 Standard
SQL Server 2008 R2 SP2 Enterprise
SQL Server 2012 SP2 WEB
SQL Server 2012 SP2 Standard
SQL Server 2012 SP2 Enterprise
SQL Server 2012 SP1 WEB
SQL Server 2012 SP1 Standard
SQL Server 2012 SP1 for Data Warehousing
SQL Server 2012 SP1 Enterprise
SQL Server 2014 RTM WEB
SQL Server 2014 RTM Standard
SQL Server 2014 RTM Enterprise
SQL Server 2014 RTM Data warehousing

You can choose one appropriate for your needs.
--to be continued

Read more here:

No comments: Protection Status