Get the latest version of SQL Server and latest version of SSMS

There have been many versions of SQL Server released over a long period of time and of course these are followed up by Service Packs (SP). It is hard to know which version is going to be installed.

There is an unofficial chart lists of all the known SP;s, Cumulative Updates(CU), patches and hot-fixes from SQL Server 7.0 to SQL Server 2017.

SQL Versions.png

Read here: https://sqlserverbuilds.blogspot.com/

I have a reasonably latest version of SQL Server 2016 Developer edition:

Microsoft SQL Server 2016 (SP1-GDR) (KB4019089) - 13.0.4206.0 (X64)   Jul  6 2017 07:55:03   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows 10 Pro 6.3 (Build 17134: ) (Hypervisor) 

The following version download is here:

13.0.5206.0 4/9/2018; SQL Server 2016 SP2
https://www.microsoft.com/en-us/download/details.aspx?id=56836

Download details for SQL Server 2016 SP1 with the following details:

https://www.microsoft.com/en-us/download/details.aspx?id=54276

---------------

Version:            13.0.4001.0
File Name:          ENU\SQLServer2016SP1-KB3182545-x64-ENU.exe
Date Published:     11/15/2016
File Size:          551.8 MB

----------------

For SQL Server 2016 SP1 and above you do not install SQL Server Management Studio. You need to install it separately.

https://youtu.be/Hc1cXzdjPGQ