MS SQL Server History and Advantages

  • Home
  • /
  • Blog
  • /
  • MS SQL Server History and Advantages
Try Free SQL Trainer - learn by doing!
SQL queries made easy - Natural Questions to SQL Converter.
Microsoft SQL server or more commonly known as MS SQL server is a relational database server developed by Microsoft Corporation. A database server is basically a database application which is used to store data and other software applications retrieve and store data using some language which is called SQL (Structured Query Language) in case of MS SQL server. The client application which accesses data from the database server can be on the same machine or on different machine and can access the data via a set of protocols and internet. Microsoft has developed wide variety if MS SQL server editions keeping in view the type of audience that use database server products. MS SQL Server editions are available for large enterprises, medium scale organizations to individuals.
History
In the year 1987, Microsoft joined hands with Sybase Solutions in order to develop a database management system which could compete with the then existing giants like IBM and Oracle. It was decided that Sybase will have all the selling rights and profit earned from the product version designed for the Non-Microsoft platform while Microsoft will have exclusive rights of the database product designed for Microsoft Platforms. Hence the first database server product was released around 1989. Later on Sybase sold all the rights to Microsoft and now the product name was changed to MS SQL Server. Till now, around 15 versions of this product have been released.
Version
Year
Release Name
Codename
1.0
(OS/2)
1989
SQL Server 1.0
(16 bit)
1.1
(OS/2)
1991
SQL Server 1.1
(16 bit)
4.21
(WinNT)
1993
SQL Server 4.21
SQLNT
6.0
1995
SQL Server 6.0
SQL95
6.5
1996
SQL Server 6.5
Hydra
7.0
1998
SQL Server 7.0
Sphinx
1999
SQL Server 7.0
OLAP Tools
Palato mania
8.0
2000
SQL Server 2000
Shiloh
8.0
2003
SQL Server 2000
64-bit Edition
Liberty
9.0
2005
SQL Server 2005
Yukon
10.0
2008
SQL Server 2008
Katmai
10.25
2010
SQL Azure DB
CloudDatabase
10.5
2010
SQL Server 2008 R2
Kilimanjaro (aka KJ)
11.0
2012
SQL Server 2012
Denali
12.0
2014
SQL Server 2014


Source: www.wikipedia.com
Advantages
Like other Microsoft products, MS SQL Server comes with bundle of benefits for the average users.
  • Easy Installation
All the Microsoft products are easy to install with one click installation procedure and readable GUI with lots of instructions for the layman. MS SQL Server contains all these characteristics and it has extremely user friendly installation interface unlike other database servers which requires extensive command line configurations.
  • Improved Performance
MS SQL server contains excellent compression and encryption capabilities that result in improved data storage and retrieval functions.
  • Security
MS SQL server is considered one of the most secure database servers with complex encryption algorithms making it virtually impossible to crack the security layers enforced by the user. MS SQL server is not an open source database server which reduces the risk of attacks on the database server.
  • Multiple Editions and Price Variations.
A good thing about MS SQL server is that it is available in multiple editions in order to cater the needs of huge corporate sector organizations to a domestic user. The price range also varies which allows anyone to buy the product which meets their price range.
  • Excellent Data Restoration and Recovery Mechanism

MS SQL server is fully aware of the importance of your data. Hence MS SQL Server contains many sophisticated features that allow you to recover and restore the data which has been lost or damaged. Although you cannot recover individual records but it is possible to restore complete database using some advanced recovery tools contained in MS SQL Server database.

prev
next