Are you a junior or intermediate SQL Server DBA...yet your lack of experience with the infrastructure is holding you back from a promotion or a pay raise?
Sure, you are very comfortable with SQL Server and working with databases. But you are clueless when it comes to working with Windows Servers, or the network, or Active Directory, or the DNS.
- “I've never configured servers before”
- “I don't really get much experience with setting up and installation. The sysadmins do that kind of work.”
- “I have no real-world experience”
- “I don't know anything about how to set up & configure infrastructures”
- “I’m unfamiliar with designing, implementing and managing, not sure where to begin”
- “I'm just blindly following instructions left by a senior administrator and not sure if what I'm doing is right”
- “I haven't done it in production yet”
- “I am having trouble setting up a good test environment as I am not familiar with a lot of the configuration and set up involved”
- "My lack of knowledge is my biggest frustration"
Don't worry, I've got you covered.
In this online course, I will personally take you by the hand and WALK YOU through the process of building a multi-site, multi-data center setup with Active Directory, DNS, and networking - working with a minimum of five (5) servers at the same time.
I’ll dish out EVERYTHING you need to know to have the skills, strategies, and confidence to build the infrastructure needed to deploy an expert-level solution like a multi-site SQL Server Always On Availability Group solution.
Course Outline
- Creating and Configuring the Virtual Machines (20:54)
- Installing and Configuring Active Directory Domain Services and Microsoft DNS for the Production Data Center (17:55)
- Creating a Domain Administrator account for Managing the Environment (8:57)
- Creating and Configuring the Virtual Machines: PowerShell Edition (9:22)
- Simple Network Connectivity Test: Part 2 - Validating and Troubleshooting Network Connectivity Between Data Centers (11:21)
- Create AD Server in DR Data Center (5:16)
- Creating Active Directory Sites (9:59)
- Installing and Configuring Active Directory Domain Services and Microsoft DNS for the DR Data Center (10:07)
- Simple Network Connectivity Test: Part 3 - Validating Proper Network Routes Between Data Centers (8:14)
- Adding/Joining Servers in the DR Site to Active Directory (6:07)
- Forcing and Validating Active Directory Replication Between Data Centers (6:41)
- Summary (5:58)