History of Sql Server

History of Sql Server :

As a dot net developer mostly we were using MS Sql Server as a applications database. J

Let’s go through  the history of MS SqlServer :

1.       The 1^st version of Sql Server has been released on 1988. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase.

2.       During the early 1990s, Microsoft began to develop a new version of SQL Server 1.1 for the NT platform. While it was under development, Microsoft decided that SQL Server should be tightly coupled with the NT operating system.

3.       In 1992, Microsoft assumed core responsibility for the future of SQL Server 4.21 for NT.

a.       16 bit Originally for OS/2 release in 1992.

4.       1993, Windows NT 3.1 and SQL Server 4.2 for NT were released.

5.       In 1994, Microsoft and Sybase formally ended their partnership.

6.       In 1995, Microsoft released version 6.0 of SQL Server. This release was a major rewrite of SQL Server's core technology. Version 6.0 substantially improved performance, provided built-in replication, and delivered centralized administration.

7.       In 1998, Microsoft released version 7.0 of SQL Server, which was a complete rewrite of the database engine.

8.       In 2000, Microsoft released SQL Server 2000. SQL Server version 2000 is Microsoft's most significant release of SQL Server to date.   

a.       Build to work with Windows Server 2000

b.      This is the debut of Analysis Services.

c.       Sql Serve reporting services.

9.       In 2005, Sql Server 2005.

a.       This made to work with Windows server 2003.

b.      Support .net in Sql Server i.e. SQL CLR .

c.       Integration Services.

d.      Full integration of reporting services.

e.      Database Mirroring.

f.        Tighter XML integration

g.       Schemas J

10.   In 2008, Sql Server 2008

a.       Transparent data integration

b.      Policies management

c.       Geo-spital data and data types.

d.      Files Stream

e.      Backup compression.

f.        New Data types :

                                                               i.      Date

                                                             ii.      Time

                                                            iii.      Datetimeoffset

                                                           iv.      Datetime2

                                                             v.      Geometry

                                                           vi.      Geography

11.   In 2010, Sql Server 2008 R2

a.       Unicode Compression

b.      Power Pivot, Report Builder 3.0

12.   In 2012, Sql Server 2012

a.       Build for Windows Server 2012

b.      AlwaysOn

c.       ColumnStore Indexes

d.      User Defined server role

e.      Sequence Object

f.        Error Handling. and .....

13.   In 2014, Sql Server 2014

a.       Build for Windows Server 2012 R2

b.      In Memory OLTP

c.       Evolvement of ColumnStore index.

d.      Allows using superfast SSD drives for buffer. .....

References :

1.       http://www.informit.com/articles/article.aspx?p=30167

2.       http://www.youtube.com/watch?v=cgkluDl0q_k

Summary : In this post we have discussed about history of Sql server.Please provide your valuable comments and share your thoughts , which will be useful for all in the future.