"Must Have" Tools for
DBA's and Developers
What's New in Microsoft SQL Server 2017
SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. This topic summarizes what is new for specific feature areas and includes links to additional details.
Microsoft SQL Server 2017 DATASHEET 
Built to help you do more
Your choice of language and platforms
Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers.
Industry-leading performance
Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications and data warehouses.
Least vulnerable database
Protect data at rest and in motion with the least vulnerable database over the last seven years in the NIST vulnerabilities database*.
Real-time intelligence
Gain transformative insights for your business with real-time analytics at up to 1M predictions/second. End-to-end mobile BI Turn raw data into meaningful reports that can be delivered to any device—at one-fifth the cost of other self-service solutions.
Microsoft SQL Server 2017 LICENSING MODELS
SQL Server licensing makes choosing the right edition simple and economical. Unlike other major vendors, there's no having to pay for expensive add-ons to run your most demanding applications—because every feature and capability is already built in.
Simple pricing metrics - Pay by processing power for mission-critical applications as well as business intelligence. Add self-service BI on a per user basis.
Flexibility and innovation - Cloud-optimised licensing with the ability to license virtual machines, and the flexibility to move from server to server, to hosters, or to the cloud, on the operating system of your choice.
Industry-leading TCO - Get outstanding value at any scale compared to all major vendors. The Enterprise edition offers all product features and capabilities with no costly add-ons required to run your most demanding applications.
More information on the SQL Server licensing models is available in this:
SQL Server 2017 Licensing Datasheet
And For more details or assistance, please contact MicroWay.
Editions Overview |
 |
Enterprise
Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads. |
|
 |
Standard
Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code. |
|
 |
Express
Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free. |
|
 |
Developer
Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2017. |
|
SQL Server 2017 Editions Datasheet
Microsoft SQL Server 2017 – COMPARE VERSIONS
|
SQL Server 2017 |
SQL Server 2016 |
SQL Server 2014 |
SQL Server 2012 |
SQL Server 2008 R2 |
| Performance |
|
|
|
|
|
| In-Memory OLTP |
 |
|
|
|
|
| In-Memory ColumnStore |
|
|
|
|
|
| Real Time Operational Analytics |
|
|
|
|
|
| Buffer Pool extension to SSD |
|
|
|
|
|
| Adaptive Query Processing* |
|
|
|
|
|
| Availability |
|
|
|
|
|
| AlwaysOn* |
|
|
|
|
|
| Basic Availability Groups |
|
|
|
|
|
| Security |
|
|
|
|
|
| Transparent data encryption* |
|
|
|
|
|
| Backup encryption support |
|
|
|
|
|
| Encryption at rest and in motion |
|
|
|
|
|
| Dynamic Data Masking and Row Level Security |
|
|
|
|
|
| Separation of duties |
|
|
|
|
|
| Cloud-readiness |
|
|
|
|
|
| Backup to Azure |
|
|
|
|
|
| Disaster recovery to Microsoft Azure |
|
|
|
|
|
| Optimised virtual machine images in Azure gallery |
|
|
|
|
|
| Stretch Database |
|
|
|
|
|
| Management and programmability |
|
|
|
|
|
| Runs on Linux and Docker Containers |
|
|
|
|
|
| Distributed replay |
|
|
|
|
|
| Policy-based management |
|
|
|
|
|
| Enhanced programmability |
|
|
|
|
|
| BI and analytics |
|
|
|
|
|
| Integration services managed as a server |
|
|
|
|
|
| PolyBase for T-SQL query across Hadoop |
|
|
|
|
|
| Tabular BI semantic model* |
|
|
|
|
|
| Master data services* |
|
|
|
|
|
| Data quality services* |
|
|
|
|
|
| In-database advanced analytics* |
|
|
|
|
|
| End-to-end Mobile BI on any device* |
|
|
|
|
|
*SQL Server Enterprise edition only.
For further information on Microsoft SQL Server 2017 please call MicroWay on 1300 553 313 or
email.
| For more information please contact
the MicroWay sales team: |
 |
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
|
|
SQL Server 2017 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.
