New features and functions of SQL Server version 2016
Windows SQL Server 2016 provides organizations with a basic data management and business intelligence database that allows all employees with the appropriate CAL to run all business applications. SQL Server 2016 also supports multiple development tools - both local and cloud - and administrators benefit from efficient database management that requires minimal IT resources.
Higher performance of SQL Server 2016
The 2016 version of Microsoft SQL Server scores points not only for its flexible application possibilities but also for its optimized performance, from which users with a CAL benefit. The integrated in-memory capabilities available across all workloads deliver performance gains at speeds comparable to in-memory OLTP. Features such as Temporal Tables for historizing data and In-Memory Column Store and Query Store also improve the performance of SQL Server 2016.
Microsoft SQL Server R Services
The new SQL Server R Services from Microsoft now make the statistics language R usable for the SQL Server 2016. While previously data had to be exported from the SQL database and imported into R for analysis, users with a client access license can now execute all R scripts directly on the SQL Server. This not only shortens the time, but also increases security, as the transfer of sensitive data is no longer necessary.
Master Data Services for the administration of master data
Master Data Services in SQL Server allows users to efficiently manage a master set of their organization's data. MDS can be used to organize this data into models, create rules for updating them, and also determine who can update this data. The master data set can be shared with others using Excel.
Reporting Services (SSRS) for reporters
With a client access license, SQL Server Reporting Services provides a set of tools and services for creating, managing, and delivering mobile and paginated reports that employees can read via a browser on the Web portal or via email on a mobile device.
Analysis Services is a tool for delivering analytical data - for business and reporting services reports, or for third-party client applications or business intelligence tools. The Reporting Services in SQL Server 2016, on the other hand, provide a user with various functions for generating reports from different data sources and publishing them in various formats.
Microsoft SQL Server 2016 also has some significant improvements in terms of security: With Row-Level Security (RLS), owners of a CAL can implement certain restrictions in data row access. This can be used, for example, to ensure that certain employees can only access exactly those data rows that are relevant for them. This includes, for example, restricting corporate customers' access to data that is relevant to them.
Always Encrypted protects sensitive data, such as credit card or ID card numbers, stored in an Azure SQL or SQL Server database. Always Encrypted distinguishes between those licensed users who are authorized to view data and those who should be able to manage this data but not have access to it.
Dynamic Data Masking simplifies security coding in applications: DDM works by preventing access to confidential data by masking it for unauthorized users.
An overview of all important new features of SQL Server 2016:
- Enhanced cloud support by integrating stretch databases to connect between on-premises environments and the cloud
- Support for conventional OLAP (Online Analytical Processing) solutions
- Integration of the R programming language for statistical analyses with Advanced Analytics
- Row-Level Security (RLS), Always Encrypted Feature and Dynamic Data Masking increase security
- T-SQL (Transact-SQL) maximizes SQL server performance
- End-to-end mobile business intelligence is available for all mobile devices, whether Windows, Android or iOS smartphones, to publish reports with Excel 2016 or BI power
- PolyBase for processing Transact-SQL-queries from external data sources and extension of Business Intelligence with SQL Server Reporting Services (SSRS)
Hardware requirements for the installation of Microsoft SQL Server 2016
To ensure the smooth installation and operation of Microsoft SQL Server version 2016, the following minimum requirements should be met:
- Hard disk: at least 32 GB, SQL Server 2016 requires at least 6 GB hard disk space
- Memory: 512 MB minimum, 2 GB minimum for the installation option with desktop
- Processor: 64-bit with 1.4 GHz (or dual-core processor with at least 1.3 GHz or quad-core processor)
- Graphics card: Super VGA with a minimum resolution of 800x600
- Optical drive for installation from DVD
Additional hardware requirements depend on the system configuration and the pre-installed applications.
Licensing model with Client Access Licenses (CALs) for Microsoft SQL Server 2016
With the SQL Server version 2016, Microsoft has also introduced new licensing conditions. For certain editions of SQL Server 2016, you can choose between per-core licensing and licensing withClient Access Licenses (CALs) - either for users or devices. This differentiation makes server licensing more flexible and more economical. This eliminates the need for paid add-ons, because a CAL integrates all server functions available for an edition.
Licensing with CALs is generally the more cost-effective option, especially for small and medium-sized companies or organizations whose server offers a lower performance level in line with their needs, without having to sacrifice the functions and performance of SQL Server 2016. This licensing model is therefore best when the number of clients connecting to the SQL Server system is known. Even with a Device or User CAL, the individual requirements of each company for an IT system can be met.
Licensing of SQL Server 2016 through CALs
Licensing with CALs separates user use of SQL Server 2016 services from server software implementation. The server license only allows administrators to access the database management system. Employees require their own client access license - either in the form of a User CAL or Device CAL. Without either license, the server features and data cannot be accessed.
User CAL or Device CAL for SQL Server 2016?
The differentiation between User CAL and Device CAL for Windows SQL Server allows for flexible licensing - one user and one device license. Microsoft thus covers the two typical uses of Windows SQL Server 2016. A device license considers different ways of accessing the Windows than a user license:
With a Device CAL for Microsoft SQL Server 2016, you purchase a license for a single specific end device, which can be a desktop computer, notebook or mobile phone or tablet. Any user who has permission to use this device can use it to access SQL Server 2016. This licensing concept is therefore ideal for workstations that are used by changing employees.
With a User CAL, however, the SQL Server is licensed for a very specific user. This user can thus access its data and services from anywhere and with any Windows device - whether desktop PC, notebook or mobile device. User CAL is therefore the ideal solution for employees who work at different workstations - e.g. in the field or at different company locations - or who regularly use the home office or work on the road.
For both forms of client access, the licensing cannot be transferred to another terminal device or another user. Likewise, a User CAL cannot be used as a Device CAL or vice versa.
On the other hand, it is possible to use both User CALs and Device CALs for SQL Server 2016 in a company, i.e. to freely combine both types. This is particularly useful if both types of use are equally common there.
Device and User CALs for SQL Server 2016 inexpensive at Wiresoft
If you have questions about your customized licensing of Windows SQL Server 2016 with client access licenses - we will advise you individually on the most advantageous license combination for you. With the server access licenses available at Wiresoft you can easily cover or even extend your individual needs.
Wiresoft offers Device CALs as well as User CALs for the Microsoft SQL Server Version 2016 at a very reasonable price. These are original Microsoft licenses from companies in Europe, which have been checked by us for authenticity and absolutely perfect usability. As a customer, you benefit from the price advantage of unused software licenses, which we have purchased completely legally from trustworthy companies. Many of our customers already use this advantage. Please feel free to contact us at any time if you have any questions regarding your licensing with CALs for Microsoft SQL-Server 2016: