How to automatically update sql management studio

SQL Management Studio comes with an inbuilt Updater , however it requires opening the SQL Manegment studio application and is not automatic. Sometimes people don’t open SQL management studio in a long while and this doesn’t get upgrade and vulnerable to security issues

Entering Choco!

You will need to uninstall SQL Management Studio

Install Choco per below ( This will install .net Frame 4.8 and need a reboot ( Not Automatic ) )

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))

Then install SQL management studio via Chocol

https://community.chocolatey.org/packages/sql-server-management-studio

Then you can deploy the upgrade command to keep it upgraded every week

https://community.chocolatey.org/packages/choco-upgrade-all-at

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...