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

Just Keep Going and Going and Going

By Steve Jones,

Energizer BunnyI wrote about Energizer looking to outsource more of their infrastructure to Microsoft and this potentially being a source of revenue for Microsoft, and it might not be a bad idea. As I was writing that editorial, however, I had another thought about the implications of using Microsoft, or really anyone else, to host your infrastructure.

Most of us work in mixed environments, and have learned to support a variety of versions and platforms that have been installed for one reason or another over the years. Often we find outselves upgrading servers here and there as we can, usually when we change hardware.

We don't typically upgrade all servers in a weekend, though, spacing them out over time. As a result we often have multiple versions of SQL Server installed on our networks. At JD Edwards, we specifically undertook a project to move to SQL Server 2000 across hundreds of instances. It took months and even at the end we still had a few SQL Server 7 instances that couldn't move for one reason or another. I suspect that today those companies that have adopted SQL Server 2008 early still have 2005 instances and possibly even 2000 instances being used.

Microsoft has a support lifecycle that typically includes the current version of SQL Server and one previous version, so right now in 2008 they support SQL Server 2008 and SQL Server 2005. SQL Server 2000 still has some extended support options, as does SQL Server 7, but most of us wouldn't expect to get service on those versions.

In a hosted environment, I wouldn't expect Microsoft to be any different. Likely if they had a hosted service, they would be "end-of-lifing" SQL Server 2000 over the next year, forcing customers that used that platform to migrate to a newer one. That only makes sense as it ensures they make good use of their resources, mainly people, and limit the scope of what they have to support. It's not just Microsoft that does this as I'd expect any hosting company to limit how many versions of Oracle, DB2, Linux, or any software they offer.

As a result, I would expect anyone that operates in a hosted environment to be a regular upgrade treadmill to ensure their applications work on the latest version of Windows, SQL Server, and other software. That makes sense for some applications, perhaps Exchange, Office, and other software that's used as-is, but makes less sense for something like SQL Server that is a true platform on which other applications are built.

And not easily upgraded.

Upgrades are a fact of life, but usually at a time and place of your choosing, not when your outsourcer chooses. It makes me think that outsourcing might be a niche technology that we use in places where it makes sense, not necessarily as something we do for our entire infrastructure.

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

What Does Support Look Like?

With a new version of SQL Server being released every 2-3 years now, what does that mean for support...

BLOG

Microsoft Support Policies for Windows Server and SQL Server

Microsoft provides ten years of support (five years Mainstream Support and five years Extended Suppo...

BLOG

Microsoft Drops Support For Itanium after SQL Server 2008 R2

Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture a...

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

Tags
editorial    
hosting    
upgrading    
 
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