What is SQL Server?

MS SQL Server is a RDBMS (Relational Database Management System) product designed and marketed by Microsoft. First SQL Server was launched by Microsoft on Arpil 24, 1989 with version 1.0. Sql Server is written in C and C++ languages.

The main purpose of this product is to be used for storing and retrieving data from it into different applications. Your application can be run on internet or on local computer which can connect MS SQL Server database and manipulate the data.

MS SQL Server supports ANSI SQL (A Structured Query Language) which is a standard SQL language. But, again T-SQL which is known as Transact SQL introduced as SQL language implemented by MS SQL Server.

From October 2016, MS SQL server is available for Linux as well. Before that, it was exclusively made and available for window environment only. Microsoft made it available for both window and Linux with MS SQL Server 2017 version.

SSME – SQL Server Management Studio which provides an interface to connect MS SQL Server to manage different features of SQL Server and databases. This product built by Microsoft as well which is widely used to connect MS SQL Server.

Different Editions of MS SQL Server
There mainly three editions used to manage databases with MS SQL Server are Enterprise, Standard, Web, Developer and Express. However, there are few more but they are not widely used for database management. Few are Workgroup, Compact Edition, Data Center, BI (Business Intelligence) but they are having their own benefits to use.

Enterprise Edition:
NOT a FREE! Enterprise edition is having all the features from Standard edition including powerful security, encryptions, backups, user defined role management and advanced feature to manage database in MS SQL Server. This edition is widely used to design and develop enterprise level application. For pricing details you may visit Microsoft website.

Standard Edition:
One FREE Core! After that each ADC code cost per year. For pricing details you may visit Microsoft website. This edition is widely used in small level organisation to build application and manipulate data in MS SQL Server database. It delivers a basic database management and support common development tools with minimal IT resources in small organisations.

Web Edition:
To use web edition for MS SQL Server, it is necessary to obtain license. It is required to pay a reduced rate (“base rate”) on SQL Database vCore-based options such as managed instance, vCore-based single database and vCore-based elastic Pool; on SQL Server in Azure Virtual Machines. There are few difference in between Standard and Web editions which are max memory and max of cores. Standard and Web doesn’t have a online indexing which is there in Enterprise edition.

Developer Edition:
This can be used for development and test the application purpose only, not to configure it as a production environment. This edition let’s developer to create an application on top of the MS SQL Server and test it. It provide all the features from Enterprise edition but is licensed for use as a development and test the system. It can be used in non-production environment and take all the benefits of Enterprise edition features of MS SQL Server.

Express Edition:
FREE Edition! MS SQL Server Express edition is a version of Microsoft’s SQL Server RDBMS (Relational Database Management System) which is a free to download, install and use it. Express edition is ideal for development and production for desktop, web and small server applications. This edition is widely used to build small scale application for entry level and small organisations. It holds up to 10 GB storage for database but it doesn’t have SQL Agent features compare to other editions.

To download MS Sql Server, use below link
Download SQL Server