MICROSOFT SQL SERVER 2016 STANDARD

SQL Server 2016 Standard  provides enterprises with a reliable scalable hybrid database platform to build intelligent mission-critical applications, as this edition includes all the necessary features and memory performance, including enhanced security with new features and in-database query capabilities and analytics, plus Hadoop and Cloud integration, R analytics, etc.

For further questions about the product, please contact our customer service.

Microsoft SQL Server 2016 Standard

SQL Server 2016 Standard provides enterprises with a reliable, scalable, hybrid database platform to build intelligent, mission-critical applications, as this edition includes all the necessary features as well as the corresponding memory performance, including advanced security with new features as well as in-database query capabilities and analytics, plus Hadoop and Cloud integration, R-analysis, and more.

In-memory performance, advanced analytics functions as well as real-time analysis of operational data Plus the extended reporting area are also among the features particularly worth mentioning.

Also worth mentioning are support for JavaScript Object Notation (JSON) as well as PolyBase for Transact-SQL queries and new Hybrid Cloud scenarios, which provide companies with even more sophisticated data analyses for more detailed results that can be displayed on many end devices thanks to comprehensive visualization options.

The edition SQL Server 2016 Standard is available at Wiresoft as used software - the price is thereby more favorable than that of comparable new commodity - as far as this version of SQL Server is still regularly offered at all. This SQL Server license can be used to its full extent even when used and thus offers the maximum scalability, performance and security typical of the edition; this makes it particularly attractive for companies or organizations of smaller size that use a correspondingly smaller Server, so that the combination of server license and CALs represents the most economical solution for them. The licensing of this used Microsoft SQL Server 2016 Standard Edition is done according to the official Microsoft license management terms. Detailed information about the new optimizations and features included in SQL Server 2016 Standard and how to license them correctly can be found in the following sections.

New benefits and features of Microsoft SQL Server 2016 Standard

The Microsoft SQL Server 2016 Standard edition supports the transformation of business-critical applications into intelligent applications as well as increased scalability for up to 24 cores, plus open-source R integration also enables advanced analytics. Employees or endpoints that have the appropriate client access license can benefit from the comprehensive Business intelligence and development tools, which are also available for Cloud-based use. Below is a brief outline of the key new features and functionality in the 2016 SQL Server release:

In-Memory OLTP

The integrated in-memory capabilities are responsible for a significant performance increase for all workloads - which is comparable to the speed of in-memory OLTP. In addition, there are other features such as:

• In-Memory Columnstore and Query Store
• Extension of the ColumnStore index
• Temporal Tables for historization and provisioning of table data
• Support of tables with a size of up to 2 TB

SQL Server 2016 Analysis Services (SSAS)

SQL Server 2016 Analysis Services offers improved performance and functionality for, among other things, creation, filtering, processing for table model databases - including integration with the R statistical language: R scripts can thus be executed directly on the SQL Server and no longer need to be exported from the SQL database and then imported into R for an analysis, which not only saves time but also provides greater security - as well as:

• Database Consistency Checker - to check database consistency to immediately detect potential data corruption issues.
• Direct live querying of external data supports additional data sources including Azure SQL, Oracle and Teradata.
• New DAX functions as well as namespace Services
• The revised Analysis Services Management Objects (AMO) include Microsoft.AnalysisServices.Core.dll a second assembly.

SQL Server 2016 Integration Services (SSIS)

Important features here are support for Always On availability groups as well as Always Encrypted and Hadoop File System (HDFS) - as well as:

• Incremental package provisioning
• Available column names for errors in the data flow
• New connectors as well as
• Extensive custom logging capabilities

Master Data Services (MDS)

Master Data Services is used to efficiently manage the master data sets in an organization. Among the options available are the following:

• Data can be organized in the form of models and rules for updating can be defined - including the authorization of specific individuals to execute them.
• Master data sets can also be released for individual persons in Excel.
• Filtering by domain-based attributes, as well as synchronization of entities for sharing across models
• Approval workflows via change sets as well as new levels for improved security
• Custom indexes for improved query performance

Reporting Services (SSRS)

SQL Server Reporting Services helps users create, manage and deliver mobile or paginated reports.

• Analysis Services provides analytical data from reporting and Business Services reports that can also be used for Client applications or Business intelligence tools from other vendors.
• Reports can be generated from different data sources as well as published in various formats and made available to employees via a browser in the web portal, via e-mail or on a mobile device.
• Other features include the new web-based reporting portal with KPI feature as well as the new Publisher specifically designed for mobile report creation
• New engine with HTML5 support for rendering reports
• New chart types such as Treemap and Sunburst

Improved security

In terms of security features, the 2016 version of Microsoft SQL Server has the following enhancements, among others:

• Always Encrypted protects sensitive data such as credit card numbers and stores it encrypted in the or SQL Server database. Different roles define access rights, whereby e.g. admins can only manage data but do not have direct access to it.
• Row-Level Security enables the implementation of access restrictions for individual data rows, so that a single employee is only authorized to access certain data rows.
• Dynamic Data Masking simplifies application security coding and prevents unauthorized users from accessing sensitive data.

Information on the maximum available performance of the individual components of SQL Server 2016 Standard Edition

The following overview contains various details about scalability, performance, and features available for each component.

Maximum Scalability/Sizes Pro Instance of SQL Server Database Engine

• General computing capacity: up to 4 sockets or 24 cores
• Computing capacity for Analysis Services or Reporting Services: up to 4 sockets or 24 cores
• Memory of the buffer pool: 128 GB
• Working memory of the columnstore segment cache: 32 GB2
• Memory optimized data size: 32 GB
• Working memory for Analysis Services: Tabular 16 GB / MOLAP 64 GB
• Working memory for Reporting Services: 64 GB
• Relational database size: 524 PB

High availability for SQL Server database engine functions:

• Server-Core-Support
• Log shipping
• Database mirroring - only with full security
• Backup compression
• Always On failover cluster supports 2 nodes
• Basic availability groups support 2 nodes
• Database recovery advisor and snapshot
• Encrypted backup as well as hybrid backup in Azure

SQL Server database engine scalability features

• Columnstore
• In-memory OLTP
• Stretch Database
• Data compression
• Persistent main memory
• Multiple instance support
• Table and index partitioning
• Parallel processing of partitioned tables
• FILESTREAM container
• Buffer pool extension      

Available security features

• Always Encrypted
• Row level security
• Encryption of backups
• Dynamic data masking
• Server- and database monitoring
• User-defined roles
• Standalone databases

Replication

• SQL Server change tracking
• Snapshot, transaction and merge replication
• Refreshable subscription for transactional replication
• Heterogeneous subscribers

Management SQL Server database engine tools, including:

• SQL Management Objects
• SQL ConfigurationManager
• SQL Command Prompt Tool
• Distributed Replay for Administrator tool, Client as well as Controller (1 client)
• SQL Profiler and SQL Server-Agent
• Database Engine Tuning Advisor

Data warehousing features

• Creation of cubes without database
• Automatic generation of staging and data warehouse schemas
• Capture of modified data
• StreamInsight

SQL Server database engine development tools

• Integration with Microsoft Visual Studio
• IntelliSense with Transact-SQL and MDX as well as MDX editing, MDX debugging and MDX design tools
• SQL Server Data Tools

Hardware and Software Requirements for SQL 2016 Standard

The following are minimum requirements for installing MS SQL Server 2016 Edition Standard. In general, all SQL Server 2016 Standard features are supported on a 64-bit Client operating system, while only certain features are supported on a 32-bit Client operating system. x86 processors are no longer supported. Furthermore, it is recommended to install the SQL Server software on a computer with NTFS or ReFS file format.

Hardware

• Hard disk space: at least 6 GB - depending on the installed SQL Server components
• Memory: min. 4 GB, with increasing database size this should be increased to ensure optimal performance of SQL Server 2016
• Processor type: x64 processor - AMD Opteron or Athlon 64, Intel Xeon or Pentium IV with EM64T support
• Processor speed: min. 1.4 GHz; recommended 2.0 GHz

Software

• At least .NET Framework 4.6 - the SQL Server setup .NET Framework is automatically installed, Master Data Services and Replication
• Supported operating systems: Windows Server 2016 Datacenter, Standard and Essentials; Windows Server 2012 R2 Datacenter; Standard, Essentials and R2 Foundation; Windows Server 2012 Datacenter, Standard, Essentials and Foundation
• The installation of SQL Server 2016 in Server Core mode is supported by these Windows Server editions: Windows Server 2016 Standard and Datacenter; Windows Server 2016 Standard and Datacenter; Windows Server 2012 R2 Standard and Datacenter; Windows Server 2012 Standard and Datacenter

Licensing of the edition SQL Server 2016 Standard per Server/CALs

For SQL Server 2019 Standard Edition, combined licensing of Server and complementary client access licenses (CALs) is available for either User or endpoints, so these must be purchased separately. The Microsoft licensing metric makes the following statements about this:

• A separate server license is required for each Server (whether physical or virtual) running a SQL Server 2016 Standard edition.
• This also applies to SQL Server instances running in containers and equated to virtual machines.
• For each user or end device that is to access a licensed SQL Server, a separate client access license (CAL) is also required, the version of which is at least identical or, if applicable, also entitles access to a higher version; these CALs must be purchased separately, they are not software and are also available second-hand from Wiresoft as separate Microsoft products.

Licensing with the Server/CAL variant is particularly suitable for companies that require client access licenses for a relatively manageable number of users or end devices, so that the costs for SQL-Server licensing are lower than for the alternative Core-based licensing.  

If you have any questions about your optimal SQL Server 2016 Standard licensing, just contact us.

FAQs about used software with SQL Server 2016 Standard Edition

Good to know: With used software from Wiresoft, such as the license for SQL Server 2016 Standard, you can be sure that it does not differ in capabilities from a comparable new server license - not only because software generally does not wear out, but also in terms of its legal usability and functionality. Below you will find all the answers to typical questions about used software for SQL Server licenses.

Where does Wiresoft used software for SQL Server 2016 Standard come from?

The used software for SQL Server 2016 Standard offered at Wiresoft in the respective available editions comes from various organizations or companies that once purchased the software themselves new and resold it to Wiresoft for various reasons - for example, because it contains surplus licenses or was replaced by another software and was no longer used. These licenses are therefore marked as used software, they can be used in principle like a new license.

Does used software for SQL Server 2016 Standard license also offer buyer security?

Yes: Every Wiresoft used software - as for the SQL Server 2016 Standard license - offers you customers the same advantages with the purchase as a comparable new Server software: both with buyer security through immediate download after the purchase process is completed and with immediate license activation through the supplied valid license Key.

Is the purchase and also the use of SQL Server 2016 Standard legal with used software?

Yes: When buying Wiresoft Used Software you can be sure that you act legally as a customer - this is of course also true for their actual use and also for Wiresoft as a provider - because the offered Used Software comes from the license stock of a company. Therefore, the usual jurisdiction applies, which not only allows the trade with Microsoft Used Software, but also its actual use; various court rulings have already confirmed this several times.

Are there other advantages with Wiresoft used software?

Yes: With Wiresoft used software, customers can supplement or update their software inventories at a particularly favorable price, because its price is significantly lower than that of comparable new software. Wiresoft also offers many older versions of Server licenses that are no longer regularly available, so that customers are not forced to make more expensive upgrades. Used software from Wiresoft has also the advantage that it offers audit security by the complete proof of all buyers!

In the Wiresoft used software portfolio you will not only find the SQL Server software such as the 2016 Standard edition at a favorable advantage price, but also the alternative Core licensing as well as other versions of SQL Server. In the used software portfolio of Wiresoft you will also find many offers for other Microsoft programs - with all the above mentioned advantages. If you have any questions regarding your licensing of SQL Server 2016 Standard incl. CALs or any other licensing option, please feel free to contact us via chat, e-mail or phone.