Bryan Maynard – TaxSlayer
Bryan Maynard is the Sr. Database Administrator at TaxSlayer, with over 15 years experience in Database Administration, Business Intelligence, and Analytics. He currently holds an active MCSE in Data Platform and Analytics. As the leader of the Augusta SQL Server and BI User Group, he regularly speaks and consults on database administration and professional development around the SQL server platform.
|
The HADR How-To: Intro to SQL Server Always-On Availability Groups
In today’s IT environment where uptime is of the utmost importance, there is a heavy emphasis on High Availability and Disaster Recovery (HADR). There are various options available on the market today, with many that cater to and are perhaps better for different aspects of the IT infrastructure. It is important that IT professionals at all levels understand the importance of HADR and react accordingly, else suffering will inevitably ensue. This can be due to something as simple as a kicked power cord shutting down one server or rack, up to and including a major weather event causing entire datacenters to go offline. In this session we will discuss some of the considerations that should be made when evaluating how to implement HADR in your SQL environment, reviewing how SQL server replication technologies either do or do not fit into a HADR plan, and land on the focal point of Always-On Availability groups. This will be a demo rich presentation where we will actually configure Availability Groups in different ways and see what happens when various outage events take place.
|