In this post, We will have a look on the versions of SQL Servers released by Microsoft.
SQL Server Release History
| Version | Year | Release Name | Codename |
| 1 (OS/2) | 1989 | SQL Server 1.0 (16 bit) | N/A |
| 1.1 (OS/2) | 1991 | SQL Server 1.1 (16 bit) | N/A |
| 4.21 (WinNT) | 1993 | SQL Server 4.21 | SQLNT |
| 6 | 1995 | SQL Server 6.0 | SQL95 |
| 6.5 | 1996 | SQL Server 6.5 | Hydra |
| 7 | 1998 | SQL Server 7.0 | Sphinx |
| - | 1999 | SQL Server 7.0 OLAP Tools | Palato Mania |
| 8 | 2000 | SQL Server 2000 | Shiloh |
| 8 | 2003 | SQL Server 2000 64-bit Edition | Liberty |
| 9 | 2005 | SQL Server 2005 | Yukon |
| 10 | 2008 | SQL Server 2008 | Katmai |
| 10.25 | 2010 | SQL Azure DB | CloudDatabase |
| 10.5 | 2010 | SQL Server 2008 R2 | Kilimanjaro |
| 11 | 2012 | SQL Server 2012 | Denali |
| 12 | 2014 | SQL Server 2014 | SQL14 |
| 13 | 2015 | SQL Server 2016 CTP2 | ? |
SQL Server 2000, SQL Server 2008, SQL Server 2008 R2, 2012, 2014 are in use by most of the clients or companies but Microsoft stopped releasing Service Pack for SQL2000, SQL2005 Versions. As now Microsoft released SQL Server 2016 with highly featured.
Here are the details of latest SP's for each SQL Server Version:
| RTM (no SP) | SP1 | SP2 | SP3 | SP4 | |
|---|---|---|---|---|---|
| SQL Server 2016 | CTP3.3 | ||||
| SQL Server 2014 | 12.0.2000.8 | 12.0.4100.1 (CU4-12.00.4437) |
|||
| SQL Server 2012 | 11.0.2100.60 | 11.0.3000.0 | 11.0.5058.0 | 11.0.6020.0 (CU1-11.00.6518) |
|
| SQL Server 2008 R2 | 10.50.1600.1 | 10.50.2500.0 | 10.50.4000.0 | 10.50.6000.34 | |
| SQL Server 2008 | 10.0.1600.22 | 10.0.2531.0 | 10.0.4000.0 | 10.0.5500.0 | 10.0.6000.29 |
| SQL Server 2005 | 9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
| SQL Server 2000 | 8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| SQL Server 7.0 | 7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
Note: Last Updated on 7th Feb, 2016.
Keep updating whenever any new Service Pack announced
MSSQL Knowledge
Microsoft SQL Server
Microsoft SQL Server is a Relational Database Management System (RDBMS)
designed to run on platforms ranging from laptops to large multiprocessor
servers. SQL Server is commonly used as the back-end system for websites and
corporate CRMs and can support thousands of concurrent users.
SQL Server
comes with a number of tools to help you with your database administration and
programming tasks. Although SQL Server can also be run as a desktop database
system, it is most commonly used as a server database system.
Server Database Systems
Server
based database systems are designed to run on a central server, so that
multiple users can access the same data simultaneously. The users normally
access the database through an application.
For example, a website could
store all its content in a database. Whenever a visitor views an article, they
are retrieving data from the database. As you know, websites aren't normally
limited to just one user. So, at any given moment, a website could be serving
up hundreds or even thousands of articles to its website visitors. At the same
time, other users could be updating their personal profile in the members'
area, or subscribing to a newsletter or anything else that website users do. Generally,
it's the application that provides the functionality to these visitors. It is
the database that stores the data and makes it available.
Subscribe to:
Posts (Atom)