15
NovDiwali Deal : Flat 20% off + 2 free self-paced courses + Free Ebook + $200 Voucher - SCHEDULE CALL
People like us who have been into the software development industry for quite some time are familiar with the SQL Server database. We have seen it grow and evolve. Each time a new SQL Server Version is released, which is very frequent, we have been surprised with new and more user-friendly features which have made our coding life easier. Over the last 13-14 years, SQL Server has released many SQL versions and features that you can be proud of as a developer.
Read: SQL Server Recovery Models-Simple, Full and Bulk Log
This blog is a simple effort to run through the evolution process of our favorite database management system. Here, we will discuss all SQL Server versions, SQL Server Editions, and SQL Server Version Comparison moving ahead through the blog.
SQL Server is a relational database management system (RDBMS) developed by Microsoft. Let us see how it all started?
Read More - SQL Server Tutorial for Beginners
Later, Microsoft SQL versions for Windows NT and other operating systems were also launched.
Learn SQL Server in the Easiest Way
Multiple SQL server editions are available in the database market that you must know as a database developer.
SQL Version | Year | Release | Code name | Internal database version |
1.0 (OS/2) | 1989 | SQL Server 1.0 (16-bit) | Filipi | - |
1.1 (OS/2) | 1990 | SQL Server 1.1 (16-bit) | Pietro | - |
4.2A (OS/2) | 1992 | SQL Server 4.2A | - | - |
4.2B (OS/2) | 1993 | SQL Server 4.2B (16-bit) | - | - |
4.21a (WinNT) | 1993 | SQL Server 4.21a | SQLNT | - |
6.0 | 1995 | SQL Server 6.0 | SQL95 | 406 |
6.5 | 1996 | SQL Server 6.5 | Hydra | 408 |
7.0 | 1998 | SQL Server 7.0 | Sphinx | 515 |
- | 1999 | SQL Server 7.0 OLAP Tools | Plato | - |
8.0 | 2000 | SQL Server 2000 | Shiloh | 539 |
8.0 | 2003 | SQL Server 2000 64-bit Edition | Liberty | 539 |
9.0 | 2005 | SQL Server 2005 | Yukon | 611/612 |
10.0 | 2008 | SQL Server 2008 | Katmai | 655 |
10.25 | 2010 | Azure SQL database (initial release) | Cloud database or CloudDB | |
10.50 | 2010 | SQL Server 2008 R2 | Kilimanjaro (aka KJ) | 661 |
11.0 | 2012 | SQL Server 2012 | Denali | 706 |
12.0 | 2014 | Azure SQL database | ||
12.0 | 2014 | SQL Server 2014 | SQL14 | 782 |
13.0 | 2016 | SQL Server 2016 | SQL16 | 852 |
14.0 | 2017 | SQL Server 2017 | Helsinki | 869 |
15.0 | 2019 | SQL Server 2019 RC | Seattle | 895 |
Here is a quick SQL server version comparison that you must know before you enter the database industry.
Read: How To Become Expert In Sql Server Developer?
Older SQL Server Version | Older SQL Version still Supported | Latest Version | Latest Preview Version |
1.0 (OS/2) | 11.0 | 12.0 | 15.0 |
1.1 (OS/2) | 12.0 | 14.0 | |
4.2A (OS/2) | 13.0 | ||
4.2A (OS/2) | |||
4.2B (OS/2) | |||
4.21a (WinNT) | |||
6.0 | |||
6.5 | |||
7.0 | |||
- | |||
8.0 | |||
9.0 | |||
10.0 | |||
10.25 | |||
10.50 |
Here is again the SQL server version comparison based on features.
SQL Server 1.0 |
|
SQL Server 1.1 |
|
No Version 2 or 3 | |
SQL Server 4.2 | a)Supported Windows NT |
SQL Server 6.0 |
|
SQL Server 6.5 |
|
SQL Server 7.0 |
|
SQL Server 2000 |
|
SQL Server 2005 | a)Introduction of SSMS b) Introduction to BIDS c) Introduction to Installer d) Adventureworks test database |
SQL Server 2008 |
|
SQL Server 2012 |
|
SQL Server 2014 |
|
SQL Server 2016 |
|
SQL Server 2017 | a) Can be installed in Linux and Docker
b) Includes python Support c) Adaptive Query processing |
There are five mainstream editions of SQL Server that are frequently used by industries worldwide.
Express
Web
Standard
Enterprise
Developer
To learn all these popular SQL server editions, join our free demo online training classes now!
SQL Server Training & Certification
There are three methods how we can check which version of SQL Server is running in the system.
Method 1
Using Command Prompt with T-SQL Query
Start>Run>Type CMD and hit Ok
select @@version
go
and click enter
Method 2
Generate Web report using SQL Server Installation Center
Method 3
Using SQL Server Management Studio to check version
SQL Server Training & Certification
This was all about how one of the most popular Relational database management systems evolved over time. We have tried to give a comparative analysis on SQL server version comparison, how the software matured, loaded itself with more and more features and became one of the most popular database applications in the world.
This is not an elaborate write-up on the different SQL Server versions and SQL Server editions but gives the readers enough material to explore the history of SQL Server evolution in more detail if they want to.
Read: All You Need to Know About SQL: SQL Tutorial for Beginners & Experienced
A dynamic, highly professional, and a global online training course provider committed to propelling the next generation of technology learners with a whole new way of training experience.
Cyber Security
QA
Salesforce
Business Analyst
MS SQL Server
Data Science
DevOps
Hadoop
Python
Artificial Intelligence
Machine Learning
Tableau
Search Posts
Related Posts
Receive Latest Materials and Offers on SQL Server Course
Interviews