Dec 13, 2019 
15.7k
23
NovBlack Friday Deal : Up to 40% OFF! + 2 free self-paced courses + Free Ebook - SCHEDULE CALL
- SQL Server Blogs -
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: MSBI Tutorial Guide for Beginners in 2024
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: Top 50 DB2 Interview Questions and Answers for Freshers & Experienced
| 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: Different Types of SQL Keys: Example and Uses
FaceBook
Twitter
LinkedIn
Pinterest
Email
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
Most Popular SQL Server Performance Tuning Tips
781.9k
What is the SQL Insert Query? How to Insert (Date, Multiple Rows, and Values in Table)
866.3k
How to use SQL Count() Aggregate Function
24.8k
What Is The Difference Between Having And Where Clause In SQL?
559.4k
How to Create Stored Procedure & Trigger in SQL Server
984.3k
Receive Latest Materials and Offers on SQL Server Course
Interviews
Oct 25, 2017
781.9k
