Part 2: Create a Windows 2008 R2 Hyper-V Lab Network

Introduction Creating a WIndows 2008 R2 domain network lab environment on a Windows Hyper-V host server involves creating a number of Windows 2008 R2 servers, each to fulfull a required role.  Central to any Windows server domain network is an Active Directory Domain Controller (DC) and Domain Name Services (DNS) server.  With the core network infrastructure in place member servers can then…

2

Improve the Performance of Reporting Services Parameterized Reports

Summary If you’ve ever developed SQL Server Reporting Services 2008 R2 reports with more than a just few parameters then you may be aware that those reports may take a while to load.  This post will reviel a few tricks and work-arounds I’ve discovered while delivering similar reports.  The information reflects not only my own…

1

Series: Building a SQL Server 2012 AlwaysOn Virtual Lab

Overview In this series of posts I will share how to build a virtual development & test lab for the purpose of experiencing the process of implementing the new SQL Server 2012 “Denali” high-availability and disaster recovery features.  What’s more, this lab can then be used to explore some of SQL Server 2012’s other other new…

1

Part 1: Create a Hyper-V Host Using Boot-to-VHD

Introduction The advent of Windows Server 2008 R2 and Windows 7 brought with it a fantastic new capability that greatly enhances our experience with creating lab and test environments: Boot to Virtual Hard Disk (Boot-to-VHD).  Unlike VirtualPC virtual machines, “Boot to VHD” VM’s utilize underlying hardware resources directly rather than via emulation, and this translates into…


Part 3: Create a Virtual Shared Storage Solution in the Hyper-V Lab

Introduction In order to configure a Windows Failover Cluster inside a Windows 2008 R2 Hyper-V based virtual lab environment you must first prepare a shared storage solution that can be leveraged by the members of the Windows Failover Cluster.  While a separate virtual hard disk (VHD) can be attached to a stand-alone server inside a Hyper-V environment, it…