DIY Hyper-V, Active/Active Clustering and SQL Server – Demo and Step by Step Instructions

Clustering, Presentations, Speaking, SQL
Recently spoke at South Florida IT Camp Saturday on using Hyper-V, Windows Server 2008 R2 SP1 Enterprise, Microsoft iSCSI Target 3.3, and SQL Server 2008 R2 SP1 to create an Active-Active SQL Cluster. I actually managed to cover all the cool parts in an hour, and got some great feedback. If you're interested in implementing this demo yourself, I've posted: Network Diagram (Overview of the virtual server components in the SQL Cluster) Step by Step Instructions (The steps I took to create the Active/Active SQL Cluster) Hyper-V SQL Clustering Worksheet (Planning the values in this worksheet in advance makes this process simple.) My Slide Deck (Because everyone loves PowerPoint) I need someone who's interested to volunteer as my 'technical editor'.. To walk through these steps, help me clarify or correct anything unclear. If you're…
Read More

SQL cluster on the cheap with Hyper-V and iSCSI

Current Events, Presentations, Speaking, SQL
Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment. Now, how to compress 9 hours of setup into a session... Expect some smoke and mirrors along with some neat technology. Does anyone have some SSDs I can borrow? :) July 23rd Tentative outline: Setup Hyper-V Host Install two virtual networks (lan,iscsi) Create OS template Deploy and install 3 servers Configure iSCSI storage and targets Configure Windows Cluster Install SQL Node 1 Add SQL Node 2 Test Discuss production deployment options Q & A
Read More