The Impediments to Change

SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]

The Minimum Upgrade Point

Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.

Localized Upgrades

Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.

Mission Critical: SQL Server Upgrade

You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.

Database Server Upgrades – The Plan, The Template, and The Task List

This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.

Testing a SQL Server environment before an upgrade

Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.

Does Upgrading to SQL Server 2008 Fit Your Business?

While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.

Upgrade Strategies for SQL Server 2008

If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.

Restoring a database during SQL Server upgrade

Part 2 in this upgrade series lists the steps to point application traffic at a transition server while the primary cluster is rebuilt to Windows Server 2003 and SQL Server 2005.