In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an ...

Upgrade your existing SQL Server systems painlessly with expert help from Jennifer Perret.

Run the SQL Server 2014 Upgrade Advisor, and use the recommendations to plan the upgrade. Make sure a working backup and a watertight rollback plan exists. Fix page count inaccuracies and run database ...

For instance, the SQL Server Upgrade Advisor can uncover compatibility issues. SQL Server 2014 can run older versions of the database, which can help bridge legacy applications.

An example: the value of monitoring tools, such as Microsoft’s SQL Server Upgrade Advisor and Installation Center, which provide agencies with ongoing support as they migrate to a new version. These ...

SQL Server 2008/R2 is nearing the end of Microsoft’s extended service period. We’ll cover some of the reasons that business are slow to upgrade from older releases of SQL Server, as well as ...

SQL Server 2014 isn't Microsoft's first upgrade to SQL. Microsoft had an upgrade in 2008 and again in 2012 but 2014 offers some significant upgrades, especially from the 2005 version.

SQL Server 2005s shipping delays have helped its competitors to move ahead in these areas. The last major SQL Server upgrade was SQL Server 2000, now considered an outdated product, Yuhanna said.

Get tips for updating to Microsoft SQL Server 2014, including using SLQ's Copy Database Wizard and a checklist with key tasks to complete during your migration plan.