This is the Retail Standard 24 Core License.This license is an authentic Microsoft license, and can be used in production environments. The license is unused, and comes on a CoA with holographic product label.The Retail Core License comes with unlimited User CALs and can be installed on one Physical or VM Server. The license can be moved to a new installation if needed later on.Language: US-English.
New from May, 2018: Now, SQL Server 2016 Standard comes with build in Service Pack 2.
Experience breakthrough performance with SQL Server 2016 featuresSQL Server 2016 is the biggest leap forward in Microsoft data platform history with features that increase performance, simplify management, and transform your data into actionable insights—all on a database that has the least vulnerabilities of any major platform.
Some of the new capabilities of SQL Server 2016:· Build intelligent, mission-critical applications· Break free from Oracle· Always Encrypted· Real-time operational analytics· In-database analytics· PolyBase· And much much more. Check on the Internet, it has hours of reading about SQL Server 2016.
News in Service Pack 2 (May 2018):SQL Server 2016 Service Pack 2 ("SP2") contains a roll-up of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on response from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics. It also showcases the SQL Server product team’s commitment to providing continued value into in-market releases.
SQL Server 2016 Service Pack 2 includes:Performance and scale improvements for SQL Server, such as improved database backup performance on large memory machines and added backup compression support, which helps performance of almost all databases.Supportability and diagnostics enhancements, such as improved troubleshooting and additional information about statistics used during query plan optimization.New improvements based on Connect response items filed by the SQL Server Community.Some improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2012 SP4.SQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.
Mission Critical Performance· Disk-based OLTP· 24 cores max and 128 GB max memory· 2-node single database failover (non-readable secondary)· Query Store· Temporal
Security· Row-level security· Dynamic data masking· Basic auditing· Separation of duties· Policy-based management
Data Warehousing· PolyBase (compute node only)· Support for JSON
Business Intelligence· Basic tabular (16GB memory per instance)· Web portal experience· Modernized reports· Pin reports to Power BI· Enhanced multidimensional models
Advanced Analytics· Single-threaded for RRE· Connectivity to R Open
Hybrid Cloud· Stretch Database· Backup to Azure