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.
Speaker focus
Justin is a Principal Consultant for Coeo Ltd, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for all versions of SQL Server. Coeo also offer Remote DBA services to customers who outsource management and 24x7 operations of their SQL Server platform. Justin works delivering and maintaining SQL Server solutions for customers in a variety of industry sectors throughout Europe.
Prior to joining Coeo - Justin spent three years working for Microsoft as a Premier Field Engineer. In this role, he delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers in Europe. Justin has co-authored Wrox IT Pro: SQL Server Performance Tuning, two Syngress exam guides on SQL Server 2008 and contributed four chapters to the recently released Wrox SQL Server 2008 Internals and Troubleshooting guide with Christian Bolton, James Rowland-Jones, Jonathon Kehayias and Brent Ozar.
Other sessions from this conference