Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168

Microsoft SQL Server 2016

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology helps protect your data at rest and in motion, and a world class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.

Microsoft SQL Server 2014 / 2012

MicroWay can assist you with licensing for older versions of Microsoft SQL Server.

Contact MicroWay for details and a formal quote.

What's New in Microsoft SQL Server 2016

Microsoft SQL Server 2016 is the biggest leap forward in Microsoft data platform history. Now providing 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 advanced analytics that make mission-critical applications intelligent.

Microsoft SQL Server 2016 DATASHEET PDF

Microsoft SQL Server 2016 - Everything Built-in PDF


Built to help you do more

Industry leading

Build mission-critical, intelligent apps for online transaction processing (OLTP) with breakthrough scalability, performance, and availability.

Advanced security

Protect data at rest and in motion. SQL Server is the least vulnerable database for six years running in the NIST vulnerabilities database.

End-to-end mobile BI

Transform data into actionable insights. Deliver insights on any device—online or offline—at one-fifth the cost of other self-service solutions.

In-database advanced analytics

Analyse data directly within the SQL Server database—without moving the data—using R, the popular statistics language.

Made for hybrid cloud

Get a consistent platform and tooling for easier workload mobility between your datacentre, private cloud, or Microsoft Azure.


Microsoft SQL Server 2016 LICENSING MODELS

Microsoft SQL Server 2016 can be licensed via either a "Per Core"  or  "Per Server + Client Access License (CAL)" model.
Depending on your requirements and user count – along with other specifics such as Virtualisation being part of your system – one of these models will either be the only option or the most cost effective.

More information on the SQL Server licensing models is available in this Microsoft SQL Server 2016 – Licensing Guide PDF

For more details or assistance, please contact MicroWay.


Editions Overview


Comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution with mobile BI built in, in-database advanced analytics at scale, and unlimited virtualisation with software assurance. Enterprise edition provides the highest scale and performance for Tier-1 workloads.


Find rich programming capabilities, security innovations, and fast performance for applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.


Deploy small databases in production environments with this free, entry-level database that's ideal for building small, data-driven applications up to 10 GB of disk size.


Build, test, and demonstrate applications in a non-production environment with this free, full-featured set of SQL Server 2016 SP1 Enterprise edition software.

SQL Server 2016 editions - What's New



Compare Microsoft SQL Server 2016 with previous versions to see what's new or changed. 
If you're migrating from SQL Server 2012 or older there are significant new features to navigate – including in-memory performance gains, with up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics.
The following table shows a summary of the current and previous versions – note that this is not intended to be a comprehensive comparison and features may change as Microsoft releases newer minor versions, builds and patches.


Compare Microsoft SQL Server versions
SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008
In-memory OLTP* check check      
In-memory columnstore* check check check    
Buffer pool extension to SSD check check      
Resource Governor check check check check check
AlwaysOn* check check check    
Enhanced virtualisation support and live migration check check check check  
Transparent data encryption* check check check check check
Backup encryption support check check      
Fine-grained auditing check check check check check
Separation of duties check check check    
Backup to Azure check check check    
Disaster recovery to Microsoft check check      
Optimised virtual machine images in Azure gallery check check check    
Management and programmability          
Distributed replay check check check    
Policy-based management check check check check check
Enhanced programmability check check check check check
BI and analytics          
PowerPivot for Excel check check check check  
Integration services managed as a server check check check    
Hadoop connector via Apache Sqoop check check check check check
Tabular BI semantic model* check check check check  
Master data services* check check check check  
Data quality services* check check check    

*SQL Server Enterprise and Business Intelligence editions only.


email Microsoft Volume Licensing

For further information on Microsoft SQL Server 2016 please call MicroWay on 1300 553 313 or email.



For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

© 1995-2020 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.