Create intelligent, mission-critical applications using a scalable, hybrid database platform that has everything from in-memory performance and advanced security to in-database analytics built in.
Microsoft SQL Server 2016 Standard - Built to help you do more
Industry-Leading
Build mission-critical, intelligent apps with industry-leading online transaction processing (OLTP) performance that features great scalability, performance, and availability.
Advanced security
Protect data at rest and in motion. SQL Server has been the least vulnerable database in the NIST Vulnerability Database for six years.
End-to-end mobile BI
Turns data into actionable insights. Deliver insights on any device? Online or offline? One-fifth of the cost of other self-service solutions.
In-database Advanced Analytics
Analyze data straight 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 easy workload mobility between your data center, private cloud, or Microsoft Azure.
Faster Queries
When customers want data, they want it as fast as you can provide it to them. Microsoft SQL Server 2016 includes several options to enable faster querying. Memory-optimized tables now support even faster online transaction processing (OLTP) workloads with improved throughput as a result of new parallel operations.
____________________
In-Memory OLTP Enhancements
_____
In-memory OLTP helps accelerate transactional workloads with high concurrency and high latencies by moving data from disk-based tables to memory-optimized tables and compiling stored procedures seamlessly. In-memory OLTP can also help improve data warehouse staging performance by using non-durable, memory-optimized tables as staging tables.
In-memory Analytics
_____
SQL Server 2016 adds more options for performing real-time analytics on rapidly changing in-memory data by adding support for column store indexes on memory-optimized OLTP tables. When both workloads are run concurrently, resource contention between them is significantly reduced. As changes occur to a table, the database engine automatically manages changes to the index to ensure that it stays current with the underlying table.
Analysis Services Enhancements
Analysis Services provides two different modes to support faster reporting and analytics: multidimensional and tabular. In SQL Server 2016, multidimensional mode and tabular mode both benefit from enhancements that improve performance. DirectQuery now generates a simpler and better-performing query in SQL Server 2016 than in earlier versions.
Improved Security
Three new major security features are introduced in SQL Server 2016. Always Encrypted, row-level security, and dynamic data masking. Because of the innovative client-side encryption technology "Always Encrypted", a SQL Server instance never sees an unencrypted version of the data.
____________________
Row-Level Security
_____
Row-level security (RLS) allows you to configure tables so that users see only the rows within the table to which you give them access. This feature limits which rows are returned to the user by automatically applying a predicate to the query, no matter what application they are using.
Dynamic Data Masking
_____
When you have a database that contains sensitive data, you can use dynamic data masking to obscure a portion of the data until you specifically authorize a user to view the unmasked data. Dynamic data masking is available for use in Microsoft SQL Database.
Wider Data Access
As the cost of storing data continues to decline and the number of data formats commonly used by applications continues to change, you need the ability to manage access to historical data relationally and seamlessly integrate relational data with semistructured and unstructured data. SQL Server 2016 includes several new features that support this emerging environment by providing access to a wider variety of data.
____________________
Temporal Data
_____
Now SQL Server 2016 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 query of these tables relative to a specific point in time.
JSON
_____
With the addition of JSON support in SQL Server 2016, you can now support both relational and non-relational data structures in your environment and choose the appropriate model for your data needs and workloads.
PolyBase
_____
In SQL Server 2016, you can now use PolyBase to query data in Hadoop or Azure Blob Storage and join the results with relational data stored in SQL Server.
Other Features
____________________
Higher Availability
_____
In an always-online world, maintaining uptime for your mission-critical applications and streamlining maintenance operations is more important than ever. By running SQL Server 2016 on Windows Server 2016, you have more options to better manage clusters and storage.
More Analytics
_____
Better and faster analytics capabilities are built into SQL Server 2016. Enhancements to the tabular model provide more flexibility for the design of models, and an array of new tools help you develop solutions more quickly and easily.
Better Reporting
_____
For report developers, SQL Server 2016 features a more modern development environment, two new data visualizations, and improved parameter layout options in Reporting Services.
Improved Azure SQL Database
_____
By integrating new features into SQL Database before SQL Server, development teams can leverage the full testing and telemetry cycle at scale, which allows them to add features to both products much faster.
Microsoft SQL Server 2016 Standard + 10 User CAL Instant License
Do you need complete and customized control over your data? Worry no more, SQL Server 2016 is here! With new utilities like using up to 24 processing cores or using different data types like JSON and spatial data, you are more equipped for the data world that is evolving around you. With all new tools like Stretch Database, migrating or managing your database with the cloud has become even easier and simpler. With SQL Server's most advanced analytics ever, you can now get the most insightful reporting that was never available before.
Get the most out of your data without compromising integrity - SQL Server Standard 2016 is the most secure version of SQL released to date and can do a lot for your business data. Whatever your focus for your data, SQL Server 2016 gives you the tools to unlock deeper insights, enhance security and performance, and scale your databases across hybrid environments. This edition, sold by SoftwareDiscountUSA, allows you to fully utilize pieces of SQL Server 2016 with up to 10 additional users. If you have remote access set up on your server, you and your team can even make changes remotely.