Administering Microsoft SQL Server 2012 Databases
It's almost time to take the 462 exam and get a step closer to MSCE. Like with 461, I am leaving a little bread trail that I can find in the future for reference, and again, its free to you.
(This study guide will be updated continuously until I take the exam)
This exam is much different than the 461 and requires a different depth of knowledge, mostly related to Server Administration. I find myself doing a lot of non-SQL related steps in order to prepare a proper lab in my bedroom for studying.
The goal is to set up a complete simulated enterprise, including clustered failover Windows Server, Domain, and Clustered SQL databases, using my 2 personal home computers. I want to utilize the latest technologies that I expect commercial enterprise will desire in the future, such as Hyper-V. You know if someone asks for clustered database work, clustered windows servers will be right alongside it. Failover Cloud Redundancy is a big trend of the day.
I went ahead and dedicated 1 of my computer solely to this lab, installing a fresh 180 evaluation copy of Windows Server 2008 R2 Standard.
Steps to set up lab [Before SQL Cluster Installations] (in-progress)
Thks for the Help :) It's going to be a little hard to achieve what you've done because I only have one PC
I'm going to try it with virtual machines
I have just set up my lab using VMware. Since I only have one PC at home, I have no choice but use VMware. My pc really struggles when I fire up three sessions of windows 2008 R2 so i am upgrading to 8 gb RAM this week. I am also looking into buying SSD but not sure if it will work for me. Any ideas?
Are you using ESXi, VMWare player or Workstation with VMWare? I recommend workstation if you can spring for it or if you have Windows 8.1 Pro hyper v should work, but I have not messed with it as much.
Buy the biggest SSD that works for you 256 GB should be well under $200 and 500 GB are under $300. For the SSD make sure AHCI driver is enabled and then use linked clones from a patched master, it will save you space. 8 GB RAM will be tight but should work as each VM is not going to be using 100% of its allocation. I can spin up 4 2012 VMs using < 70 GB of disk and about 10 GB of RAM. Since all VMs run from the clone off the SSD I can boot it all up and be running my training sessions in under 2 minutes.
Even if you cannot expend the RAM buy the SSD, if you can't get a large one run the master from spinning disk and the linked cloned from SSD as most writes and hot reads will still be on the SSD.
I like using VMWare Workstation, which I have because of my day job, as it allows for the linked clones, and advanced networking.
Now I just need to find time to read, practice and play in my lab for the exam.