Understadning the Components of SQL Server 2014





SQL Server 2014 includes a powerful relational database engine, but as a complete data platform and more such:

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 Understadning the Components of SQL Server 2014 Reviewed by Unknown on 11:47 PM Rating: 5

No comments:

Powered by Blogger.