Platinum Sponsors

28th March 2009 Manchester

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links
    

Session Details - 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.
Justin Langford
I work as 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.  I work delivering and maintaining SQL Server solutions for customers in many different industry sectors throughout Europe.
    Prior to joining Coeo - I spent three years working for Microsoft as a Premier Field Engineer.  In this role, I delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers in Europe.  I have co-authored Wrox IT Pro: SQL Server Performance Tuning, and two Syngress study guides on SQL Server 2008.

Downloads

No items to download

Click here to view in local media player

Due to the size of these files we can only provided streamed versions.

Other sessions from this conference

A Testing Time...
A walk down memory lane
Advanced T-SQL (2005 and 2008)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite
Data Vizualisation - Make your reports useful to business - No more "Speed Dials"
Does your cube support your users reporting needs?
Don't try this at work !
End to End Report Creation and Management using Microsoft SQL Server 2008
Getting more value from your data through data mining.
Head in the Cloud...
Indexes Basically
Microsoft's integrated end-to-end BI offering.
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse
Small Problem - Simple Solution: Lookup Tables
SQL Server – Under New Management
SQL Server 2008 for Developers
Understanding Query Cache and Query Plans
Useful Sql'y stuff that I've picked up over the years
Where’s my data? An introduction to Spatial Queries in SQL Server 2008