20/03/2017
What is SQL Server?
-> It is a software, developed by Microsoft, which is implemented from the specification of RDBMS.
-> It is also an ORDBMS.
-> It is platform dependent.
-> It is both GUI and command based software.
-> It supports SQL (SEQUEL) language which is an IBM product, non-procedural, common database and case insensitive language.
Usage of SQL Server:
-> To create databases.
-> To maintain databases.
-> To analyze the data through SQL Server Analysis Services (SSAS).
-> To generate reports through SQL Server Reporting Services (SSRS).
-> To carry out ETL operations through SQL Server Integration Services (SSIS).
SQL Server Components:
SQL Server works in client-server architecture, hence it supports two types of components: (a) Workstation and (b) Server.
-> Workstation components are installed in every device/SQL Server operator’s machine. These are just interfaces to interact with Server components. Example: SSMS, SSCM, Profiler, BIDS, SQLEM etc.
-> Server components are installed in centralized server. These are services. Example: SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL browser, SQL Server full text search etc.
