Pr.Pg Next Pg

SQL Server Versions tutorials

  • MS SQL Server 2012 is a new RDBMS System for developing and managing Database originally developed for the OS/2 operating system by Microsoft Corporation and later of SQL Server moved to the Windows operating system.

  • SQL Server’s engine received a major rewrite for version 7.0 and subsequent versions have continued to improve and extend SQL Server’s capabilities from the workgroup to large enterprises

The following table shows full history of MS SQL Server

 

MS-SQL Version Release Year
1.0 1989
1.1 1991
4.2 1992
4.21 1994
6.0 1995
6.5 1996
7.0 1998
2000 2000
2005 2005
2008 2008
2008 R2 2010
2012 2012

Brief History of SQL Server Versions

  • SQL Server has grown considerably over past 2 decades from its early roots with Sybase

  • SQL Server 1.0 was jointly released in 1989 by Microsoft, Sybase & Ashton-Tate (Dbase Developer). The product was based on Sybase SQL Server 3.0 for Unix and VMS.

  • SQL Server 4.2.1 for Windows NT was released in 1993. Microsoft began making changes to the code.

  • SQL Server 6.0 (code-named SQL 95) was released in 1995. In 1996, the 6.5 upgrade (Hydra) was released. It included the first version of Enterprise Manager (StarFighter I) and SQL Server Agent (StarFighter II).

  • SQL Server 7.0 (Sphinx) was released in 1999, and was a full rewrite of the Database Engine by Microsoft. From a code perspective, this was the first Microsoft SQL Server. SQL Server 7 also included English Query (Argo), OLAP Services (Plato), replication, Database Design and Query tools (DaVinci) and Full-Text Search (aptly code-named Babylon.) Data Transformation Services (DTS) is also introduced.

  • SQL Server 2000 (Shiloh) 32-bit, version 8, introduced SQL Server to the enterprise with clustering, much better performance. It supported XML though three different XML add-on packs. It added userdefined functions, indexed views, clustering support, Distributed Partition Views, and improved replication. SQL Server 2000 64-bit version for Intel Itanium (Liberty) was released in 2003.

  • SQL Server 2005 (Yukon), version 9, was another rewrite of the Database Engine and pushed SQL Server further into the enterprise space. Management Studio replaced Enterprise Manager and Query Analyzer. DTS is replaced by Integration Services. SQL Server 2005 supported 32-bit, 64x, and Itanium CPUs.

  • SQL Server 2008 (Katmai), version 10, is a natural evolution of SQL Server, adding Policy-Based Management, data compression, Resource Governor, and new beyond relational data types.

  • SQL Server 2008 R2 ( Version 10.50.1600.1, formerly codenamed "Kilimanjaro") was announced at TechEd 2009, and was released to manufacturing on April 21, 2010.

  • SQL Server 2012 (codenamed "Denali"), It was released to manufacturing on March 6, 2012. SQL Server 2012 Service Pack 1 was released to manufacturing on November 9, 2012.

Note:

  • SQL Server 2008 R2 is not service pack for SQL Server 2008. It is an independent SQL version 10.5 with enhanced multi-server management capabilities.

 


 

Pr.Pg border                                              Next Pg