Migrating a Large Database

Large database upgrades are stressful, but a little planning and practice can help things go smooth.

The Slow Upgrade of SQL Server Versions

It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.

Upgrades are Hard

Upgrades are hard, as Stack Exchange shows us.

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.