June 23, 2013
SP2520
Unit 1 Research Assignment 1: Exploring Programming Languages
From the looks of it there seems to be 14 different revisions of the SQL standard. * SQL Server version 1.0: SQL Server version 1.0 is a 16 bit server modeled in the year 1989 for supporting OS/2. * SQL Server version 1.1: SQL Server version 1.1 is also a 16 bit server designed in the year 1991 to support OS/2. * SQL Server version 4.2: SQL Server version 4.2 was released in the year 1992. SQL 4.2 is bundled with IBM OS/2 1.3 version. * SQL Server version 4.21: In the year 1993, Microsoft server 4.21 came into existence. SQL 4.21 was the first version of SQL Server that supports Windows NT. * SQL Server version 6.0: In 1995, SQL Server version 6.0 was introduced. After Windows NT, Sybase and Microsoft parted and worked on their individual design. SQL Server version 6.0 was the chief version aimed in provision of Windows NT by Microsoft. * SQL Server version 6.5: SQL Server version 6.5 got released in the year 1996. * SQL Server version 7.0: SQL Server version 7.0 was the rewritten version from Sybase legal code. The code name of SQL Server version 7.0 is Sphinx. SQL Server version 7.0 was introduced in 1998. In 1999, SQL Server version 7.0 with OLAP tools came into site. * SQL Server version 8.0 / SQL Server version 2000: SQL Server version 2000 was the first one made of IA-64 architecture. Several advancements have been made in SQL Server version 2000 which improved its performance. Later in the year 2003, SQL Server version 2000 with 64-bits was released. * SQL Server version 9.0/ SQL Server version 2005: SQL Server version 2005 was released in October, 2005. SQL Server version 9.0/SQL Server version 2005 offers enhanced support for XML data apart from relational data and also IDE tools, an ETL tool, an OLAP server and many more. * SQL Server version 2008 or SQL Server version 10.0 version: SQL Server version 2008 was
References: Rapid Programming: http://www.rapidprogramming.com/questions-answers/What-are-the-different-versions-of-SQL-Server-and-when-was-it-released--638 MSDN: http://msdn.microsoft.com/en-us/library/ms143694.aspx MSDN: SQL Server Express Features: http://msdn.microsoft.com/en-us/library/ms165636(v=sql.90).aspx BC Burleson Consulting: http://www.dba-oracle.com/t_xe_features_oracle_express.htm