Product information "Microsoft SQL Server 2016 Standard- 2 Core Edition"
SQL Server 2016 StandardEdition provides improved availability and scalability with up to 24 cores. With modern reports you transform data and deliver usable insights. Use open source R integration for advanced analysis This version of Microsoft SQL Server 2016 Standardis licensed by cores. The number of users and Devicesdoes not matter. CALs are not necessary. Any number of Devicesor users, internal or external, may access core-based SQL servers. Instead of individual servers and CALs, the computing power is used as license metric. The more computing power is used by the server, the more expensive it becomes. The measure of things is the number of processor cores in use, either the underlying physical server or the assigned vCores in virtual machines with VMware or Hyper-V.
SQL Server technologies:
The database module is the core service for storing, processing and backing up data. The database module provides controlled access and fast transaction processing. So you can also meet high requirements of data processing applications in your company.
The database module also provides a wide range of support for maintaining high availability.
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 for your data using computer-aided 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 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 is a platform for analytical data and a business intelligence toolset for individuals, teams and companies. Server and client designers support traditional OLAP solutions, new table modeling solutions, and self-service capabilities for analysis and collaboration 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 is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing the databases to ensure data consistency. With replication, you can distribute data to multiple locations, remote or mobile users over local and wide area networks (WANs), dial-up connections, wireless connections, or the Internet.
Reporting Services provides Web-based reporting functionality for enterprises, so you can create reports that draw content from a variety of data sources, publish reports in a variety of formats, and centrally manage subscriptions and security.
The following memory and processor requirements apply to all editions of SQL Server:
Note : Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.
* The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement. For information about installing DQS, see Install Data Quality Services
The following requirements apply to all installations:
SQL Server Setup installs the following software components required by the product:
- SQL Server Native Client
- SQL Server Setup support files