Building SQL Server test environment on Azure

Going back a few years (and then some), creating your own test environments used to be difficult requiring both time and hardware resources. Then came the different virtualization solutions, which made it bit more easier but still requiring decent amount of hardware resources and a little bit of time. With the arrival of Azure and other cloud-based solutions, things finally got considerably easier. Now we finally had the ability to set up a test environments quickly and easily.

Here’s a short guide on how to build your own test environment to Azure. The basic steps are:

  • Create Azure Account
  • Create Azure Network
  • Create two Virtual Machines
  • One to act as your AD Controller
  • And one SQL Server
  • Download AdventureWorks database for testing purposes

Creating Azure Account

Creating your own Azure account is quite simple, just head to http://www.windowsazure.com/en-us/pricing/free-trial/ to get your free trial for Azure. If you have MSDN subscription, even better! With MSDN subscription you get an amount of credits to run virtual machines in Azure every month. It’s not a lot, but enough to build a small test environment.

The rest of the process I’ve split into three parts, which you can find here:

Part 1: Create Azure Network and Storage
Part 2: Create Virtual Machines and Active Directory
Part 3: Setup your SQL Server for testing purposes!

Author: Mika Sutinen

Hi, My name is Mika Sutinen and I'm a Senior Database Administrator for a company called Tieto. I've been working in IT-industry for two decades and I've spend most of my career working with healthcare information systems. I've worked with SQL Server for most of my career, starting with version 6.5 a long, long time ago. My other interests are high availability, everything related to performance (testing, monitoring, etc), Windows operating systems and I'm currently learning more about Azure.

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