Understadning the Components of SQL Server 2014
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKKZXmMVpP-0UGpX5HQMRACAy2T1D_4sBmfjtGczALRpCKnSZz7p4zeXWpD-dB-gfQ_aGJ4O97M98w4OzQuo8IJBtl_CkeHlk8u7lt4Y553CmjcYb01wWslxzq6YAw31Cn5WMxboT-WBY/s320/Untitled.png)
Database Engine: A relational database engine based on the SQL language
Analysis Services: An online analytical processing (OLAP) engine that enables
business analysts to query multidimensional and tabular data models, and to perform data mining.
Integration Services: A tool used to orchestrate the movement of data between SQL Server components and external systems (in both directions)
Reporting Services: Offers a reporting engine based on web services and provides a
web portal and end-user reporting tools
Master Data Services: Provides a platform for managing master or reference data
StreamInsight: A platform for building applications to process high-speed events
Data Mining: Provides tooling and an inference engine for deriving knowledge and insights from existing OLAP data or relational data
Full-Text Search: Enables the inclusion of sophisticated search options into applications.
PowerPivot: A component of Analysis Services that enables end-users, power users, and business analysts to share Excel workbooks that contain tabular data models in SharePoint Server.
Replication: Enables synchronization of data between servers to suit data distribution needs
Data Quality Enables data cleansing and matching to ensure optimal data
Services: quality
Power View: A component of Reporting Services that enables users to create interactive visualization of data models in SharePoint Server.
Understadning the Components of SQL Server 2014
Reviewed by Unknown
on
11:47 PM
Rating:
![Understadning the Components of SQL Server 2014](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKKZXmMVpP-0UGpX5HQMRACAy2T1D_4sBmfjtGczALRpCKnSZz7p4zeXWpD-dB-gfQ_aGJ4O97M98w4OzQuo8IJBtl_CkeHlk8u7lt4Y553CmjcYb01wWslxzq6YAw31Cn5WMxboT-WBY/s72-c/Untitled.png)
No comments: