San Francisco, California
London, United Kingdom
Introduction to High Availability and Disaster Recovery with SQL Server
Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like:
- What does a good High Availability or Disaster Recovery strategy even look like?
- What options are available to help implement a proper HA/DR strategy?
- What do I do if my database server goes down?
- How do I mitigate downtime for planned outages?
- How much time do I have to recover, and which native SQL Server features helps me reach my goal?
- How does this work with my company’s existing HA/DR strategy? (if they even have one)
Linchpin People is offering this seminar to answer those questions and many more.
In this all-day training, we will help teach you the fundamentals and best practices of building and implementing a full HA/DR Strategy for your company. You will learn how to build a recovery plan by mastering the basics of backups and restores. You will also learn how to implement and monitor log shipping, database mirroring, replication, Windows clustering, SQL Server Failover Clustering Instances, and the new Availability Group features.
Who should attend the seminar?
Any IT Professionals who want to improve their skills and add value to their company. More specifically, anyone who needs to build a High Availability and/or Disaster Recovery strategy for SQL Server Databases. Also, any SQL Server Database professionals who want to learn the native features for High Availability and Disaster Recovery inside SQL Server.
After this training session, you will have the knowledge to design, implement and manage your very own high availability and disaster recovery (HA/DR) plan. You will:
- Understand Mean Time to Recovery (MTTR), Recovery Point Objectives (RPO), and Recovery Time Objectives (RTO), and build a High Availability and Disaster Recovery strategy to meet your RPO and RTO needs.
- Learn about how to leverage SQL Server HA and DR features and how they may complement or conflict with an existing enterprise HA and DR strategy.
- Learn how to implement all native HA and DR features included in SQL Server 2012 including, log shipping, database mirroring, replication, Failover Cluster Instances, and Availability Groups.
- Learn how to proactively monitor and troubleshoot common problems of each native High Availability and Disaster Recovery feature.
Our training seminars are only taught by experts in the Microsoft SQL Server ecosystem. There is a big difference between knowledge and experience, and Tim and John will demonstrate both through their teaching and relatability.
Tim Radney is the Lead System DBA for a top 40 US held bank. Chapter leader for the Columbus GA SQL Users Group, PASS Regional Mentor for Greater South East US. Tim is a Microsoft Systems Admin turned DBA. Prior to becoming a full time DBA, he spent 10 years supporting Citrix, Novell, Windows, IIS, and MSSQL.
John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturday’s, PASS Chapters and Virtual Chapter meetings. John is a PASS Regional Mentor and one of the founders of the WVPASS user group and the PASS HA/DR Virtual Chapter.
Time: Registration starts 8:30am; Class starts at 9:00am goes to 4:00pm
Cost: $79.00 before April 30th, $99.00 after April 30th.
Food: Lunch, and drinks will be provided at the event location. Please contact the organizer if you require a vegetarian option.
Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $120 is due at the time of registration.
When & Where
Pittsburgh SQL Server User Group
The mission of the Pittsburgh SQL Server User Group is to provide an opportunity that will allow database developers, database administrators and all other IT professionals who work with databases to connect, share and learn for free. While everyone's shop might be unique the majority of the DBA's have similar projects and problems. We will allow all users the opportunity to share their experiences while they can also build their soft skills.