MS SQL Server is a computer application that is primarily used to store and retrieve data. This program is developed by Microsoft Corporation. At present most of the developing applications are data related. MS SQL Server is playing a good role. This article express basic overview of MS SQL Server. Summary of the article:
- MS SQL Server
- History of MS SQL Server
- Versions of MS SQL Server
- Editions of SQL Server
- Editions of SQL Server
Developer: Microsoft Corporation
Initial Release: SQL Server 1.0, 1989
Stable Release: SQL Server 2014
Written in: C++
Available in: English, Chinese, French, German, Italian, Japanese, Korean, Portuguese, Russian and Spanish
License: Proprietary software; both commercial and freeware editions are available
Website: SQL Server site
MS SQL Server
Microsoft SQL Server or MS SQL Server or SQL Server or MSSQL is a Relational Database Management System or RDMS. It is developed by Microsoft Corporation. Like others major RDMS it support ANSI SQL. It runs on T-SQL including exception and error handling, transaction control, row processing, and variables. It has a GUI environment to manage the server graphically called SQL Server Management Studio or SSMS (previously known as Enterprise Manager). SQL Server Management Studio is SQL Server’s main interface tools.
History of MS SQL Server
MS SQL Server originally released in 1989 as version 1.0 with the partnership of Microsoft and Sybase. SQL Server and its early versions were very similar to Sybase. In the early 1990s Microsoft-Sybase partnership dissolved. Microsoft retained the rights to the SQL Server trade name. Since then, Microsoft has released server versions like 2000, 2005, 2008 and … Every version has more advanced options, features and better security.
Versions of MS SQL Server
The version of SQL Server is given bellow:
- SQL Server 7.0
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008
- SQL Server 2008 R2
- SQL Server 2012
- SQL Server 2014
Editions of SQL Server
SQL Server offer several editions with different feature and price to meet a variety of user needs. SQL Server editions are given bellow:
It is designed for large enterprises with complex data requirements, large data, data warehousing, and web-enabled databases. It has all the features of SQL Server. It is the most expensive edition.
It is designed for small and medium organizations. It also supports e-commerce and data warehousing.
It is design for small organizations. It has no size or user limits and may be used as the backend database for small web servers or branch offices.
It is free for distribution. It has the fewest number of features and limits database size and users. It may be used as a replacement for an access database.
MS SQL Server is now widely used in desktop, web base applications. Its features are rich and day by day it is updating. Today it is competing nicely with others RDBMS competitors.