Run SQL Server on your favorite platform

It'due south all about option. Now, you tin get SQL Server 2017's industry-leading performance and security on Windows, Linux, and Docker containers.

Featured SQL Server resource

Introducing SQL Server 2019

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

Gartner Magic Quadrant for Deject Database Management Systems

Read Gartner's assessment of the cloud DBMS landscape and learn why Microsoft has been recognized as a leader.

Azure SQL Information Warehouse

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

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

#1 in price and performance—with massive calibration

SQL Server consistently leads in the TPC-Due east OLTP workload, the TPC-H information warehousing workload, and real-world awarding performance benchmarks. Get tape-breaking performance now on Windows and Linux.

Highest performing data warehouses

Get support for pocket-size data marts to large enterprise data warehouses while reducing storage needs with enhanced information 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 whatsoever major platform for six years running in the NIST vulnerabilities database (National Plant 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, calculation Always Encrypted technology along with row-level security, dynamic data masking, transparent data encryption (TDE), and robust auditing.

Loftier 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 loftier 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 straight querying confronting tabular and multidimensional models.

End-to-stop 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 information big and small

Combine relational data and big information 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 information inside your relational database.

In-database advanced analytics

Build intelligent applications with SQL Server Motorcar Learning Services using R and Python. Motion beyond reactive and into predictive and prescriptive analytics by performing avant-garde analytics directly inside the database. By using multi-threading and massively parallel processing, y'all'll gain insights faster than using open source R and Python alone.

Real-fourth dimension hybrid transactional/analytical processing

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

Now on Windows, Linux and Docker

Develop in one case and deploy anywhere with our consistent feel from on-premises to deject. Now with support for Windows and Linux as well every bit Docker containers.

Consistent data platform from on-bounds to deject

Get a consistent feel 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 calibration and further simplify database management.

Easy-to-employ tools and connectors

Employ the skills you already have, along with familiar tools similar Azure Agile 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.

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

iv cores

Unlimited

Memory: Maximum buffer pool size per instance

Operating system max

128 GB

1410 MB

Operating arrangement max

Memory: Maximum Columnstore segment cache per case

Operating system max

32 GB

352 MB

Operating organization max

Memory: Maximum memory-optimized data per database

Operating organization max

32 GB

352 MB

Operating system max

Maximum database size

524 Lead

524 Lead

10 GB

524 PB

Production utilize rights

Unlimited virtualization, a software assurance benefit

Programmability

Programmability and developer tools: T-SQL, SQL CLR, Service Banker, JSON, XML, graph data back up

OLTP performance

Avant-garde OLTP: in-memory OLTP, operational analytics [three]

Manageability: Management Studio, policy-based management

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

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

Security

Advanced security: Ever Encrypted Row-level security, information masking

Compliance reporting with SQL Server audit

Transparent data encryption

Data integration

Advanced information integration: fuzzy grouping and await ups

Information warehousing

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

In-memory columnstore [3]

Adaptive Query Processing [6]

PolyBase [iv], [5]

Enterprise data direction: Principal Information Services, Data Quality Services [5]

Business intelligence

Maximum memory utilized per case of Assay Services [5]

Operating organisation max

Tabular: 16 GB

MOLAP: 64 GB

Operating system max

Maximum retention utilized per instance of Reporting Services [v]

Operating system max

64 GB

Express with Advanced Services: 4 GB

Operating organisation max

Basic reporting and analytics [5]

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

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

Mobile reports and KPIs [5]

Avant-garde corporate concern intelligence: advanced multi-dimensional models, avant-garde tabular model, DirectQuery storage way, advanced data mining [5]

Admission to Ability BI Report Server, a software assurance benefit

Advanced analytics

Basic Car Learning integration: connectivity to open source Python and R, express parallelism [v]

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

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

Hybrid cloud

Stretch Database [5]

[iii] In-retention OLTP and in-memory columnstore are express to the amount of memory specified by edition in the Scale Limits section. Columnstore and Real-time Operational Analytics are besides express to 2 degrees of parallelism (two cores/query) in SQL Server Standard edition and one caste of parallelism (1 core/query) in SQL Server Spider 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.

[half dozen] Interleaved Execution is available in all editions.

Other SQL Server 2017 editions

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-ane workloads. [seven]

Per cadre [eight]

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

$three,717 [9]

Standard - server + CAL

Core data management and concern intelligence capabilities for not-disquisitional 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 price-effectively build, test, and demonstrate applications based on SQL Server software.

Per user

Gratis 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

Come across your hosting partner for pricing

Limited

Free entry-level database that's ideal for learning, every bit well as edifice desktop and modest server information-driven applications of up to 10 GB.

Not applicable

Free download

Gratuitous

[7] Customers who crave a massively parallel processing data warehouse now have admission to a parallel data warehouse through their Enterprise Edition cadre licenses with Software Assurance. Parallel data warehouse is role of the Microsoft Analytics Platform System.

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

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

[x] 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.

How to buy SQL Server