June 17, 2024

MS SQL Server

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++
OS: Windows
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:

  • Enterprise
    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.
  • Standard
    It is designed for small and medium organizations. It also supports e-commerce and data warehousing.
  • Workgroup
    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.
  • Express
    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.

Rashedul Alam

I am a software engineer/architect, technology enthusiast, technology coach, blogger, travel photographer. I like to share my knowledge and technical stuff with others.

View all posts by Rashedul Alam →

5 thoughts on “MS SQL Server

Comments are closed.