Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

2009

TL; DR

SQL Server upgrade is no easy job, as DBA must go through upgrade methodology with options and considerations. Take help of freely available Upgrade tools from Microsoft and plan your database upgrade with a coverage of Pre-upgrade tasks, during upgrade and Post upgrade tasks.

Session Details

In this session we will cover SQL Server Upgrade options, methodology, tools and planning, technical and non-technical considerations along with common issues, myths and mistakes.

Also coverage towards the exhaustive list of all upgrade issues with an end-to-end coverage or in-depth drilldown of all SQL Server 2005 & 2008 features.

A pre-requisite from the attendee is operational familiarity with SQL Server 2000/2005 along with basic knowledge of SQL Server 2008.

3 things you'll get out of this session

Speaker

Satya Jayanty's previous sessions

DevOPS for DBAs-Where is your magic wand? - 2018

SQL Server Upgrade: take help from tools and best practiceS - 2011

Make your DBA life better using SQL Server technologies - notes from field & best practices - 2010

Upgrading To SQL Server 2005 & 2008: Notes & Best Practices - 2009

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices - 2009

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study - 2009