Microsoft SQL Server 2016

SQL Server 2016 is the biggest leap forward in Microsoft’s data platform history - with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, innovative advanced security technology, and new hybrid cloud scenarios thanks to Azure.

Highlights of SQL Server 2016

SQL Server 2016 delivers breakthrough mission-critical capabilities in scalability, performance, and availability for your most important OLTP and data warehousing workloads.

  • Scale up to 12 TB of memory and 640 logical processors (with Windows Server 2016)
  • Reach up to 30x faster transactions and 100x faster queries with enhanced in-memory performance
  • Run real-time Operational Analytics over transactional data

Our multi-layered approach to security has a proven track record of producing the least vulnerable database, even while being the most widely-used database on the planet.

  • Rely on a database with the least vulnerabilities of any major platform - six years in a row
  • Mask sensitive data with minimal application impact using Dynamic Data Masking
  • Grant access based on user characteristics with Row Level Security

SQL Server 2016 delivers a comprehensive, on-premises, enterprise-ready BI platform that helps you to transform complex data into actionable insights.

  • Create modern reports and visualize dense data with additional chart types
  • Access KPIs and mobile and paginated reports using the SQL Server Reporting Services web portal
  • Get faster SQL Server Analysis Services performance with parallel processing

Built-in advanced analytics provide scalability and performance for building and running your advanced analytics algorithms directly in the core SQL Server transactional database.

  • Transform complex data from multiple sources into trusted data models using the most popular statistical modelling language
  • Process analytics in-place, reducing latencies and operational costs
  • Write models once and deploy anywhere: in-database, to the cloud, or to Linux, Hadoop, and Teradata

SQL Server 2016 delivers a consistent experience both on-premises and cloud. You get an exceptional experience whether data is in your datacenter, in a private cloud, or on Azure.

  • Dynamically stretch warm and cold data to Azure with Stretch Database
  • Tackle your mission-critical workloads with larger Azure virtual machine sizes
  • Use the skills you already have with common development and management tools and common T-SQL everywhere


SQL Server 2016 is available in two editions: Standard and Enterprise.

Standard Enterprise
Maximum number of cores 24 unlimited
Mission-critical performance
  • Disk-based OLTP
  • 24 cores max and 128 GB max memory
  • 2-node single database failover (non-readable secondary)
  • Query Store
  • Temporal
  • Operating system max cores and memory
  • Enhanced in-memory OLTP performance
  • Operational analytics
  • Enhanced AlwaysOn with no domain join (WS2016)
  • Query Store
  • Temporal
  • Row-level security
  • Dynamic data masking
  • Basic auditing
  • Separation of duties
  • Policy-based management
  • Always Encrypted
  • Row-level security
  • Dynamic data masking
  • Enhanced separation of duties
  • Enhanced SQL Server auditing
  • Transparent data encryption
  • Policy-based management
Data Warehousing
  • PolyBase (compute node only)
  • Support for JSON
  • Enhanced in-memory ColumnStore
  • PolyBase in scale-out configuration (head and compute nodes)
  • License rights to (the APS) MPP appliance
  • Distributed query processing
Business Intelligence
  • Basic tabular (16GB memory per instance)
  • Web portal experience
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multi-dimensional models
  • End-to-end mobile BI on all major platforms
  • Enhanced direct query
  • In-memory analytics
  • Advanced data mining
  • Advanced tabular
  • Web portal experience (all reports in one place)
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multi-dimensional models
Advanced Analytics
  • Single-threaded for RRE
  • Connectivity to R Open
  • In database advanced analytics
  • R integration with massive parallel processing for performance and scale
  • Works with in-memory technology
  • Run in database or standalone
  • Connectivity to R Open
Hybrid Cloud
  • Stretch Database
  • Backup to Azure
  • Stretch Database
  • Enhanced backup to Azure
  • Enhanced HA and DR with Azure – ease of use, no domain join (WS2016)
  • SSIS integration with Azure Data Factory and Azure SQL data Warehouse

COMPAREX – Gold Data Platform Partner of Microsoft

 Request Information