Transcript Build An Affordable SQL Server 2012 Lab

Todd Kleinhans
Datavail







SQL Server since 1999
Currently a Senior SQL Server DBA consultant
at Datavail (www.datavail.com)
VP of Marketing for the Denver SQL Server
User Group
Presented at user groups, SQL Saturdays, and
the Rocky Mountain Trifecta
@toddkleinhans
[email protected]
toddkleinhans.wordpress.com



Briefly explain virtualization
Discuss VMWare Workstation 9
Requirements for 70-462 (6 vms!)
◦ DC, SQL-A, SQL-B, SQL-C, SQL-D, SQL-Core

Build two Gold Masters
◦ Windows Server 2012 Standard
◦ Windows Server 2012 Core

The Secret in the Secret Sauce
◦ Linked clones
◦ Build remaining vms

Clustering
◦ iSCSI used in examples
◦ Virtual hard drive for shared storage

Can be done with vms


Software running inside of software
Host
◦ Is the actual physical hardware
◦ Host can host a variety of operating systems

Guests
◦ Guests are the actual virtual machines (vms)
◦ Generally limited by host resources (disk, memory,
CPU)
◦ Thin provisioning of disk space
 Don’t actually use real space until you write to it
◦ vms can use/interact with physical devices

Mature product
◦ $250 Electronic software download (ESD)
◦ Supports a ton of features

Virtual Box from Oracle (4.2)
◦
◦
◦
◦
Free
Not quite as capable of VMWare
Can consume a lot of resources
Will try to build a SQL Lab and report results

Set-up
◦ Download free Windows Server 2012 .iso
◦ Download free SQL Server 2012 .iso

Hardware
◦ msinfo32
◦ SSD

Start Building!
◦ Move pretty fast - lots of screen switching
◦ Limited use of ZoomIt


Install OS
Install VMWare Tools
◦ Allows cut/paste between host and guest




.NET 3.5 (required for installing SQL Server)
Snapshot/linked clones
Sysprep – Generalize!
On your lab- run Windows Updates


[email protected]
Good luck with your SQL Lab!