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.