DBA - What are SQL Server Versions and Editions available?

There are currently four editions being used in industry for various environments -

1. SQL Server Enterprise Edition
2. SQL Server Standard Edition
3. SQL Server Developer Edition
4. SQL Server Express Edition

Below are SQL Server versions available along their code names.

Fig 1: SQL Server Version available in Market as of September, 2014.

How to find out what version as well as edition of SQL Server currently running?

There are several ways to find out version of SQL server, below are couple easy way to find currently running version.

Option: 1

• Open management studio, connect to particular server that you would like to find the information about
• Open new query and type " Select @@version"
• Run the query or press F5.

Fig 2: How to find SQL Server Version and Edition by using built in SQL Server Function

Option: 2

• Open management studio, connect to particular server that you would like to find the information about
• Right click on the server and go to properties

Fig 1: Find SQL server Version and Edition by using GUI

Fig 4: Get SQL Server Edition and Version Information by using Instance Properties