SQL Server 2016 Standard edition

Enabling effective database management with minimal IT resources. SQL Server 2016 Standard edition delivers greater scalability, security, and performance and lays the foundation for building intelligent applications and deeper insights on data.

Things you can do

Increase performance and scalability

Increase performance and scalability

Get enhanced performance, improved availability, and greater scalability with up to 24 cores.

Enhance security

Enhance security

Help secure data by limiting access with row level security, dynamic data masking, and basic auditing to easily log and track changes.

Gain deeper insights across your data

Gain deeper insights across your data

Create trusted data models that can be easily understood and accessed by business users through their preferred visualization and analytics tools, deliver insights with modern reports, and utilize open-source R integration for advanced analytics.

Simplify big data

Simplify big data

Take advantage of PolyBase technology to query structured and unstructured data with the simplicity of T-SQL. Gain scalability and performance for your big data workloads by upgrading to Enterprise edition, which offers scale out query processing. Requires single Microsoft SQL Server 2016 Enterprise edition as head node.

Build intelligent applications on a solid foundation

Build intelligent applications on a solid foundation

Use single threaded open source R for building advanced analytics into your applications. Gain scalability and performance by upgrading to Enterprise edition, which offers massively parallel processing scale, multi-threaded open-source R along with in-memory performance.

Cloud-enable your database

Cloud-enable your database

Stretch your database to the cloud with Stretch Database, in addition to easy backup and migration options.

Capabilities of SQL Server 2016 Standard edition

Expand allCollapse all
Basic high availability and disaster recovery
Ensure greater availability so your data is not lost with basic high availability and a fast, two node failover non-readable synchronous replica. Plus, put an asynchronous replica in an Azure Virtual Machine for hybrid disaster recovery.
Improved scalability
Get more processing power with up to 24 cores and take advantage of up to 128 GB of database engine memory per instance.
Enhanced security and compliance
Protect data with a database that has the least vulnerabilities of any major platform for six years running in the NIST vulnerabilities database (National Institute of Standards and Technology, National Vulnerability Database, May 4, 2015). Security innovations in SQL Server 2016 help secure data with multilayered approach, adding row level security and dynamic data masking to basic auditing.
Comprehensive business intelligence
Transform data into actionable insights with powerful business intelligence (BI) semantic models (tabular or multidimensional) in SQL Server Analysis Services. Create and publish precisely-formatted, paginated, modern reports and provide secured access in a modern web portal experience with SQL Server Reporting Services.
Access non-relational data
Get access to data, both big and small, with PolyBase technology that queries Hadoop data using simple T-SQL commands. In addition, new JSON support lets you parse and store JSON documents and output relational data into JSON files. Gain scalability and performance for your big data workloads by upgrading to SQL Server 2016 Enterprise edition, which offers scale out query processing. Requires single SQL Server 2016 Enterprise edition as head node.
Foundation for building intelligent applications
Build intelligent applications with SQL Server R Services. Move beyond reactive and into predictive and prescriptive analytics by performing advanced analytics directly within the database. Utilize single-threaded open source R for building advanced analytics into your applications. Gain scalability and insights into your data faster by upgrading to SQL Server 2016 Enterprise edition to use multi-threading and massively parallel processing along with open source R in-memory performance.
Cut storage costs with SQL Server Stretch Database
Manage online transaction processing (OLTP) databases cost-effectively, keep historical data online and available, and have hot data quickly accessible with optimal performance. SQL Server Stretch Database stretches large SQL Server tables from SQL Server 2016 to Azure—saving up to 40 percent over building out on-premises storage.
Consistent data platform from on-premises to cloud
As the world’s first born-in-the-cloud database, SQL Server 2016 delivers a consistent experience from on-premises to the cloud—letting you build and deploy hybrid solutions for managing your data investments. Benefit from the flexibility to run SQL Server workloads in Azure Virtual Machines, or use Azure SQL Database to scale and further simplify database management.
Build with easy-to-use tools
Use the skills you already have, along with familiar tools like Azure Active Directory and SQL Server Management Studio, to manage your database infrastructure across on-premises SQL Server and Azure. Apply industry-standard APIs across various platforms and download updated developer tools from Visual Studio to build next-generation web, enterprise, business intelligence, and mobile applications.