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.

25% discount on Power BI Premium for SQL Server customers with active Software Assurance  

​PowerBI Premium Promotion

 7/1/2017 - 12/31/2017

25% discount on PowerBI Premium, for Commercial and Government customers in EA & EAS. Eligible for this promotion are SQL Server customers with active SA (customers cannot purchase more cores of PowerBI Premium than they own of SQL Enterprise).

Save this offer

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


Many IT administrators struggle repeatedly with similar problems when dealing with SQL Server. It’s time to put an end to this predicament! Read the full article ...

COMPAREX – Gold Data Platform Partner of Microsoft

 Request Information