Get more processing power with up to 24 cores and take advantage of up to 128 GB of database engine memory per instance.
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.
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.
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.
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.
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).
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.
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.
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.
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.
