What is DataBase ?

A database is an organized collection of data.

Database handlers create database in such a way that only one set of software program provide access of data to all the users.

The main purpose of database is to operate large amount of information by storing, retrieving and managing.

There are many dynamic websites on the world wide web now a days which are handled through databases. For example, a model to checks the availability of rooms in a hotel. It is an example of dynamic website that uses database.

There are many database available like MySQL, Sybase, Oracle, Mango DB, Informix, Postgre, SQL Server etc.

SQL or Structured Query Language is used to perform operation on the data stored in a database. SQL depends on relational algebra and tuple relational calculus.


MS SQL Server

MS SQL Server is a Relational Database Management System developed by Microsoft Inc.

History:

  • 1987 - Sybase releases SQL Server for UNIX.

  • 1988 - Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2.

  • 1989 - Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2.

  • 1990 - SQL Server 1.1 is released with support for Windows 3.0 clients.

  • Aston-Tate drops out of SQL Server development.

  • 2000 - Microsoft releases SQL Server 2000.

  • 2001 - Microsoft releases XML for SQL Server Web Release 1 (download).

  • 2002 - Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).

  • 2002 - Microsoft releases SQLXML 3.0.

  • 2005 - Microsoft releases SQL Server 2005 on November 7th, 2005.

Features:

  • High Performance.

  • High Availability.

  • Database mirroring.

  • Database snapshots.

  • CLR integration.

  • Service Broker.

  • DDL triggers.

  • Ranking functions.

  • Row version-based isolation levels.

  • XML integration.

  • TRY...CATCH.

  • Database Mail.