SQL Server 2016 Enterprise edition

Gain real-time insights across your transactional and analytical data with a scalable database platform that has everything built in—from unparalleled in-memory performance, new security innovations and high availability, to business intelligence and advanced analytics that make mission-critical applications intelligent.

Things you can do

Mission critical intelligent applications

Mission critical intelligent applications

Deliver real-time operational intelligence by combining built-in advanced analytics and in-memory technology without having to move the data or impact end user performance.

Least vulnerable database

Least vulnerable database

Protect data at rest and in motion 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).

Enterprise-scale data warehousing

Enterprise-scale data warehousing

Scale to petabytes of data and integrate with non-relational data sources like Hadoop using scale out, massively parallel processing from Microsoft Analytics Platform System.

Comprehensive business intelligence platform

Comprehensive business intelligence platform

Transform data into actionable insights and drive innovation and business results with the comprehensive business intelligence platform built into SQL Server 2016.

Simplify big data

Simplify big data

Take advantage of non-relational data with PolyBase technology built in that allows you to query structured and unstructured data with the simplicity of T-SQL.

Cut storage costs with SQL Server Stretch Database

Cut storage costs with SQL Server Stretch Database

Easily access historical data by securely stretching warm and cold online transaction processing (OLTP) data to Microsoft Azure on demand without application changes.

View the capabilities of SQL Server 2016 Enterprise edition

Expand allCollapse all
Real-time operational analytics

Combine in-memory Columnstore and rowstore capabilities in SQL Server 2016 for fast analytical processing right on your transactional data. Open up new scenarios like real-time fraud detection, scale your business with up to 30x faster transactions, and improve query performance from minutes to seconds.

High availability and disaster recovery

Gain mission-critical uptime, faster failover, easy setup, and load balancing of readable secondaries with enhanced Always On in SQL Server 2016—a unified solution for high availability and disaster recovery. Plus, put an asynchronous replica in an Azure Virtual Machine for hybrid high availability.

Security and compliance

Protect data at rest and in motion 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 for mission-critical workloads with multilayered approach, adding Always Encrypted technology along with row level security, dynamic data masking, and robust auditing.

#1 in price and performance—with massive scale

SQL Server consistently leads in TPC-E, TPC-H, and real-world application performance benchmarks. Plus, scale up to 640 logical processors when paired with Windows Server 2016—delivering the ability to have up to 12 TB of addressable memory.

Highest performing data warehouses

Scale to petabytes of data for enterprise-grade relational data warehousing—and integrate with non-relational sources like Hadoop—using scale out, massively parallel processing from Microsoft Analytics Platform System. Support small data marts to large enterprise data warehouses while reducing storage needs with enhanced data compression.

Transform complex data into actionable insights

Build comprehensive, analytic solutions with SQL Server Analysis Services, whether multidimensional models or tabular models in-memory for lightning fast performance. Fast access to data without storing it in Analysis Services using DirectQuery.

Mobile BI

Empower business users across the organization with the right insights on any mobile device.

Manage reports from a single portal

Use SQL Server Reporting Services to manage and provide secured access to your mobile and paginated reports and Key Performance Indicators (KPIs) all in one place.

Simplify big data

Get access to data, both big and small, with PolyBase technology that queries Hadoop data using simple Transact-SQL commands. In addition, new JSON support lets you parse and store JSON documents and output relational data into JSON files.

In-database advanced analytics

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. By using multi-threading and massively parallel processing, you’ll gain insights faster than using open source R alone.

Cut storage costs with SQL Server Stretch Database

Manage fast-growing 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 Microsoft 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.

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 Microsoft 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.