In today’s Ask the Admin I’ll show how to provision SQL Server in the cloud using Azure SQL Database v12.
There are lots of reasons why you might want to run SQL in the cloud, primary among them is to support cloud-based business applications. There two options for running SQL in the Azure cloud. The first is to use Database as a Service (DBaaS), which is optimized for software-as-a-service (SaaS) app development and is compatible with the most SQL Server features, and that’s what I’m going to show you how to do in this article. Secondly, you could deploy SQL Server in a virtual machine (VM) running in Azure.
Azure SQL Database is designed to reduce costs by making it easy to deploy and manage one or many databases to support your applications. Because Microsoft deals with provisioning and updating the high availability back-end infrastructure on which Azure SQL Databases run, and backup, there’s much lower overhead compared to deploying your own VMs and installing SQL Server.
The Azure SQL Data Sync service, currently in preview, allows data to be transferred from existing SQL deployments to Azure SQL Databases. Other tools, such as the Microsoft Sync Framework, T-SQL scripting, and the bcp utility can also be used to transfer data to Azure SQL Database.
Unlike SQL Server, Azure SQL Database doesn’t need to be licensed but is sold as a service in several tiers and based on two models: Elastic Database or Single Database. The Elastic Database model is based on the management of collective performance pools, measured in elastic Database Transaction Units (eDTUs), rather than individual databases. The Single Database model has three tiers – Basic, Standard, and Premium – offering different levels of performance based on Database Transaction Units (DTUs). Click here for more information on Azure SQL Database pricing.
Before starting, you’ll need an Azure account. If you don’t already have one, you can sign up for a free trial here.
Wait for the database to be deployed. Once it’s ready, the panel for the new database will automatically open in the portal window. If not, you can click the DB’s icon on the portal dashboard, or find it in the all resources menu on the left.
You’ll need to create a firewall rule before you can connect to the new Azure SQL Database.
Now the database is ready, you can connect to it using Visual Studio or other compatible tools.
In this article I showed you how to create your first Azure SQL Database, configure a firewall and connect using Visual Studio.