Microsoft SQL Server 2016 Standard + 10 User CAL Instant License
Build intelligent, mission-critical applications using a scalable,
hybrid database platform that has everything built in—from
in-memory performance and advanced security to in-database
Microsoft SQL Server 2016 Standard - built to help you do more
Build mission-critical, intelligent apps for online transaction
processing (OLTP) with breakthrough scalability, performance, and
Protect data at rest and in motion. SQL Server is the least
vulnerable database for six years running in the NIST
End-to-end mobile BI
|Maximum Number of Cores||24 Cores||Unlimited|
|MMemory: Maximum Buffer Pool Size per Instance||128 GB||Operating System Max|
|Memory: Maximum Columnstore Segment Cache per Instance||32 GB||Operating System Max|
|Memory: Maximum Memory-Optimized Data per Database||32 GB||Operating System Max|
|Maximum Database Size||524 PB||524 PB|
|Advanced High Availability||×||√|
|Unlimited Virtualization, a Software Assurance Benefit||×||√|
|Transparent Data Encryption||×||√|
|Advanced Data Integration: Fuzzy Grouping and Look Ups||×||√|
Transform data into actionable insights. Deliver insights on any
device—online or offline—at one-fifth the cost of other
In-database advanced analytics
Analyze data directly within the SQL Server database—without moving
the data—using R, the popular statistics language.
Made for hybrid cloud
Get a consistent platform and tooling for easier workload mobility
between your datacenter, private cloud, or Microsoft Azure.
When users want data, they want it as fast as you can give it to
them. Microsoft SQL Server 2016 includes several options for
enabling faster queries. Memory-optimized tables now support even
faster online transaction processing (OLTP) workloads, with better
throughput as a result of new parallelized operations.
In-Memory OLTP enhancementsIn-Memory OLTP helps speed up transactional workloads with high
concurrency and too many latches by moving data from disk-based
tables to memory-optimized tables and by natively compiling stored
procedures. In-memory OLTP can also help improve the performance of
data warehouse staging by using nondurable, memory-optimized tables
as staging tables.
In-memory analyticsSQL Server 2016 adds more options for performing real-time
analytics on rapidly changing inmemory data by adding support for
columnstore indexes on memory-optimized OLTP tables. Resource
contention between the two workloads is significantly reduced when
they run simultaneously. As changes occur in a table, the database
engine automatically manages changes to the index to ensure that it
remains current with the underlying table.
Analysis Services enhancements
Analysis Services provides two different modes to support fast
reporting and analytics: multidimensional and tabular. In SQL
Server 2016, both multidimensional mode and tabular mode benefit
from enhancements that improve performance. DirectQuery now
generates a simpler and better performing query in SQL Server 2016
than it did in earlier versions.
SQL Server 2016 introduces three new principal security
features—Always Encrypted, Row-Level Security, and dynamic data
masking. Because of innovative client-side encryption technology
"Always Encrypted", the SQL Server instance never sees the
unencrypted version of the data.
Row-Level SecurityRow-Level Security (RLS) allows you to configure tables such that
users see only the rows within the table to which you grant them
access. This feature limits which rows are returned to the user,
regardless of which application they are using, by automatically
applying a predicate to the query.
Dynamic data maskingWhen you have a database that contains sensitive data, you can use
dynamic data masking to obfuscate a portion of the data unless you
specifically authorize a user to view the unmasked data. Dynamic
data masking is available for use in SQL Database.
Broader data access
As the cost to store data continues to drop and the number of data
formats commonly used by applications continues to change, you need
the ability both to manage access to historical data relationally
and to seamlessly integrate relational data with semistructured and
unstructured data. SQL Server 2016 includes several new features
that support this evolving environment by providing access to a
broader variety of data.
Temporal dataSQL Server 2016 now supports temporal tables, which were introduced
as a new standard in ANSI SQL 2011. In addition, Transact-SQL has
been extended to support the creation of temporal tables and the
querying of these tables relative to a specific point in time.
JSONWith the addition of JSON support to SQL Server 2016, you can now
support both relational and nonrelational data structures in your
environment and choose the appropriate model for your data
requirements and workloads.
PolyBaseIn SQL Server 2016, you can now use PolyBase to query data in
Hadoop or Azure Blob Storage and combine the results with
relational data stored in SQL Server.
Higher availabilityIn a world that is always online, maintaining uptime and
streamlining maintenance operations for your mission-critical
applications are more important than ever. By running SQL Server
2016 on Windows Server 2016, you have more options for better
managing clusters and storage.
More analyticsBetter and faster analytics capabilities have been built into SQL
Server 2016. Enhancements to tabular models provide greater
flexibility for the design of models, and an array of new tools
helps you develop solutions more quickly and easily.
Better reportingFor report developers, Reporting Services in SQL Server 2016 has a
more modern development environment, two new data visualizations,
and improved parameter layout options.
Improved Azure SQL Database
By integrating new features into SQL Database ahead of SQL Server,
the development team can take advantage of a full testing and
telemetry cycle, at scale, that allows them to add features to both
products much faster.
Need a complete and optimized control of your data? Fear no longer,
SQL Server 2016 is here! With new utilities such as utilizing up to
24 processing coresor being able to use different data types such
as JSON and Spatial Data, you are more equipped for the evolving
data world around you. With all new tools such as stretch
databases, migrating or managing your database with the cloud just
became even easy and simplistic.?With the most advanced analytics
that SQL Server has ever had, you can now get the most insightful
reporting that has ever been available.?
Get the most of your data, while not compromising integrity - SQL
Server Standard 2016 is the most secure version of SQL released to
this date and can do a lot for your business data. No matter what
your focus for your data, SQL Server 2016 gives you the tools to
unlock deeper insights, enhance security and performance, and
stretch your databases across hybrid environments.