Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

What Does Support Look Like?

By Steve Jones,

Microsoft support Lifecycle Recently I wrote about the adoption of SQL Server and how it be changing with the quick release cycle. More and more environments will not be able to keep up with the pace of change in SQL Server, and might not want to for many of their instances. The business case for constant upgrades becomes harder and harder to make as SQL Server matures.

My prediction is that most DBAs will need to support more versions of SQL Server in the future. Instead of supporting 2 versions of SQL Server, as many people do now (a "current" version and as you move your instances to the "new" version), I think most companies will end up having 3 or 4 versions of SQL Server living at the same time.

While there are lots of SQL Server 2000 instances out there that run fine, that version is already out of mainstream support and so I think we'll see more and more companies moving to 2005, 2008, or SQL 11 at some point in the next 3-5 years and SQL Server 2000 will die out, just as SQL Server 7 and 6.5 have done over the last 9 years.

What does this mean for support? The Microsoft support lifecycle says that each product will get 5 years of mainstream support, or 2 years after the next version is released, whichever is longer. So by my calculations, our support lifecycle should look like this:

SS9 SS10 SS11 SS12 SS13 SS14
11/1/2005 RTM
8/1/2008 RTM
11/1/2010 EOS
2/1/2011 RTM
8/1/2013 EOS RTM
2/1/2016 EOS RTM
8/1/2018 EOS RTM

In the table above I have RTM as the release date, the build version instead of the product name, EOS as the end of mainstream support, and I've assumed a 30 month development cycle for each version of SQL Server. If SQL Server were to release every 24 months, things get more crowded.

So in 2011, which isn't far away, I could easily see many companies with a 2005 (v9) / 2008 (v10) mixed environment, with some old 2000 servers hanging on that are trying to get migrated to a new version and potentially the desire to adopt v11 for specific instances to take advantage of new features.

As I mentioned in the other editorial, this is a double edged sword. On one hand we will need to learn about new features constantly, but we should have ample opportunity to use those skills for a long time. I'm just glad Microsoft will give us at least 5 years of support for all versions.

At least for now.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.mevio.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 122 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Which Versions of SQL Server Do You Have?

This week Steve Jones asks about the versions of SQL Server that you have to support in your daily j...

FORUM

Anyone knows supporting version of ERWin

Anyone knows supporting version of ERWin

BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

FORUM

SQL Server 2005 SP1 - supported o/s versions

SQL 2K5 SP1 not supported on Windows Server 2008?

FORUM

SQL Server 2008 Error: the server version is not supported. the target server must be sql server 2000 or later.

SQL Server 2008 Error: the server version is not supported. the target server must be sql server 200...

Tags
editorial    
sql server    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones