In this article I will tell you the Microsoft SQL Server database management system history and editions.
Microsoft has seen Kingdom of Oracle in the database management system market and Decided to produce new Database. Microsoft has purchased Sybase in 1989 and thus SQL Server 1.0 has been released for the first time in 1989. Microsoft SQL Server 1.0, which is essentially the same as Sybase SQL Server 3.0, started to compete with Oracle with SQL Server 2008 version. Microsoft has changed all database engine with SQL Server 2005.
SQL Server is a relational database management system if we say it in the most basic sense. With SQL Server, you can handle very large amounts of data and store them securely. You can analyze stored data. In addition, requests from Client with SQL Server are met within a short time.
With SQL Server, OLTP (Online Transaction Processing) databases and OLAP (Online Analytical Processing) databases can be administered. While OLTP-type databases are a type of database that records all operations on a Production system, OLAP databases are larger than the OLTP databases, and are typically used to perform Analysis and reporting.
There are different editions of SQL Server developed for different purposes and situations. These are as follows.
- SQL Server Enterprise Editon : It is a version that includes all components and features for the Enterprise companies ( Banks, Insurance, hospital, Universities )
- SQL Server Standart Editon : It is a product developed for medium and small businesses.
- SQL Server Workgroup Edition — Expired
- SQL Server Personal Editon — Expired
- SQL Server Developer Editon
- SQL Server Express Edition
- SQL Server WEB Edition
- SQL Server Desktop Engine — Expired
SQL Server was a software that runs on Windows operating system and also on Windows servers.
But SQL Server runs on both Windows Operating system, Windows Server and Linux Server with SQL Server 2017 version.
SQL Server is also available for Linux anymore.
Some of the services that the SQL server uses are as follows.
- MS SQL Server
- SQL Server Agent
- Microsoft Distributed Transaction Coordinator (MS DTC)
MS SQL Server : It is the core of relational database management system. Execute the SQL and T-SQL statements from the Client and manages them accordingly. It also administer queries and users data at the same time.
SQL Server Agent : It is a service that serves as the Agent of our database. This service works instead of us,when we create a job that we want to do operations, Agent does instead of us. it is a service that can perform backups, receiving snapshots, sending e-mails, rebuild index etc automatically.
Microsoft Distributed Transaction Coordinator (MS DTC) : It is a service that administer transactions on the database. It is used to administer transactions in different database and architecture.