SQL Server Data platform upgrade Techniques, best practices & notes from the field – SQLSaturday #208 -Riyadh #SQLSatRiyadh

A big week ahead indeed, speaking at SQL Saturday conference for the first time… and one more first time is ..in Riyadh, Saudi Arabia.

SQLSaturday Riyadh – event will be held (for the first time in the Middle East) in May 23rd 2013 at Holiday Inn (AlQasr), Olaya., Riyadh, Saudi Arabia.

No doubt that SQLSaturday’s are popular and I’m presenting on of the famous topic in SQL Server arena – SQL Server Upgrade! (Especially the topic is my favourite as it has been presented since the year 2009, in the conferences like Microsoft TechEd (India, US, Europe) and SQLBits).


SQL Server Data platform upgrade Techniques, best practices & notes from the field

What it covers:

Why Upgrade? This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices. Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits.

In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, & SQL Server 2008 R2 (with a good overview on 2012 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution is offered.

The Background:

The newer versions contains improvements and new (additional) features in majority of the product, one of the compelling case is making your day-to-day life easier & manageable. There is real reason to say why you should not upgrade! Depending upon the need for newer features one of the major motto is to keep your data available at all the times and reduce the impact when disaster strikes. Performance & Scalability is the next major functionality which extends the data platform life with maximum possible support for your application.

The upgrade process itself is not as complex as you think. However, it will be complex and critical when the underlying applications are restricted due to dependency on legacy technologies. The budget to perform upgrade is next important aspects, by highlighting the new productivity features from the newer versions you as a DBA can support the cause and making ease of any scenarios that are leading into complex situations. Planning is the first step by analysing the upgrade requirements, review the upgrade steps (a simulation), build a strategy and understand how the newer version is helpful in productivity & manageability also keeping mind about the backward-compatibility for the application.

Come to my session and get to know more about how to reduce the complexity in upgrade process, learn the new practices (best practices that were implemented during my consulting projects) and 3 types of upgrade scenarios with problems & solutions that were offered.

What else?

Also the topic is one of the major recipe in my book SQL Server 2008 R2 Administration Cookbook.

See you there! 🙂