What you'll love about SQL Server 2017



See how companies use SQL Server and Azure to realize their potential


Go behind the data


SQL Server news

Introducing SQL Server 2019

Transform your business with a unified data platform. SQL Server 2019 comes with integrated Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.

Gartner Magic Quadrant for Operational Database Management Systems

Read Gartner's assessment of the ODBMS landscape and learn more about Microsoft's "cloud first" strategy.

Azure SQL Data Warehouse

Analytics in Azure is up to 14 times faster and costs 94 percent less than other cloud providers. Why go anywhere else?

Get started with SQL Server 2019

[1] According to the National Institute of Standards and Technology, SQL Server has had the fewest security vulnerabilities over the past seven years when compared with other major database vendors.


SQL Server 2017: more than just a database

Get to know the features and benefits now available in SQL Server 2017.

Compare Microsoft SQL Server versions

Feature availability
  • Not supported
  • Fully supported
Table with images and check

Features

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 [2]

Availability

Always On [2]

Basic Availability Groups

Security

Transparent data encryption [2]

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

Optimized virtual machine images in Azure gallery

Stretch Database

Management and programmability

Runs on Linux and Docker Containers

Temporal tables

JSON support

Graph data support

BI and analytics

Integration services managed as a server

PolyBase for T-SQL query across Hadoop

Tabular BI semantic model [2]

Master data services [2]

Data quality services [2]

In-database advanced analytics

End-to-end Mobile BI on any device

[2] SQL Server Enterprise edition only.

Try the newest edition


View the new capabilities of SQL Server 2017

SQL 2017 Features

|

#1 in price and performance—with massive scale

 

SQL Server consistently leads in the TPC-E OLTP workload, the TPC-H data warehousing workload, and real-world application performance benchmarks. Get record-breaking performance now on Windows and Linux.

 

Highest performing data warehouses

 

Get support for small data marts to large enterprise data warehouses while reducing storage needs with enhanced data compression. Scale to petabytes of data for enterprise-grade relational data warehousing—and integrate with non-relational sources like Hadoop.

Security and compliance

 

Protect data at rest and in motion 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, Jan 17, 2017). Security innovations in SQL Server 2017 help secure data for mission-critical workloads with a layers of protection security approach, adding Always Encrypted technology along with row-level security, dynamic data masking, transparent data encryption (TDE), and robust auditing.

High availability and disaster recovery

 

Gain mission-critical uptime, fast failover, easy setup, and load balancing of readable secondaries with enhanced Always On in SQL Server 2017—a unified solution for high availability and disaster recovery on Linux and Windows. Plus, put an asynchronous replica in an Azure Virtual Machine for hybrid high availability.

Corporate business intelligence

 

Scale your business intelligence (BI) models, enrich your data, and ensure quality and accuracy with a complete BI solution. SQL Server Analysis Services help you build comprehensive, enterprise-scale analytic solutions—benefiting from the lightning-fast performance of in-memory built into the tabular model. Reduce time to insights using direct querying against tabular and multidimensional models.

 

End-to-end mobile BI on any device

 

Gain insights and transform your business with modern, paginated reports and rich visualizations. Use SQL Server Reporting Services to publish reports to any mobile device—including Windows, Android, and iOS devices—and access reports online or offline.

 

Simplify data big and small

 

Combine relational data and big data with PolyBase technology that queries Hadoop using simple T-SQL commands. JSON support lets you parse and store JSON documents and output relational data into JSON files. Now in SQL Server 2017, manage and query graph data inside your relational database.

In-database advanced analytics

 

Build intelligent applications with SQL Server Machine Learning Services using R and Python. Move beyond reactive and into predictive and prescriptive analytics by performing advanced analytics directly within the database. By using multi-threading and massively parallel processing, you’ll gain insights faster than using open source R and Python alone.

 

Real-time hybrid transactional/analytical processing

 

Combine in-memory columnstore and rowstore capabilities in SQL Server 2017 for real-time operational analytics—fast analytical processing right on your transactional data. Open up new scenarios like real-time fraud detection without impacting your transactional performance.

Now on Windows, Linux and Docker

 

Develop once and deploy anywhere with our consistent experience from on-premises to cloud. Now with support for Windows and Linux as well as Docker containers.

 

Consistent data platform from on-premises to cloud

 

Get 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.

 

Easy-to-use tools and connectors

 

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 Microsoft 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.

Available SQL Server 2017 editions

Compare SQL Server 2017 editions

View the comprehensive feature comparison of SQL Server 2017 editions for feature details and limitations.

Feature availability
  • Not supported
  • Fully supported
Table with images and check

Features

SQL Server 2017 Enterprise

SQL Server 2017 Standard

SQL Server 2017 Express

SQL Server 2017 Developer

Scale

Maximum number of cores

Unlimited

24 cores

4 cores

Unlimited

Memory: Maximum buffer pool size per instance

Operating system max

128 GB

1410 MB

Operating system max

Memory: Maximum Columnstore segment cache per instance

Operating system max

32 GB

352 MB

Operating system max

Memory: Maximum memory-optimized data per database

Operating system max

32 GB

352 MB

Operating system max

Maximum database size

524 PB

524 PB

10 GB

524 PB

Production use rights

Unlimited virtualization, a software assurance benefit

Programmability

Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support

OLTP performance

Advanced OLTP: in-memory OLTP, operational analytics [3]

Manageability: Management Studio, policy-based management

Basic high availability: two-node single database failover, non-readable secondary

Advanced high availability: Always On Availability Groups, multi-database failover, readable secondaries

Security

Advanced security: Always Encrypted Row-level security, data masking

Compliance reporting with SQL Server audit

Transparent data encryption

Data integration

Advanced data integration: fuzzy grouping and look ups

Data warehousing

Data marts and data warehousing: partitioning, data compression, change data capture, database snapshot

In-memory columnstore [3]

Adaptive Query Processing [6]

PolyBase [4], [5]

Enterprise data management: Master Data Services, Data Quality Services [5]

Business intelligence

Maximum memory utilized per instance of Analysis Services [5]

Operating system max

Tabular: 16 GB

MOLAP: 64 GB

Operating system max

Maximum memory utilized per instance of Reporting Services [5]

Operating system max

64 GB

Express with Advanced Services: 4 GB

Operating system max

Basic reporting and analytics [5]

Basic data integration: SQL Server Integration Services, built-in connectors

Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode [5]

Mobile reports and KPIs [5]

Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining [5]

Access to Power BI Report Server, a software assurance benefit

Advanced analytics

Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism [5]

Advanced Machine Learning integration: full parallelism of R and Python analytics and the ability to run on GPUs [5]

Machine Learning for Hadoop/Spark and Machine Learning for Linux, a software assurance benefit

Hybrid cloud

Stretch Database [5]

[3] In-memory OLTP and in-memory columnstore are limited to the amount of memory specified by edition in the Scale Limits section. Columnstore and Real-time Operational Analytics are also limited to two degrees of parallelism (two cores/query) in SQL Server Standard edition and one degree of parallelism (one core/query) in SQL Server Web and Express editions.

[4] Scaling out queries using PolyBase requires using SQL Server Enterprise edition as a head node.

[5] Certain features including SQL Server Reporting Services, SQL Server Analysis Services, Machine Learning Services, PolyBase, and Stretch Database are not available in SQL Server 2017 on Linux.

[6] Interleaved Execution is available in all editions.

How to license SQL Server

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.

For sales questions, contact a Microsoft representative at (800) 426-9400 in the United States or (877) 568-2495 in Canada

SQL Server pricing

SQL Server 2017 editions

Ideal for …

Licensing model

Channel availability

Open no level price (US$)

Enterprise

Comprehensive, mission-critical performance for demanding database and business intelligence requirements. Provides the highest service and performance levels for Tier-1 workloads. [7]

Per core [8]

Volume licensing, hosting

$14,256 [9]

Standard - per core

Core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

Per core [8]

Volume licensing, hosting

$3,717 [9]

Standard - server + CAL

Core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

Server + CAL [10]

Volume licensing, hosting, retail FPP

$931 [9]

Developer

Full-featured version of SQL Server software that allows developers to cost-effectively build, test, and demonstrate applications based on SQL Server software.

Per user

Free download

Free

Web

Secure, cost effective and highly scalable data platform for public web sites. Available to third party software service providers only.

Not applicable

Hosting only

See your hosting partner for pricing

Express

Free entry-level database that's ideal for learning, as well as building desktop and small server data-driven applications of up to 10 GB.

Not applicable

Free download

Free

[7] Customers who require a massively parallel processing data warehouse now have access to a parallel data warehouse through their Enterprise Edition core licenses with Software Assurance. Parallel data warehouse is part of the Microsoft Analytics Platform System.

[8] Editions sold in the per-core licensing model are sold as 2 core packs.

[9] Pricing represents open no level (NL) estimated retail price. For your specific pricing, contact your Microsoft reseller.

[10] Client access licenses (CALs) are required for every user or device accessing a server in the Server + CAL licensing model. See the product use rights for details.

Get SQL Server help

Find SQL Server support

Try the newest edition