High Availability and Disaster Recovery

Login to Subscribe

The High Availability & Disaster Recovery Virtual Group focuses on one of the most important aspects of a business - data availability. The goal of the HA&DR Virtual Groupis to provide a PASS community for Microsoft SQL Server professionals to learn more about how to protect their data and minimize the risk to a business. Join us in our monthly webinar series to learn more about the numerous tools and techniques for SQL Server business continuity. Our webinars are held on the second Tuesday of each month at 1pm Eastern. Make sure to join this Virtual Group in the myPASS portal so you can stay informed of our learning opportunities.

Zero-Downtime Upgrades: Rockstar DBA

Tue, Nov 10 2015 18:00 UTC

Zero-Downtime Upgrades: Rockstar DBA

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure? You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions. In this session you will: * Understand how rolling upgrades are better than in place upgrades * Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades * Explore how you might use Log Shipping to perform a simpler type of rolling upgrade This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!


Argenis Fernandez

Argenis Fernandez is a Principal Program Manager with the Microsoft Databases Systems team based in Redmond, WA. He has worked with SQL Server since 1998 and enjoys working with large SQL Server farms, busy databases, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Previously Argenis worked as a Principal Architect for Pure Storage, as a Lead Database Operations Engineer at SurveyMonkey, and Senior Consultant on SQL Server Core for Microsoft Consulting Services. In 2013 he founded the Security Virtual Chapter for the Professional Association for SQL Server (PASS) (http://security.sqlpass.org). He also handled the SQLSaturday portfolio for PASS as part of its Board of Directors

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids