SQL Server supports the basic and standard language of database technology i.e,"Structured Query Language". It is a database base product build by IBM, which is a case insensitive language and common for all database technologies. It has been built up for the basic function of storing  and recovering information as required by different applications. It can be executed on the same system or on the different system. The Microsoft SQL Server is a powerful and reliable open source data management system that delivers a rich and reliable data for storing the applications on the desktop and Web Sites.

SQL Server contains some of the basic versions such as:

SQL Server components are basically the architecture of client server. And these components are further classified into 2 types such as: The components of Server are initialized in incorporated server. And following are some of the administrative Case, such as:

• SSIS
• SQL program
• SSAS
• SQL Server full content hunt
• SQL Server
• SQL Server Agent
• SSRS

Stands for SQL Server Integration Services is a components of Microsoft SQL Server database software.

SQL program

Stands for Structured Query Language, specially designed for programming language designed for managing data held in RDBMS.

SSAS

Stands for SQL Server Analysis Services is the technology from the Microsoft Business Intelligence stack.

SQL Server full content hunt

Full text search in SQL Server and the applications.

SQL Server

Is a Microsoft product used to manage and store information.

SQL Server Agent

Is a Microsoft product used to manage and store information.

SSRS

Stands for SQL Server Reporting Services,is a server based report generating software system from Microsoft.

Work station components

The components of Workstation are initialized in SQL Server administrator machine and in each and every devices. These are only interfaces to communicate with the components of Server,such as:

• Profiler
• BIDS
• SQLEM
• SSMS
• SSCM.

Profiler

Is a graphical user interface to SQL.

BIDS

Stands for Business Intelligence Development Studio is a former IDE from Microsoft.

SQLEM

Which returns the error messages associated with a particular server.

SSMS

Stands for SQL Server Management Studio which is a software application in Microsoft SQL Server.

SSCM

Is a SQL Server Configuration Manager which manages the local SQL Server Services.

The advantages of SQL Server are:

• To examine the information through SQL Server Analysis Services.
• Establishing a databases.
• To bring out ETL operations through SQL Server Integration Services.
• To produce reports through SQL Server Reporting Services.
• To look after databases.

• Overview of SQL Server - Is a database product build by IBM, and is a case insensitive language.
• Components of SQL Server - Server components and work station components.