Having been a speaker at SQLBits since 2010, I am excited to announce that I will be finally delivering a preconference session at this year’s event in Telford and it is only fitting that my session returns to subject matter that is quite close to my heart.
In 1998 I was made responsible for a SQL Server 6.5 Failover Cluster (running on Windows NT 4 Enterprise) and quickly learned the value of having test environments for Availability solutions. The only problem was that Virtualization was in its infancy, physical hardware for non-production loads was restrictively expensive for Enterprises, and not many people understood the technology! If you wanted to test out High Availability concepts and functionality, you were generally forced to do so in Production – And a lot of us got burnt!
Today we have numerous rich Virtualization Platforms, hardware is cheap and Evaluation Software is free (for time-limited evaluation), but despite all these things, I still see most companies failing to provide Highly Available Virtualized test platforms for their DBA’s and Administrators.
In this session, I will show you how to Build Your Own SQL Server High Availability Test Lab (on your Laptop and beyond!) so that you no longer need to put your production environment at risk, and are empowered to play with varying scenarios to your hearts content from the comfort of your own armchair. Once we have our own test platform, we will then focus on SQL Server High Availability (up to and including SQL Server 2016, Windows 2016 and Azure) and take a comprehensive look from the ground up covering simple and complex topics in an easy to understand format!
After attending this training day you will have comprehensively learnt the fundamentals of implementing and managing SQL Server High Availability solutions and will understand how you can deploy these on your laptop, home network, and work test environments.
If this all sounds like your cup-of-tea, then check out the rest of my abstract below:
Build Your Own SQL Server High Availability Test Lab (on your Laptop and beyond!)
Mark Broadbent is a Microsoft Certified Master in SQL Server, Microsoft Data Platform MVP, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge founder (the UKs first SQLSaturday), SharePoint Saturday Cambridge founder, SQL Nexus board member and was awarded Microsoft’s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
• Are you struggling to understand SQL Server High Availability?
• Would you like to build your own test environment?
• Would you like to practice fail-overs, adding or removing Availability Group Replicas, Cluster Storage Migrations or play with Hybrid deployments -all from the comfort of your own arm-chair?
If any of these are true then have no fear, for in this demo-rich pre-conference I will explain how you can build your own “High Availability” environment in the safety of your own laptop *1, home network or work test network.
We will start from nothing and configure your lab from the ground up until we have a fully functional working Virtualized Domain, Availability Group Replicas and even a multi-instance SQL Server Failover Cluster and then start playing with them to destruction.
By the end of the day you will not only learn the fundamentals of SQL Server High Availability, but will also understand more advanced topics such as:
• Deployment and builds
• Cluster troubleshooting.
• Hybrid deployments and Interoperability.
• Availability Group Monitoring and Performance.
• Virtualization for High Availability.
• New features in Windows 2016/ SQL 2016
*1Please note that deployment on a single host is for testing purposes only (in case that wasn’t obvious!)
Attendees to this session will receive access to a set of scripts, notes and a pre-built Hyper-V time-limited virtual lab for your own testing and enjoyment.
Attendees will not be expected to have prior knowledge of High Availability, Virtualization, and Operating System configuration and Networking, but a basic understanding of these concepts will lessen the learning curve when we come to implement those things.
When the SQLBits preconference sessions are made public I will add an extra link for booking!