Software

Comparing SQL 2005 to SQL 2014

Microsoft says that SQL Server 2014 is faster and delivers improved performance.

Twitter

Phil Goldstein is a former web editor of the CDW family of tech magazines and a veteran technology journalist. He lives in Washington, D.C., with his wife and their animals: a dog named Brenna, and two cats, Grady and Princess.

Microsoft will end support for SQL Server 2005 on April 12, forcing users to switch to another SQL Server version or put themselves at risk for security breaches. For those ready to make the switch, SQL Server 2014 provides a number of benefits over the 2005 edition.

Microsoft touts several improvements:

• 100 times better query performance
• 30 times faster online transaction processing
• 13 times faster than SQL Server 2005