Tag Archives: upgrades

We Do Need To Upgrade

Posted on February 3, 2018 by

I advocate that we should get a long life from our database platforms. In fact, I like to think about a 7-10 year lifetime for many of my database instances. That means I’ll get beyond the 5 year lifetime that … Continue reading →

Posted in Editorial | Tagged , , | Leave a comment

It’s Time to Patch and Upgrade

Posted on January 5, 2018 by

I don’t want to be chicken little here, but the Meltdown/Spectre bugs have me concerned. I don’t know the scope of the vulnerabilities, as far as exploits go, but I do know the lax ways in which humans interact with … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

How Long Before You Upgrade?

Posted on November 10, 2017 by

This editorial was originally published on Apr 11, 2014. It is being re-published as Steve is out of town, with a few minor changes to dates and values. It’s 2017. SQL Server 2000 is 17 years old, but there are … Continue reading →

Posted in Editorial | Tagged

The Migration Checklist

Posted on March 8, 2017 by

One of the things I always recommend is that when you upgrade a SQL Server instance, you perform a side by side migration to a new host instead of an in-place upgrade. My main concern is risk. While the upgrade … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

What’s Your Test Plan?

Posted on May 20, 2016 by

I ran across a post on upgrading a SQL Server instance, where the original poster (OP) was asking about a document to upgrade from SQL Server 2008 to 2014. That’s a big ask, especially as not many documents tend to … Continue reading →

Posted in Editorial | Tagged , ,

The Push to Upgrade from SQL Server 2005

Posted on February 12, 2016 by

It was interesting to see the results of my straw poll last week on SQL Server 2005. Quite a few people still run that version, and some aren’t looking to upgrade anytime soon. However when support ends, you should be aware that … Continue reading →

Posted in Editorial | Tagged ,

Who’s Got a Preteen SQL Server?

Posted on February 5, 2016 by

This year we will have the end of extended support for SQL Server 2005. Microsoft has been reminding people they should upgrade, which may be important if your organization requires support for the running software. Personally I think if you’re still … Continue reading →

Posted in Editorial | Tagged ,

The Case for Upgrading

Posted on September 3, 2015 by

I heard from a member of the community that’s still on SQL Server 2005 recently. Yes, 2005. That’s an old, unsupported version, but they’ve got some Access/VBA apps that work well and aren’t worth investing a lot of development effort … Continue reading →

Posted in Editorial | Tagged ,

vNext 2016

Posted on May 7, 2015 by

We have a name for the next version of SQL Server: SQL Server 2016. I suspect the internal build may be v14, which I guess makes sense if you’re superstitious about the number 13, or you think your customers are. There are plenty … Continue reading →

Posted in Editorial | Tagged ,

Is It Time to Upgrade?

Posted on April 30, 2015 by

There was a post from the SQL Server Data Platform Advisor the other day that noted it’s been almost 10 years since SQL Server 2005 was released and it’s time to upgrade. At least, if you want to remain in support. Microsoft … Continue reading →

Posted in Editorial | Tagged ,