server type for SQL Server

SQL Server provides four types of servers:

: 1, Database engine 2, Analysis Services (analytics Service) 3, Reporting Services (Reporting Services) 4, Integration Services (Integration Services)

1, Database Engine

Database Engine: Is the core service of SQL Server He is a data service that stores and processes data in tabular relational formats or XML document formats. Responsible for complete data storage, processing, and security.

2,analysis Services (Analytics service)

Analysis Services primarily provides online analytics and processing and data mining capabilities through servers and clients. (with its child thick the user can create and manage data structures from other sources) (the processing of online things is done by the database engine)

3, Reporting Services (Reporting Service)

Reporting Services is used for server-based solutions: He can be used to generate various reports to facilitate work

4, Integration Services (integration service)

Integration Services is a data integration platform responsible for the completion of data extraction, transformation, loading, integration services including graphical tools and wizards for generating and debugging packages, performing data import, export, FTP operations, SQL Tasks such as statement execution and workflow functions such as e-mail messaging.

---------the next article about the date types that are not in 2005, and the operations on these types.

server type for SQL Server