SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. Many IT professionals agree that the AlwaysOn Availability Group (AG) feature offers the most value with its ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to the new internal format but retains a Compatibility Level of “80” which represents SQL 2000 aka SQL 8.0.

I have an installation of Sharepoint Foundation 2010 with a SQL 2010 Express backend on a 2008 server. We need to overcome the 10GB/database limit of SQL Express and so we're going to upgrade to SQL ...

Alan Joch has been an independent business and technology writer for more than a decade. His expertise includes server and desktop virtualization, cloud computing, emerging mobile applications, and ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

You are not alone if your databases are running on an older version of SQL server. Upgrading a database is a complex project that must be planned and executed ...

Sometimes, life really is like a box of chocolates. The same can also be said for software upgrades. Take, for instance, Visual Studio 2008. After all its various CTPs and RTMs, I feel like I've been ...

As SQL Server 2008 and 2008 R2 reach end of support in July 2019, avoid business disruptions, enhance performance, improve compliance, and reduce costs by implementing a quick, simple, and low-impact ...

With the economy taking a dive many IT managers are concerned over spending and not too sure if they should upgrade their database applications to SQL Server 2008. The latest features and ...