Part 2: Create Virtual Machines and Active Directory

In previous post, Part 1: Creating Azure Network and Storage, we set up your Azure account ready for two virtual machines that’ll be the backbone of your own testing environment. One of these servers will run the Active Directory and the other one will host your SQL Server 2012 instance. The Active Directory server is really optional, you can do a test environment without it but I prefer test environments that mimic the production.

Continue reading “Part 2: Create Virtual Machines and Active Directory”

Part 1: Create Azure Network and Storage Account

Now that you’ve setup your Azure account we can get started on building the test environment. First thing you should do is to create a Virtual Azure Network, this will be used for connectivity between your servers. Creating a Network is quite straightforward business. Choose Networks and then Create A Virtual Network.

Continue reading “Part 1: Create Azure Network and Storage Account”

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.

Continue reading “Building SQL Server test environment on Azure”

Few thoughts on Windows Power Options

I ran into and old issue recently I hadn’t seen in a while. A database server was experiencing some intermittent performance issues that didn’t make much sense. It didn’t take me long to figure out what was going on though, after firing up the Resource Monitor.

Continue reading “Few thoughts on Windows Power Options”

The fifth and final day in Charlotte

And so it is that PASS Summit 2013 has come to an end. And I have to say that for a first timer like me, it was truly an eye-opener to what SQL Server Community is all about. The quality of the sessions and the deep knowledge of SQL Server internals, virtualization and dozens of other subjects the speakers possessed was just astounding, but also expected.

Continue reading “The fifth and final day in Charlotte”

Days three and four in Charlotte

Last two days have been really hectic here at Charlotte. Most of the day have been spend there at the conference center and last night we went out with couple of other Finns to participate in a traditional Finnish Eve. On thursday there was the Community Appreciation Party held at the Nascar Hall of Fame.

Continue reading “Days three and four in Charlotte”

Second day in Charlotte

The second day in Charlotte at the PASS Summit 2013 has come to an end. I spend the whole day in a Failover Clustering pre-conference session held by Allan Hirt and it was both educating and exciting. I was pleased to realize that many of the things I have spoken in our company were also addressed and confirmed by Allan. He also reminded me of some the things I had forgotten and taught me quite a few new things as well.

Continue reading “Second day in Charlotte”