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.Download the SQL Server 2016 editions datasheetRead the SQL Server 2016 licensing datasheet
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.
Get more processing power with up to 24 cores and take advantage of up to 128 GB of database engine memory per instance.
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.
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 Enterprise edition, which offers scale out query processing. Requires single SQL Server 2016 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 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.
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.
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.