Tuesday, July 23, 2013

The Evolution of SQL Server

In 1985, Microsoft and IBM announced "a long-term joint development agreement for development of operating systems and other systems software products.“

This announcement was the beginning of OS/2, a successor to the Microsoft MS-DOS operating system. OS/2 would be a more complete and robust operating system.

OS/2 was formally announced in April 1987, with shipment promised by the end of the year.

But shortly after the joint declaration, IBM announced a special higher-end version of OS/2 called OS/2 Extended Edition. This more powerful version would include the base OS/2 operating system plus an SQL RDBMS called OS/2 Database Manager (now famous as DB/2)

But if IBM could offer a more complete OS/2 solution, who would buy Microsoft OS/2? Clearly, Microsoft needed to come up with an answer to this question.
Microsoft needed a database management system (DBMS) product, hence Microsoft turned to Sybase, Inc., an upstart in the DBMS market. The deal between the two companies was a win-win situation.

In 1988, a new product was announced with the somewhat clumsy name Ashton-Tate/Microsoft SQL Server. This new product would be a port of Sybase DataServer to OS/2, marketed by both Ashton-Tate and Microsoft.

Ashton-Tate, Microsoft, and Sybase worked together to debut SQL Server on OS/2. (This was the first use of the name SQL Server). Today, Sybase's database server is known as Sybase Adaptive Server

The following timeline summarizes the development history of SQL Server:

- 1987 Sybase releases SQL Server for UNIX.

- 1988 Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2.

- 1989 Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2.

- 1990 SQL Server 1.1 is released with support for Windows 3.0 clients.
           
             Aston-Tate drops out of SQL Server development.

- 1991 Microsoft and IBM end joint development of OS/2.
- 1992 Microsoft SQL Server 4.2 for 16-bit OS/2 1.3 is released.

- 1992 Microsoft and Sybase port SQL Server to Windows NT.

- 1993 Windows NT 3.1 is released.

- 1993 Microsoft and Sybase release version 4.2 of SQL Server for Windows NT.

- 1994 Microsoft and Sybase co-development of SQL Server officially ends.

           Microsoft continues to develop the Windows version of SQL Server.

          Sybase continues to develop the UNIX version of SQL Server.

- 1995 Microsoft releases version 6.0 of SQL Server.

- 1996 Microsoft releases version 6.5 of SQL Server.

- 1998 Microsoft releases version 7.0 of SQL Server.

-2000 Microsoft releases SQL Server 2000.

-2001 Microsoft releases XML for SQL Server Web Release 1 (download).

-2002 Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).

-2002 Microsoft releases SQLXML 3.0.

- 2005 Microsoft releases SQL Server 2005 on November 7th, 2005.

-2008 Microsoft releases SQL Server 2008

-2011 Code Name Denali Announced

-2012 SQL Server 2012 Officially Released RTM is Ready

-2014 SQL Server 2014 (CodeName Hekaton) Officially Released RTM is Ready