UrbanPro
true

Learn DBA from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

History of SQL server

Rahul J Rajesh
13/05/2017 0 0

In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop a new version of SQL Server for the NT platform. While it was under development, Microsoft decided that SQL Server should be tightly coupled with the NT operating system. In 1992, Microsoft assumed core responsibility for the future of SQL Server for NT. In 1993, Windows NT 3.1 and SQL Server 4.2 for NT were released. Microsoft's philosophy of combining a high-performance database with an easy-to-use interface proved to be very successful. Microsoft quickly became the second most popular vendor of high-end relational database software. In 1994, Microsoft and Sybase formally ended their partnership. 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. In 1996, Microsoft released version 6.5 of SQL Server. This version brought significant enhancements to the existing technology and provided several new features. In 1997, Microsoft released version 6.5 Enterprise Edition. In 1998, Microsoft released version 7.0 of SQL Server, which was a complete rewrite of the database engine. In 2000, Microsoft released SQL Server 2000. SQL Server version 2000 is Microsoft's most significant release of SQL Server to date. This version further builds upon the SQL Server 7.0 framework. According to the SQL Server development team, the changes to the database engine are designed to provide an architecture that will last for the next 10 years.

 

Prior to version 7.0 the code for MS SQL Server was sold by Sybase SQL Server to Microsoft, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM DB2, and, later, Sybase.

Rather than listing all the new features and enhancements found in 2000, I've decided to list my favorite changes. The remainder of this chapter is dedicated to discussing these new features found in version 2000.

Version

Year

Release name

Code name

Internal version

1.0 (OS/2)

1989

SQL Server 1.0 (16 bit)

Ashton-Tate / Microsoft SQL Server

-

1.1 (OS/2)

1991

SQL Server 1.1 (16 bit)

-

-

4.21 (WinNT)

1993

SQL Server 4.21

SQLNT

-

6

1995

SQL Server 6.0

SQL95

-

6.5

1996

SQL Server 6.5

Hydra

-

7

1998

SQL Server 7.0

Sphinx

515

-

1999

SQL Server 7.0 OLAP Tools

Palato mania

-

8

2000

SQL Server 2000

Shiloh

539

8

2003

SQL Server 2000 64-bit Edition

Liberty

539

9

2005

SQL Server 2005

Yukon

611/612

10

2008

SQL Server 2008

Katmai

661

10.25

2010

Azure SQL DB

Cloud Database or CloudDB

-

10.5

2010

SQL Server 2008 R2

Kilimanjaro (aka KJ)

665

11

2012

SQL Server 2012

Denali

706

12

2014

SQL Server 2014

SQL14

782

13

2016

SQL Server 2016

 

852

14.0

2017

SQL Server 2017

Helsinki

 

 

 

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Top 10 SQL Concepts for Job Interview
1. SELECT and FROM: This is the “heart” of any SQL query - SELECT columns FROM table.2. WHERE: This acts as a filter and allows you to select only relevant rows based on conditions.3. GROUP...

What is PowerPoint?
PowerPoint is a complete presentation graphics package. It gives you everything you need to produce a professional-looking presentation. PowerPoint offers word processing, outlining, drawing, graphing,...

Cursors In SQL Server
First thing first Usage of Cursors is not encouraged in SQL Server as they are slow. You may go with While loop if you need to iterate through a recordset. Cursor is a database object to retrieve data...

What is database backup? How backup works in SQL Server?
Database Backup in normal terms can be said as a copy of data which can be used in a situation when the things go wrong with your system/server. If your role is IT/Database Administrator, then it is your...

New Features Worth Exploring in SQL Server 2016
New Features Worth Exploring in SQL Server 2016 There is a lot of buzz around SQL Server 2016. Microsoft announced the release of SQL Server 2016 at the Microsoft Ignite Conference during the first...
X

Looking for DBA Classes?

The best tutors for DBA Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn DBA with the Best Tutors

The best Tutors for DBA Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more