300 reviews
Microsoft SQL Server 2016 – built to help you do more
Industry leading
Build mission-critical, intelligent apps for online transaction processing (OLTP) with breakthrough scalability, performance, and availability.
Advanced security
Protect data at rest and in motion. SQL Server is the least vulnerable database for six years running in the NIST vulnerabilities database.
End-to-end mobile BI
Transform data into actionable insights. Deliver insights on any device online or offline at one-fifth the cost of other self-service solutions.
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.
Faster queries
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 enhancements
_____
In-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 analytics
_____
SQL 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.
Better security
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 Security
_____
Row-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 masking
_____
When 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 data
_____
SQL 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.
JSON
_____
With 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.
PolyBase
_____
In 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.
Other features
____________________
Higher availability
_____
In 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 analytics
_____
Better 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 reporting
_____
For 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.
Microsoft SQL Server 2016
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 cores or 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 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. This version sold by My Choice Software allows you to fully utilize the pieces of SQL Server 2016 with 10 cilents. If you have remote access set up on your server, you and your team can make changes remotely as well. If there are any questions about licensing please call us at 1-800-318-1439 and speak to one of our specialists today.