Software-update: SQL Server Management Studio 18.1

Microsoft heeft SQL Server Management Studio 18.1, vaak afgekort tot SSMS, uitgebracht. Met SSMS kun je een Microsoft SQL-omgeving beheren, bijvoorbeeld een on-premise SQL Server, maar ook een Azure SQL Data Warehouse in de cloud. Het biedt tools voor de configuratie, monitoring en ingebruikname van de verschillende datatiercomponenten. Daarnaast kun je queries en scripts in elkaar zetten. De bijbehorende aankondiging ziet er als volgt uit:

SQL Server Management Studio (SSMS) 18.1 is now generally available

We’re excited to announce the release of SQL Server Management Studio (SSMS) 18.1. It’s been just over a month since we released SSMS 18.0. While we brought in many fantastic capabilities, we also regressed some functionality for some of our users. We are happy to share that we’ve fixed those and are also bringing in some new features along with bug fixes.

As many of you may know, we have already enabled certain Azure Data Studio capabilities such as launching Notebooks, ADS, etc. from SSMS.

In our June release of Azure Data Studio, we also enabled launching SSMS functionality from Azure Data Studio. You can check Alan’s blog post describing these features to learn more.

You can download SQL Server Management Studio 18.1 today and review the SSMS release notes for further details. Some of the recent updates include:

SSMS

• Yes, we’ve heard the feedback; Database Diagrams is back.
• And, so is ssbdiagnose utility.
• Is SSMS ignoring Intellisense settings? Not anymore!

SSIS

• Support for scheduling the SQL Server Integration Services (SSIS) package is now available, located in the SSIS catalog in Azure or the file system in Azure. There are three ways to launch the New Schedule dialog; the first is from the New Schedule menu item shown when you right click the SSIS package in the SSIS catalog in Azure, the second is from the Schedule SSIS Package in Azure menu item under the Migrate to Azure menu in Tools, and the third is under Schedule SSIS in Azure that displays when you right click on the Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.

SSMS setup

• We heard the feedback here too, and have fixed the issue where SSMS was exiting immediately after showing the splash screen.
• We also fixed an issue that was causing SSMS setup to fail when the setup log path contained spaces.

We have also resolved a number of other issues in areas such as Object Explorer, SQL Agent, accessibility, Intellisense, SMO scripting, data classification, etc.

Please see the release notes for a comprehensive list of bug fixes.

As always, we are always listening and would love to hear your feedback with any questions, comments, or feature suggestions.

Versienummer	18.1
Releasestatus	Final
Besturingssystemen	Windows 7, Windows Server 2012, Windows 10, Windows Server 2016
Website	Microsoft
Download	https://go.microsoft.com/fwlink/?linkid=2094583
Licentietype	Freeware

Reacties (7)

[EchoWhiskey]

Link wijst naar versie 18.0

Dit is de link naar 18.1
https://go.microsoft.com/fwlink/?linkid=2094583

[RMM65]

of hier link naar de SQL Server Management Studio (SSMS) download page;
https://docs.microsoft.co...ssms?view=sql-server-2017
(persoonlijk vind ik blinde dowload links nooit zo prettig)

[Caayn]

•Yes, we’ve heard the feedback; Database Diagrams is back.

Tijd om te upgraden van 17 naar 18.

[ge-flopt]

Ik gebruik hem niet vaak, maar soms is het wel makkelijk om een inzicht in een onbekende database te krijgen.

[pven]

Ah, het zat er gewoon niet meer in. Ik vroeg me al af of het aan mij lag.

[ZyKl0n_242]

Joepie de poepie!

(gebruik al 6 jaar geen ERD's meer, genereer enkel nog Db's vanuit code maar goed...)

[-DEVON-]

•We heard the feedback here too, and have fixed the issue where SSMS was exiting immediately after showing the splash screen.

Yeah! Was wel een vervelende bug, wel met workaround, maar toch.