Description
Why SQL Server 2016 Standard
SQL Server 2016 Standard Edition offers improved availability and scalability with up to 24 cores. Transform data and deliver actionable insights with advanced reports. Use open source R integration for advanced analytics. SQL Server technologies: The Database Engine is the core service for storing, processing and backing up data. The Database Engine provides controlled access and fast transaction processing. This allows you to meet the high demands of data processing applications in your organisation. The Database Module also provides a wide range of support for maintaining high availability.
R Services
Microsoft R Services offers several ways to integrate the popular R language into enterprise workflows. R Services (In-Database) integrates the R language with SQL Server so you can easily create, retrain and evaluate models by calling stored Transact-SQL procedures. Microsoft R Server provides scalable support for R in the enterprise on multiple platforms and supports data sources such as Hadoop and Teradata.
Data Quality Services
SQL Server Data Quality Services (DQS) provides a knowledge-driven data cleansing solution. DQS allows you to create a knowledge base and then use that knowledge base to perform data correction and deduplication on your data using computer-assisted and interactive means. You can use cloud-based reference data services and create a data management solution that integrates DQS with SQL Server Integration Services and Master Data Services.
Integration Services
Integration Services is a design platform for high-performance data integration solutions, including data warehouse packages for extracting, transforming and loading (ETL) data.
Master Data Services
Master Data Services is the SQL Server solution for master data management. A solution built on Master Data Services ensures that reporting and analysis are based on the right information. With Master Data Services, you create a central repository for master data and manage a monitorable and secure record of that data as it changes over time.
Analysis Services
Analysis Services is a platform for analytical data and a business intelligence toolset for individuals. Teams and enterprises, server and client designers support traditional OLAP solutions, new table modelling solutions, and self-service analytics and collaboration capabilities with Power Pivot, Excel and a SharePoint Server environment. Analysis Services also includes data mining to help you identify the patterns and relationships hidden in large volumes of data.
Replication
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronising the databases to ensure data consistency. Replication allows you to distribute data to multiple locations, remote or mobile users over local and wide area networks, dial-up connections, wireless connections or the Internet.
Reporting Services
Reporting Services provides web-based enterprise reporting functionality so you can create reports, pull content from a variety of data sources, publish reports in multiple formats, and centrally manage subscriptions and security.
