SQL SERVER – Check for Update in SSMS

Just last week, I had a very interesting consulting engagement with large financial technology organizations. DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. One of the question was related to how to check the update in SSMS.

SQL SERVER - Check for Update in SSMS update-ssms-800x533

My client asked me quite a few questions about SQL Server Management Studio and also about how the execution plan works overall. During the session, I advised them to check out the latest SQL Server Management Studio (SSMS), which works with many of the previous version of SQL Server flawlessly.

The issue was that they had recently installed SQL Server Management Studio 18.0 but had not checked about the update of the same. There have been a lot of enhancements in SSSMS 18.0 and it is a good idea that you enable your SSMS to check the updates automatically.

Here is the screenshot of the settings which you should have enabled to automatically check SSMS updates.

SQL SERVER - Check for Update in SSMS ssmsupdate1

SQL SERVER - Check for Update in SSMS ssmsupdate2

If you have enabled the auto-update settings, SQL Server will notify you for updating the SSMS. Here is the link for updating SSMS: Download SQL Server Management Studio 18.0 (General Availability).

I always suggest that everyone should update their SSMS to the latest update. Here are a few additional blog posts which are related to SQL Server Management Studio.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , , ,
Previous Post
SQL SERVER – Enable Lock Pages in Memory LPIM
Next Post
SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT

Related Posts

2 Comments. Leave new

  • Albert van Biljon
    September 18, 2019 1:43 pm

    Perhaps it is worth mentioning that for SQL Server Management Studio 18.0, Windows 10 is required. If you’re on Windows 7 like me, I unfortunately have to miss out on that until the company upgrades!

    Reply
  • Trinity Rolling
    November 15, 2019 2:43 am

    I know it’s strongly encouraged to have automatic updates enabled. Has anyone discovered a way to disable automatic updates for v18.x? We do controlled releases of software updates to workstations.

    Reply

Leave a Reply

Menu