MicrosoftSQL Server 2016 – Standard Edition
Thisis the “per-core” License, supporting Servers with up to 8 Physical Cores.
Per-Core licenses comes with unlimited User CALs.
Language: US- English, license is good worldwide*.
Brand New, Factory Sealed Box. US English Language.
New from July, 12 2017: Now, SQL Server 2016 Standard comes with build in Service Pack 1.
Experience breakthrough performancewith SQL Server 2016 features
SQL Server 2016 is the biggestleap forward in Microsoft data platform history with features that increaseperformance, simplify management, and transform your data into actionableinsights—all on a database that has the least vulnerabilities of any majorplatform.
Some of the new capabilities of SQLServer 2016:
·Buildintelligent, mission-critical applications
·Break freefrom Oracle
·AlwaysEncrypted
·Real-timeoperational analytics
·In-databaseanalytics
·PolyBase
·And muchmuch more. Check on the Internet, it has hours of reading about SQL Server2016.
SQL Server 2016 Editions:
SQL Server 2016 is the biggestleap forward in the Microsoft data platform history with real-time operationalanalytics, rich visualizations on mobile devices, built-in advanced analytics,new advanced security technology, and new hybrid cloud scenarios.
Enterprise Edition
SQL Server Enterprise deliverscomprehensive datacenter capabilities for mission-critical database, businessintelligence, and advanced analytics workloads.
Mission Critical Performance
§ Operating system max cores and memory
§ Enhanced in-memory OLTP performance
§ Operational analytics
§ Enhanced AlwaysOn with no domain join (WS 2016)
§ Query Store
§ Temporal
Security
§ Always Encrypted
§ Row-level security
§ Dynamic data masking
§ Enhanced separation of duties
§ Enhanced SQL Server auditing
§ Transparent data encryption
§ Policy-based management
Data Warehousing
§ Enhanced in-memory ColumnStore
§ PolyBase in scale-out configuration (head and computenodes)
§ License rights to (the APS) MPP appliance
§ Distributed query processing
§ Support for JSON
Business Intelligence
·End-to-endmobile BI on all major platforms
·EnhancedDirectQuery
·In-memoryanalytics
·Advanceddata mining
·Advancedtabular
·Web portalexperience (all reports in one place)
·Modernizedreports
·Pin reportsto Power BI
·Enhancedmultidimensional models
Advanced Analytics
·In databaseadvanced analytics
·Rintegration with massive parallel processing for performance and scale
·Works within-memory technology
·Run indatabase or standalone
·Connectivityto R Open
Hybrid Cloud
·StretchDatabase
·Enhancedbackup to Azure
·Enhanced HAand DR with Azure – ease of use, no domain join (Windows Server 2016)
·SSISintegration with Azure Data Factory and Azure SQL Data Warehouse
Standard Edition
SQL Server Standard providescore data management and business intelligence capabilities for non-criticalworkloads with minimal IT resources.
Mission Critical Performance
·Disk-basedOLTP
·24 coresmax and 128 GB max memory
·2-nodesingle database failover (non-readable secondary)
·Query Store
·Temporal
Security
·Row-levelsecurity
·Dynamicdata masking
·Basicauditing
·Separationof duties
·Policy-basedmanagement
Data Warehousing
·PolyBase(compute node only)
·Support forJSON
Business Intelligence
·Basic tabular(16GB memory per instance)
·Web portalexperience
·Modernizedreports
·Pin reportsto Power BI
·Enhancedmultidimensional models
Advanced Analytics
·Single-threadedfor RRE
·Connectivityto R Open
Hybrid Cloud
·StretchDatabase
·Backup toAzure
Express Edition
SQL Server Express is a freeedition of SQL Server ideal for development and production for desktop, web andsmall server applications.
Mission Critical Performance
·1 GBmemory, max 10 GB memory
·Basic OLTP
·Query Store
·Temporal
Security
·Policy-basedmanagement
Data Warehousing
·Support forJSON
Business Intelligence
·Basicreporting and analytics
·Web portalexperience
·Modernizedreports
Advanced Analytics
·Notavaliable
Hybrid Cloud
·StretchDatabase
·Backup toAzure
Developer Edition
SQL Server Developer is now afree edition providing the full feature set of SQL Server Enterprise. Fordevelopment and test only, and not for production environments or use withproduction data.
Hardware and Software Requirements
The following requirementsapply to all SQL Server 2016 installations:
·.NETFramework:
oSQL Server2016 require .NET Framework 4.6 for the Database Engine, Master Data Services,or Replication. SQL Server 2016 setup automatically installs .NET Framework.You can also manually install .NET Framework from Microsoft .NET Framework 4.6(Web Installer) for Windows.
·Windows 8.1,and Windows Server 2012 R2:
oRequireKB2919355 before installing .NET Framework 4.6.
·Supportedoperating systems for SQL Server 2016 have built-in network software.
oNote:Shared memory and VIA are not supported on failover clusters.
§ Also note that the VIA protocol is deprecated. Thisfeature will be removed in a future version of Microsoft SQL Server. Avoidusing this feature in new development work, and plan to modify applicationsthat currently use this feature.
·Hard Disk
oSQL Server2016 requires a minimum of 6 GB of available hard-disk space.
§ Disk space requirements will vary with the SQL Server2016 components you install.
·Drive
oA DVDdrive, as appropriate, is required for installation from disc.
·Monitor
oSQL Server2016 requires Super-VGA (800x600) or higher resolution monitor.
·Internet
oInternetfunctionality requires Internet access (fees may apply).
The following memory andprocessor requirements apply to all editions of SQL Server 2016:
·ExpressEditions:
o512 MB
·All othereditions:
o1 GB
·Recommended:
·ExpressEditions:
o1 GB
·All othereditions:
oAt least 4GB and should be increased as database size increases to ensure optimalperformance.
·ProcessorSpeed
oMinimum:x64 Processor: 1.4 GHz
·Recommended:
o2.0 GHz orfaster
·ProcessorType:
ox64Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support,Intel Pentium IV with EM64T support
Please Notice the following:
·Installationof SQL Server 2016 is supported on x64 processors only. It is no longersupported on x86 processors.
·Picture 1is promotional only, picture 2 and 3 are the actual item.
·Thesoftware comes with retail Core License, making them good in a productionsetup.
·If you haveany question, please don’t hesitate to ask. We will do all we can to answer youwithin one business day.
·When youorder, we always ship the item within 2 business days. The delivery timedepends on the shipping method you chose, when you ordered.
* This Licenseis good Worldwide, except in North Koreaand Iran.
