SQL Tutorial – Basic Information about SQL and versions

Hi Friends,

Microsoft SQL Server is a product of Microsoft, and developed by Microsoft as a database, it is a Relational Database Management System (RDBMS) whose primary function is to store and retrieve data as requested by other software applications for the same computer or those running on another computer across the network, Its primary query language is T-SQL.

There are different editions of Microsoft SQL Server (some of the main release are):

 

Version Realease Year Release Name
1 1989 SQL Server 1.0
     
1.1 1991 SQL Server 1.1
     
4.21 1993 SQL Server 4.21
     
6 1995 SQL Server 6.0
6.5 1996 SQL Server 6.5
7 1998 SQL Server 7.0
  1999 SQL Server 7.0 OLTP
8 2000 SQL Server 2000
8 2003 SQL Server 2000 64-bit Edition
     
9 2005 SQL Server 2005
10 2008 SQL Server 2008
10.25 2010 SQL Azure DB
10.5 2010 SQL Server 2008 R2
11 2012 SQL Server 2012
12 2014 SQL Server 2014

 

Also here is some of the SQL specification which we need to know before dive into SQL world

Name

Microsoft SQL Server

Description

Microsofts relational DBMS

Website

                                http://www.microsoft.com/en-in/sqlserver/default.aspx

Developer

Microsoft

Initial release

1989

License

commercial

Implementation language

C++

Server operating systems

Windows

Database model

Relational DBMS

Data scheme

yes

Typing

yes

Secondary indexes

yes

SQL

yes

Supported programming languages

Net ,Java ,PHP ,Python ,Ruby, Visual Basic

Server-side scripts

Transact-SQL and .NET languages

Triggers

yes

Partitioning methods

tables can be distributed across several files (horizontal partitioning), but no sharding

Replication methods

yes, but depending on the SQL-Server Edition

Foreign keys

yes

Transaction concepts

ACID

Concurrency

yes

Durability

yes


Hope you will like this post on Microsoft SQL Server.

If you really like reading my blog and understood at least few thing then

please don’t forget to subscribe my blog.

Connect With me on

| linkedIn | Google+ | WordPress |

Advertisements

5 thoughts on “SQL Tutorial – Basic Information about SQL and versions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s