THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Databases are the longest-lived component

Most of you know that I write a technical article each week for the InformIT website - you can see a list of all my articles here. I’ve been writing for that site for – well, a really long time. I have articles all the way back to SQL Server version 7! The question was that we saw a huge uptick for an older SQL Server article there. A question was posed as to whether we should update that article, or remove it since it was on SQL Server 2000. My response? No!

 

In many firms I work with, the database is the last component to be upgraded. This is true not only with SQL Server, but with Oracle, DB/2 and even PostGres. Why is that? Well, for one thing, it’s the core of the development system – the data store. Changing it often is disruptive. Another factor is “it’s working, leave it alone”. Now I’m not advocating that behavior – I’ve written extensively that you should evaluate each release to see if the benefits it provides outweigh the cost of making the change, and I stand by that. But the fact of the matter is that there is still a lot of SQL Server 2005 out there, even 2000, when we’re up to ten years out of those releases.

 

So you’ll still see hundreds of articles on the sites I write for that contain older content. It’s marked that way, and we link to newer articles, but you still have a resource if you’re on an older system. Hopefully you’ll find those useful.

Published Thursday, September 09, 2010 7:39 AM by BuckWoody
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Mateus said:

Hell, I'm working with SQL Server 2000!

September 9, 2010 12:27 PM
 

@Mushtaq_M said:

At previous work place they run SAP on SQL 2000 and they didn't had any immediate plans to upgrade.

September 9, 2010 2:39 PM
 

Denny Cherry said:

To go along with that the book that I'm currently working on specifically covers SQL 6.5 to current noting where things are different between the older (2000 and back) versions and the newer versions (2005+) specifically because people are using those older versions long past the supported period.

September 9, 2010 3:18 PM

Leave a Comment

(required) 
(required) 
Submit

About BuckWoody

http://buckwoody.com/BResume.html

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement