MSsqlserver

Microsoft SQL Server is a relational database management system, which is a  software product with the primary function of storing and retrieving data as requested by other software applications.

MSsqlserver is implemented from the specification of RDBMS. It is platform dependent on both GUI and command based software. It supports SQL (SEQUEL) language which is an IBM product, non-procedural, common database and case insensitive language and is also an ORDBMS.

MSsqlserver Supports two types of components;

(a) Workstation: It is installed in every device/SQL Server operator’s machine. It is just interfaces to interact with server components, such as SSMS, SSCM, Profiler, BIDS etc…

(b) Server: It is installed in centralized server and are related to servies such as SQL Server, SQL Server Agent, SSIS, SSAS, SSRS etc…

mssqlserver is used to create databases, maintain databases, analyze the data through SQL Server Analysis Services (SSAS),generate reports through SQL Server Reporting Services (SSRS) and carry out ETL operations through SQL Server Integration Services (SSIS)