Introduction
Microsoft SQL Server is a Relational Database management system (RDBMS) developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary Query Languages are T-SQL and ANSI SQL.
SQL Server 2008 R2 (10.50.1600.1) formerly codenamed "Kilimanjaro" was released on April 21, 2010.
The first SQL Server 2008 R2 service pack (10.50.2500) Service Pack 1 was released on July 11, 2011.
The second SQL Server 2008 R2 service pack (10.50.4000) Service Pack 2 was released on July 26, 2012.
Types of RDBMS Products in the Market
Source
|
Common Name
|
Full Name
|
IBM DB2
|
SQL PL
|
SQL Procedural Language(Implements SQL/PSM)
|
IBM Informix
|
SPL
|
Stored Procedural Language
|
Microsoft
|
T-SQL
|
Transact-SQL
|
Mimer SQL
|
SQL/PSM
|
SQL/Persistent Stored Module (Implements SQL/PSM)
|
MySQL
|
SQL/PSM
|
SQL/Persistent Stored Module (Implements SQL/PSM)
|
Oracle
|
PL/SQL
|
Procedural Language/SQL(Based on Ada)
|
Postgre SQL
|
PL/pgSQL
|
Procedural Language/Postgre SQL(Based on Oracle PL/SQL)
|
Sybase
|
Watcom-SQL
|
SQL Anywhere Watcom-SQL Dialect
|
Teradata
|
SPL
|
Stored Procedural Language
|
- Enterprise
- Standard
- Workgroup
- Web
- Developer
- Express
SQL Server History and Features
Version
|
Year
|
Release Name
|
Code Name
|
1.0
|
1989
|
SQL Server 1.0
| |
1.1
|
1991
|
SQL Server 1.1
| |
4.2.1
|
1993
|
SQL Server 4.2.1
|
SQLNT
|
6.0
|
1995
|
SQL Server 6.0
|
SQL 95
|
6.5
|
1996
|
SQL Server 6.5
|
Hydra
|
7.0
|
1998
|
SQL Server 7.0
|
Sphinx
|
7.0
|
1999
|
SQL Server 7.0 with OLAP
|
Palatomania
|
8.0
|
2000
|
SQL Server 2000
|
Shiloh
|
8.0
|
2003
|
SQL Server 2000 64-bit
|
Liberty
|
9.0
|
2005
|
SQL Server 2005
|
Yukon
|
10.0
|
2008
|
SQL Server 2008
|
Katmai
|
10.5
|
2010
|
SQL Server 2008 R2
|
Kilimanjaro
|
11.0
|
2012
|
SQL Server 2012
|
Denali
|
No comments:
Post a Comment