SQL Server Latest Versions, Editions & SQL Server History

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.

  1. SQL Server Enterprise Editon : It is a version that includes all components and features for the Enterprise companies ( Banks, Insurance, hospital, Universities )
  2. SQL Server Standart Editon : It is a product developed for medium and small businesses.
  3. SQL Server Workgroup Edition — Expired
  4. SQL Server Personal Editon — Expired
  5. SQL Server Developer Editon
  6. SQL Server Express  Edition
  7. SQL Server WEB Edition
  8. 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
codename Aris
Support end date: 2025-07-01
Ext. end date: 2030-08-01

15.0.2000.5CU4 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.169CU20 (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
SP1SP2SP3SP4
SQL Server 2016

SQL Server 13
Support end date: 2021-07-13
Ext. end date: 2026-07-14
13.0.1601.513.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.812.0.4100.112.0.5000.012.0.6024.0
SQL Server 2012

SQL Server 12
Support end date: 2019-07-09
Ext. end date: 2024-07-09
11.0.2100.6011.0.3000.011.0.5058.011.0.6020.011.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.110.50.2500.010.50.4000.010.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.2210.0.2531.010.0.4000.010.0.5500.010.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.069.0.20479.0.30429.0.40359.0.5000
SQL Server 2000

SQL Server 8
codename Shiloh
Support end date: 2008-04-08
Ext. end date: 2013-04-09
8.0.1948.0.3848.0.5328.0.7608.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.6237.0.6997.0.8427.0.9617.0.1063
SQL Server 6.5

SQL Server 6.50
codename Hydra
Support end date: 2002-01-01
6.50.2016.50.2136.50.2406.50.258SP4 6.50.281
SP5 6.50.416
SQL Server 6.0

SQL Server 6
codename SQL95
Support end date: 1999-03-31
6.00.1216.00.1246.00.1396.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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

4 comments

  1. It’s remarkable to pay a quick visit this site and reading the views of all friends on the topic of this article, while I am also eager of getting familiarity.|

  2. Hey There. I found your blog using msn. This is an extremely well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will certainly return.|

  3. Hi, I guess Microsoft didn’t purchase Sybase, there was only a partnership.

Leave a Reply

Your email address will not be published. Required fields are marked *