Latest version Microsoft sql server

Download the latest (new) version Microsoft sql server:
https://www.microsoft.com/en-ca/sql-server/sql-server-downloads

Microsoft SQL Server 2019 (developer)

Download for free Microsoft SQL Server 2019 (developer)
https://go.microsoft.com/fwlink/?linkid=866662

Microsoft SQL Server 2019 (express)

Download for free Microsoft SQL Server 2019 (express)
https://go.microsoft.com/fwlink/?linkid=866658

Microsoft SQL Server 2017 (developer)

Download for free Microsoft SQL Server 2017 (developer)
https://go.microsoft.com/fwlink/?linkid=853016

Microsoft SQL Server 2017 (express)

Download for free Microsoft SQL Server 2017 (express)
https://go.microsoft.com/fwlink/?linkid=853017

Microsoft SQL Server 2014 (express)

Download for free Microsoft SQL Server 2014 (express)
https://www.microsoft.com/en-US/download/details.aspx?id=42299

Microsoft SQL Server 2012 (express)

Download for free Microsoft SQL Server 2012 (express)
https://www.microsoft.com/en-US/download/details.aspx?id=56042

Microsoft SQL Server 2012 (express local DB)

Download for free Microsoft SQL Server 2012 (express local DB)
https://drive.google.com

SQL Server (Version 2019, 2017) Express

SQL Server (Version 2019, 2017) Developer

SQL Server (Version 2019, 2017) Standard

SQL Server (Version 2019, 2017) Enterprise

Price

for free

for free

Fee

Fee

Description

Part of the functionality is available

Part of the functionality is not available

Version Express can be installed on both regular Windows and Windows Server

All functionality is available

Not everywhere can be used.

You can use:
• For development, testing purposes only
• Not for sale

Version Developer can be installed on both regular Windows and Windows Server

All functionality is available

Version Standard can be installed on both regular Windows and Windows Server

All functionality with advanced features is available

Attention! Version Enterprise can only be set to Windows Server

Ability to create a cluster

Yes

Maximum number of cores

4 cores

Unlimited

24 cores

Unlimited

Memory: maximum size of pool, buffer per instance

1410 mb

maximum (as the operating system allows)

128 gb

maximum (as the operating system allows)

Memory: Maximum segment cache Columnstore per instance

352 mb

maximum (as the operating system allows)

32 gb

maximum (as the operating system allows)

Memory: Maximum amount of data in optimized memory per database

352 mb

maximum (as the operating system allows)

32 gb

maximum (as the operating system allows)

Maximum database size

10 gb

524 pb

524 pb

524 pb

Production Use Rights

Yes

Yes

Yes

Virtualization without borders, benefits of the program Software Assurance

Yes

Basic

I always use the Basic option. You don't need to configure anything in the installation. Installation is fast.

Custom

The Custom option is needed when we want to add a component Python or other components

Download Media

The Download Media option creates an installation file (image) to then install SQL Server 2017 on another computer.