What versions are right for your business?
As the second most popular database in the market, SQL Server has numerous different versions that are designed to cater for different workloads.
Developed by Microsoft and implementing the Structured Query Language (SQL), the database comes as software, and is predominantly used for the storing and retrieving of data which has been requested by other software applications.
Several different versions of SQL Server exist, including a free version called SQL Server Express which is limited in size but provides a handy test environment for application development.
SQL Server 2005 is the oldest version but cumulative updates have stopped for it. Following that is SQL Server 2008 and SQL Server 2008 R2, like the 2005 version there are no more cumulative updates available.
The oldest version that still receives updates is SQL Server 2012, the most recent update was in May 2016. SQL Server 2014 was the newest version until SQL Server 2016 was released, and that was also updated in May 2016.
Microsoft recently released its latest version with SQL Server 2016. This version comes in four editions: Standard, Enterprise, Express, and Developer.