Hi,
I will explain the SQL Server Version List, 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 made partnership with 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.
All Released Microsoft SQL Server Versions List until today is as follows.
Release |
RTM (no SP) |
Latest CU |
|||
|---|---|---|---|---|---|
| SQL Server 2019
SQL Server latest version
SQL Server 15 |
15.0.2000.5 | CU4 for 2019 (15.0.4033.1 – March 2020) SQL Server 2019 builds | |||
| SQL Server 2017
SQL Server 14
codename vNext Support end date: 2022-10-11 Ext. end date: 2027-10-12 |
14.0.1000.169 | CU20 (14.0.3294.2, April 2020)
CU18 (14.0.3257.3 Latest build) December 09, 2019 CU17 (14.0.3238.1, October 2019) |
|||
|
Service Packs won’t be released with SQL Server 2017
|
|||||
| SP1 | SP2 | SP3 | SP4 | ||
| SQL Server 2016
SQL Server 13
Support end date: 2021-07-13 Ext. end date: 2026-07-14 |
13.0.1601.5 | 13.0.4001.0 or 13.1.4001.0 + CU15
|
13.0.5026.0 or 13.2.5026.0 + CU13
|
||
| SQL Server 2014
SQL Server 12
Support end date: 2019-07-09 Ext. end date: 2024-07-09 |
12.0.2000.8 | 12.0.4100.1 | 12.0.5000.0 | 12.0.6024.0 | |
| SQL Server 2012
SQL Server 12
Support end date: 2019-07-09 Ext. end date: 2024-07-09 |
11.0.2100.60 | 11.0.3000.0 | 11.0.5058.0 | 11.0.6020.0 | 11.0.7001.0 |
Obsolete versions – Out of support
|
|||||
| SQL Server 2008 R2
SQL Server 10.5
codename Kilimanjaro Support end date: 2014-07-08 Ext. end date: 2019-07-09 |
10.50.1600.1 | 10.50.2500.0 | 10.50.4000.0 | 10.50.6000.34 | |
| SQL Server 2008
SQL Server 10
codename Katmai Support end date: 2014-07-08 Ext. end date: 2019-07-09 |
10.0.1600.22 | 10.0.2531.0 | 10.0.4000.0 | 10.0.5500.0 | 10.0.6000.29 |
| SQL Server 2005
SQL Server 9
codename Yukon Support end date: 2011-04-12 Ext. end date: 2016-04-12 |
9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
| SQL Server 2000
SQL Server 8
codename Shiloh Support end date: 2008-04-08 Ext. end date: 2013-04-09 |
8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| SQL Server 7.0
SQL Server 7
codename Sphinx Support end date: 2005-12-31 Ext. end date: 2011-01-11 |
7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
| SQL Server 6.5
SQL Server 6.50
codename Hydra Support end date: 2002-01-01 |
6.50.201 | 6.50.213 | 6.50.240 | 6.50.258 | SP4 6.50.281 SP5 6.50.416 |
| SQL Server 6.0
SQL Server 6
codename SQL95 Support end date: 1999-03-31 |
6.00.121 | 6.00.124 | 6.00.139 | 6.00.151 | |
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.
https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/