Grab Deal : Flat 23% off on live classes + 2 free self-paced courses as a bonus! - 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: What Is The Difference Between The SQL Inner Join And Outer Joins?
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: The Types Of Database Query And How To Use Them
|Older SQL Server Version||Older SQL Version still Supported||Latest Version||Latest Preview Version|
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.
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.
Using Command Prompt with T-SQL Query
Start>Run>Type CMD and hit Ok
and click enter
Generate Web report using SQL Server Installation Center
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: SQL Server DBA Roles and Responsibilities: What Should You Know?
I love to learn new things and also like sharing my knowledge with others. As an experienced IT Professional I like to update myself constantly with new and upcoming technologies. The database management system is one of my favorite subjects which I constantly explore.
MS SQL Server
Receive Latest Materials and Offers on SQL Server Course