Description

The SQL Server Update Powershell downloads and installs the updates for Microsoft SQL Server which will ensure a smooth and efficient Database Server on your Windows Server instance. The script itself goes through the following processes:

Clears the temporary software download cache: C:\SoftwareTemp\
Checks that a 64bit version of windows is running, if not alerts you and stops proceeding as only 64bit OS and software are compatible with this script
Checks for administrative rights as admin privileges are required for installing and updating software
Utilisation of any proxy server configurations and testing for an internet connection
The following are points that may require multiple runs of the script in order to pass successfully:
- Download and install powershell 5.1. Previous versions of Powershell are incompatible after this point. If you are running Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 or Windows Server 2019, this script will work. Any other versions are incompatible and require a manual install of at least Powershell 5.1
- Download and install .NET Framework
- Detects your SQL Server Environment and applies the latest service pack and cumulative update
- Detects your SQL Server Management Studio version and applies the latest update

Download

MSSQL_Update_v0.1.9.zip

Change Log:

Version 0.1.9 - 19 Jun 2022

SQL Server Updates, SQL Server Management Studio Updates

Added:

SQL Server 2019 Cumulative Update 16 Security Update
SQL Server 2017 Cumulative Update 29 Security Update
SQL Server 2016 Service Pack 3 Security Update & Azure Connect Feature Pack
SQL Server 2014 Service Pack 3 Cumulative Update 4 Security Update
SQL Server Management Studio 18.12

Version 0.1.8 - 21 Apr 2022
SQL Server Updates, SQL Server Management Studio Updates

Added:

SQL Server 2019 Cumulative Update 16
SQL Server 2017 Cumulative Update 29
SQL Server Management Studio 18.11.1

Version 0.1.7 - 28 Nov 2021

SQL Server Updates

Added:

SQL Server 2019 Cumulative Update 14

Version 0.1.6 - 7 Nov 2021
SQL Server Updates

Added:

SQL Server 2017 Cumulative Update 27
SQL Server 2016 Service Pack 3 Hotfix

Version 0.1.5 - 21 Oct 2021
SQL Server Updates, SQL Server Management Studio Updates

Added:

SQL Server 2019 Cumulative Update 13
SQL Server 2017 Cumulative Update 26
SQL Server 2016 Service Pack 3
SQL Server Management Studio 18.10

Version 0.1.4 - 16 Sept 2021
SQL Server Updates, SQL Server Management Studio Updates

Added:

SQL Server 2019 Cumulative Update 12
SQL Server Management Studio 18.9.2

Version 0.1.3 - 15 Jul 2021
SQL Server Updates, SQL Server Management Studio Updates

Added:

SQL Server 2019 Cumulative Update 11
SQL Server 2017 Cumulative Update 25
SQL Server Management Studio 18.9.1

Version 0.1.2 - 15 Apr 2021
SQL Server Updates

Added:

SQL Server 2019 Cumulative Update 10
SQL Server 2017 Cumulative Update 23
SQL Server 2016 Service Pack 2 Cumulative Update 17
SQL Server 2014 Service Pack 3 Cumulative Update 4 + Security Update
SQL Server 2012 Service Pack 4 Security Update

Version 0.1.1 - 19 Dec 2020
SQL Server Management Studio 18.8

Added:

SQL Server Management Studio 18.8

Version 0.1.0 - 19 Nov 2020
Migration of update script over to new Azure DevOps instance

Migrated:

Powershell 5 for Windows 7
Powershell 5 for Windows 8
Powershell 5 for Windows 8.1
Powershell 5 for Windows Server 2008 R2
Powershell 5 for Windows Server 2012
Powershell 5 for Windows Server 2012 R2
.NET Framework 4.8
SQL Server 2008 Service Pack 4 Update 10.00.6556
SQL Server 2008 R2 Service Pack 3 Update 10.50.6560
SQL Server 2012 Service Pack 4 Security Update (7493.4)
SQL Server 2014 Service Pack 3 Cumulative Update 4
SQL Server 2016 Service Pack 2 Cumulative Update 15
SQL Server 2017 Cumulative Update 22
SQL Server 2019 Cumulative Update 8
SQL Server Management Studio 16.5.3 (for SQL Server 2016)
SQL Server Management Studio 17.9.1 (for SQL Server 2017)
SQL Server Management Studio 18.7.1 (for SQL Server 2019)

How to run

Log into the database server via remote desktop or directly.

Data Analytics > SQL Server Update Powershell > image2020-5-4_9-6-46.png

We need to start Powershell in administrator mode, one way is to right-click on the start menu and select "Windows powershell (Admin)"

Click "Yes" to confirm administrator control

Using the command line, browse to the directory where the powershell scripts are stored.
Data Analytics > SQL Server Update Powershell > image2020-5-4_9-16-28.png

Type "SQL" and press "TAB", the script running command show autocomplete (as shown below)
Data Analytics > SQL Server Update Powershell > image2020-5-4_9-16-51.png

Press "Enter", the process steps should appear
Data Analytics > SQL Server Update Powershell > image2020-5-4_9-17-30.png

Re run the script until you see the following in green text (as shown above).

"No update to Microsoft SQL Server is required."