Service Packs and Updates
Source: //www.digipas.com/files/photos-firmware/software-btn1.png
One of the things that I always check on client servers is that they are running the latest service packs, for both SQL Server and for the Windows OS itself. Now, sometimes I know what the latest service pack is – but other times I don’t. Therefore, I end up spending more time than I would like looking up the latest service pack. Therefore, I’m making a list of service packs here, along with download links (as I find them – navigating Microsoft’s Download Center isn’t exactly a piece of cake). I tried to get the download links for both 32-bit and 64-bit architectures, where applicable. Hopefully, you can use this chart also.
If you have a link to any that I have missed, please leave me a comment so that I can update this! I’d appreciate your help.
Windows Update Rollups
| Windows Version(s) | Date | Update | Prerequisites |
|---|---|---|---|
| 10, 2016 | Latest | Windows 10 and Windows Server 2016 Update History | None |
| 8.1, 2012R2 | Latest | Windows 8.1 and Windows Server 2012 R2 update history | April 2014 Update RollupService Stack Update |
| 8 | Latest | Links have been removed | None |
| 2012 | Latest | Windows Server 2012 update history | None |
| 7, 2008R2 | Latest | Windows 7 SP1 and Windows Server 2008 R2 SP1 update history | SP1 Servicing Stack Update |
Monthly Rollups are not cumulative. Update rollups explained.
Reference: Windows 10 and Windows Server 2016 Update History
Reference: Windows 8.1 and Windows Server 2012R2 Update History
Reference: Windows Server 2012 Update History
Reference: Windows 7 SP1 & Windows Server 2008R2 Update History
Back to Contents
Windows Server Versions
| Operating System | RTM | SP1 | SP2 | SP3 | SP4 |
|---|---|---|---|---|---|
| Windows 2016 | 10.0.14393 | ||||
| Windows 2012 R2 | 6.3.9200 | ||||
| Windows 2012 | 6.2.9200 | ||||
| Windows 2008 R2 | 6.1.7600.16385 | 6.1.7601 | |||
| Windows 2008 | 6.0.6000 | 6.0.6001 | 6.0.6002 | ||
| Windows 2003 R2 | 5.2.3790.1180 | 5.2.3790.? 64-bit |
|||
| Windows 2003 | 5.2.3790 | 5.2.3790.1180 64-bit |
5.2.3790.? 64-bit |
||
| Windows 2000 | 5.00.2195 | 32-bit |
Windows (non-server) Versions
| Operating System | RTM | SP1 | SP2 | SP3 | SP4 |
|---|---|---|---|---|---|
| Windows 10 | 10.0.10240 | ||||
| Windows 8.1 | 6.3.9200 | 6.3.9600 32-bit, 64-bit |
|||
| Windows 8 | 6.2.9200 | ||||
| Windows 7 | 6.1.7600 | 6.1.7601 | |||
| Windows Vista | 6.0.6000 | 6.0.6001 | 6.0.6002 | ||
| Windows XP x64 | 5.2.2600 | 5.2.2600.1105 | 5.2.2600.2180 | ||
| Windows XP | 5.1.2600 | 5.1.2600.1105 | 5.1.2600.2180 | 5.1.2600.5512 | |
| Windows 2000 | 5.00.2195 | 32-bit |
SQL Server Versions
| Version | RTM | SP1 | SP2 | SP3 | SP4 |
|---|---|---|---|---|---|
| SQL Server 2022 Builds EOMS: 2028-01-11 |
16.0.1000.6 CU15 16.0.4145.4 |
Service Packs will not be released, only CUs. See Modern Service Model for SQL Server. |
|||
| SQL Server 2019 Builds EOMS: 2025-01-07 |
15.0.2000.5 CU12 15.0.4153.1 |
||||
| SQL Server 2017 Builds EOMS: 2022-10-11 |
14.0.1000.169 CU26 14.0.3411.3 |
||||
| SQL Server 2016 Builds EOMS: 2021-07-13 |
13.0.1601.5 CU9 13.0.2216.0 |
13.0.4001.0 CU15 13.0.4574.0 |
13.0.5026.0 CU17 13.0.5888.11 |
13.3.6300.2 SP3 |
|
| SQL Server 2014 Builds EOMS: 2019-07-09 |
12.0.2000.8 CU14 12.00.2569.0 |
12.0.4100.1 CU13 12.00.4520.0 |
12.0.5000.0 CU18 12.0.5687 |
12.0.6024.0 CU4+SU 12.0.6433.1 |
|
| SQL Server 2012 EOMS: 2017-07-11 |
11.0.2100.60 CU11 11.00.2424 |
11.0.3000.0 CU111.00.3492 |
11.0.5058.0 CU16 11.00.5678 Latest CU |
11.0.6020.0 CU10 11.0.6607.3 Latest CU |
11.0.7001.0 CUs not planned |
| SQL Server 2008 R2 EOMS: 2014-07-08 |
10.50.1600.1 CU14 10.50.1817 |
10.50.2500.0 CU13 10.50.2876 |
10.50.4000.0 CU13 10.50.4319 |
10.50.6000.34 CUs not planned |
|
| SQL Server 2008 EOMS: 2014-07-08 |
10.0.1600.22 CU10 10.00.1835 |
10.0.2531.0 CU16 10.00.2850 |
10.0.4000.0 CU11 10.00.4333 |
10.0.5500.0 CU17 10.00.5861 |
10.0.6000.29 CUs not planned |
| SQL Server 2005 EOMS: 2011-04-12 |
9.0.1399.06 | 9.0.2047 | 9.0.3042 CU17 9.00.3356 |
9.0.4035 CU15 9.00.4325 |
9.0.5000 CU3 9.00.5266 |
| SQL Server 2000 EOMS: 2008-04-08 |
8.0.19 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| SQL Server 7 EOMS: 2005-12-31 |
7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
EOMS is “End of Mainstream Support”.
Reference: Update Center for Microsoft SQL Server
Reference: SQL Server Release Services Blog
Reference: SQL Server Lifecycle
Back to Contents
SQL Server Tools
| Tool | Latest Download |
|---|---|
| SQL Server Data Tools (SSDT) | Latest SSDT Release |
| SQL Server Migration Assistant (SSMA) | Latest SSMA Release |
| SQL Server Management Studio (SSMS) | Latest SSMS Release |
| Kerberos Configuration Manager for SQL Server | Latest Release |
| SQL Operations Studio (SOS) | Latest SOS Release |
| mssql-cli (SQL Server command line client) | Latest Release |
| SQL Setup Tools | Latest Release |
Reference: SQL Server Release Services Blog
Back to Contents
Microsoft System Center Management Packs for SQL Server
| Item | 2008/R2 | 2012 | 2014 | 2016 | 2017+ |
|---|---|---|---|---|---|
| Database Engine (7.0.20.0) | Link | Link | |||
| Replication (6.7.31.0) | Link | Link | Link | Link | Link |
| Analysis Server (7.0.7.0) | Link | Link | Link | Link | Link |
| Reporting Services (7.0.7.0) | Link | Link | Link | Link | Link |
| Dashboards (7.0.15.0) | Link | ||||
| Azure SQL Database (7.0.4.0) | Link | ||||
Reference: SQL Server Release Services Blog
Back to Contents
SQL Server sample databases
| Sample Database |
|---|
| AdventureWorks |
| WideWorldImporters |
| In-Memory OLTP Performance Demo |
| Stack Overflow public databases |
| Babby Names (from SSA) |
| Free Government DataSets |
