John Sterrett is a Microsoft Data Platform MVP, MCSE: Data Platform, CEO and Principal Consultant of Procure SQL LLC. 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 Summit, MS Ignite, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the High Availability and Disaster Recovery Virtual Chapter. John has also taken on the task of putting together a #SQLSaturday in Wheeling, West Virginia ..yes we will give you a second to look that up.
John received a Bachelor of Science degree in Computer Engineering from the University of Oklahoma. He is a Microsoft Certified Technology Specialist in SQL Server 2005 and 2008. He lives with his wife Nina, sons Gregory (aka #BabyBeluga) and Samuel.
He also enjoys following the Pittsburgh Pirates (Yes, this update is after the Pirates traded the whole team), meeting new people, traveling, playing golf, wallyball and volleyball.
John is brining us
Have you wanted to build an availability group but didn’t know where to start? In this half day session, you will learn how to build your first availability group while also learning how availability groups work with other components like active directory, storage, and DNS. You will walk away with a checklist to help your future deployments while also learning how to implement, monitor, troubleshoot and use availability groups.
In this session we will cover:
- Understanding the difference between Availability Groups and Failover Cluster Instances
- Configure Windows Failover Cluster Service (WFCS)
- Understanding Quorum in WFCS
- Pre-staging Active Directory Objects
- Learn how DNS is used by Availability Groups
- Build Availability Groups
- Implementing Planned Downtime Failovers
- Troubleshoot Common Availability Group Problems
- Proactive monitoring Availability Groups
- Backups for your Availability Groups Databases
- Managing Connectivity
- Handling SQL Agent Jobs
- Making SQL Server Reporting Services Highly Available Utilizing Availability Groups
Who should attend this session?
All the cool kids! Seriously though, anyone who has had to stay up all night because a server went offline; anyone who wants to do patching during the middle of the day and not affect their users; people who have a need for data to be consumed in different data centers; anyone who is curious about how to make their data highly available.
What is your favorite thing about teaching this session?
It is really helping people understand that building an HA Solution is not as hard as they might think. I love being able to help people implement a solution that makes their lives a lot easier and have a lot more freedom, all the while giving their business a great tool to keep them highly available.
What 1 piece of great advice do you wish someone would have given you when you first started your career?
Only YOU control your career. Good mentors can be more important than your actual job; they can help guide you and get you where you WANT to be in the long-term”
If you could go back and change the career path that lead you to where you are now would you? “He would go back in time and be a famous Rapper! The real answer is HELLZ NAH, he wouldn’t change a thing, unless that Rap career panned out!
John, we know you are a great family man and that you are a HUGE Pittsburg sports fan. What is one thing that you really enjoy and like to indulge in just yourself? What is one thing that you really enjoy and like to indulge in just yourself?
John is a master of the 1’s and 2’s. He does a lot of mixing and posts the songs on YouTube as DJ Right Outer Join https://www.youtube.com/channel/UCgQ3UTYD3bEq9uBkxDTA3lA. John’s favorite thing to say around the office is “There isn’t anything we cannot fix with a remix!” https://youtu.be/XwWKWe0pQuE
A current client actually challenged John to remix House of The Rising Sun. Be on the lookout for that!