As a SQL Server DBA, it is very important to learn concepts by doing or implementing. Following this rule, I often create a SQL Server Lab setup for myself and destroy the same once done.
In this blog/video series, I talk about how to create a SQL Server Lab environment that includes SqlCluster & Availability groups in multi-subnet architecture that would mirror environments within organizations.
To start with, we need to download & install freeware Oracle VM VirtualBox which is easy to install and use. Post this, one can follow the steps mentioned in the below notebook file to set up VirtualBox Network Adapters, Domain Controller, and configure it for multi-subnet routing.
Kindly watch the below training session where I gave a demo of the result, and step by step take you through the creation of a virtual machine, promote it as a domain controller and configure it as a router.
In coming sessions, we would create iSCSI SAN, configure 4 VM as part of WSFC, create Active-Active SQL Cluster, and Availability Groups using FCI as replicas.
If this blog/video is useful, kindly like, subscribe and share. Happy Coding 🙂
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.