SQL Server 2016 SP1 Standard edition

Bring security innovations and fast performance to your applications and data marts. Built with the programming features of SQL Server, develop advanced applications that will scale across SQL Server editions as you grow—without having to change any code.

Why choose the Standard edition?

Increase performance with 24 cores

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

Bring intelligence to all apps

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.

Find faster data insights

Deliver faster insights from your data with in-memory columnstore. Combine in-memory technologies for real-time hybrid transactional and analytical processing over your operational data—now available to data mart workloads. Query across structured and unstructured data using PolyBase.

Deliver end-to-end security

Help secure all application data at rest and in motion with Always Encrypted, limit access with row-level security and dynamic data masking, and get fine-grained auditing to easily log and track changes—all on the least vulnerable database platform for seven years running (National Institute of Standards and Technology, National Vulnerability Database, October 24, 2016).

Simplify corporate reporting

Create departmental reporting solutions with trusted data models that are easily accessible through tools like Power BI. Visualize data with modern reports. Use open-source R integration for advanced analytics.

Stretch to the cloud

Easily extend your database to Azure with SQL Server Stretch Database—including backup and migration options.

View the capabilities of SQL Server 2016 SP1 Standard edition

Expand allCollapse all
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.
In-memory performance across workloads
Get started with in-memory OLTP and in-memory columnstore for your mid-tier workloads. Achieve real-time, hybrid transactional and analytical processing and improved query performance when you combine in-memory columnstore and rowstore capabilities.
Market-leading security and compliance
Help protect data with a database that has the least vulnerabilities of any major platform for seven years running in the NIST vulnerabilities database (National Institute of Standards and Technology, National Vulnerability Database, October 24, 2016). Get layers of protection with row-level security, dynamic data masking, fine-grained auditing, and new innovations in SQL Server 2016—including Always Encrypted that helps secure data at rest and in motion.
Basic high availability and disaster recovery
Ensure your data isn’t lost with basic high availability and a fast, two-node failover, non-readable synchronous replica. Plus, get hybrid disaster recovery by putting an asynchronous replica in an Azure Virtual Machines.
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 SP1 Enterprise edition, which offers scale out query processing (requires single SQL Server 2016 SP1 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 SP1 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 across editions from on-premises to cloud
Get a consistent experience from on-premises to the cloud with SQL Server 2016. Build and deploy hybrid solutions for managing your data investments using a common programming interface found across all SQL Server SP1 editions—giving you the flexibility to scale to the Enterprise edition without having to rewrite your application.
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.

Back To Top