How to approach zero downtime database upgrades
This session will present techniques for minimizing downtime during database upgrades. We’ll look at what’s required to deliver a reliable database upgrade while maximizing data availability. During the session I will present my own upgrade checklist, relevant whether you’re upgrading to SQL Server 2005 or SQL Server 2008.
We’ll consider all aspects of upgrade planning, testing and preparation - including upgrading system databases, options for high availability upgrade, ensuring predictable post-upgrade performance and data consistency.
- Downloads
- SpeakerBIO
Justin is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for SQL Server. Coeo also offer Remote DBA services for SQL Server platform. Prior to Coeo - Justin spent 3 years working for Microsoft as a Premier Field Engineer during which he delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers. Justin co-authored Wrox IT Pro: SQL Server Performance Tuning, two Syngress exam guides on SQL Server 2008 and contributed to SQL Server 2008 Internals and Troubleshooting guide with Christian Bolton, Brent Ozar and James Rowland-Jones.
- Video
- Session Files Explorer