While many DBAs feel that "progressing" through the SQL Server versions (upgrading 2000 to 2005, etc.) is the safer route, SQL Server 2008 has been through quite a few paces at this point.

Each version of Microsoft’s SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask before your next upgrade. 1. Should My ...

SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. However, along the upgrade path, companies have also discovered key obstacles to achieving the new ...

Nevertheless, if a district decides to perform an in-place upgrade, it should check out the Upgrade Advisor tool that’s part of the SQL Server 2014 Feature Pack. Using SQL's Copy Database Wizard. If ...

Here are some tips for upgrading SQL Server licensing. SIGN UP: Get more news from the StateTech newsletter in your inbox every two weeks. 1. Determine which databases need to be upgraded. The first ...

If you are upgrading from SQL Server 2000, you may choose to purchase new hardware and go the migration route because of the significant differences. As always, it depends on your situation.

Earlier this summer, SQL Server 2008 and SQL Server 2008 R2 fell out of extended support from Microsoft. Next January, Windows Server 2008 and Windows Server 2008 R2 will go off extended support ...

SQL Server 2014’s efficient data compression further enhances analytical speed. “Users can load millions of rows into memory and then query them very quickly,” Larson says. Users who upgrade also can ...

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 ...

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 ...

Watch live demos of Upgrade Advisor and in-place upgrade features of SQL Server 2005. Printable Format. comments powered by Disqus. Featured. Quick Tip for Faster Vibe Coding with Agentic AI in VS ...