Cookies op Tweakers

Tweakers maakt gebruik van cookies, onder andere om de website te analyseren, het gebruiksgemak te vergroten en advertenties te tonen. Door gebruik te maken van deze website, of door op 'Ga verder' te klikken, geef je toestemming voor het gebruik van cookies. Wil je meer informatie over cookies en hoe ze worden gebruikt, bekijk dan ons cookiebeleid.

Meer informatie

Software-update: SQL Server Management Studio 18.4

Microsoft heeft versie 18.4 van SQL Server Management Studio, 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:

What's new in 18.4
  • Data Classification Added support for custom information protection policy for data classification.
  • Query Store Added the Max Plan per query value in the dialog properties.
  • Query Store Added support for the new Custom Capture Policies.
  • SMO/Scripting Support Script of materialized view in SQL DW.
  • SMO/Scripting Added support for SQL On Demand.
  • SMO/Scripting SQL Assessment API - Added 50 assessment rules (see details on GitHub).
  • SMO/Scripting SQL Assessment API - Added base math expressions and comparisons to rules conditions.
  • SMO/Scripting SQL Assessment API - Added support for RegisteredServer object.
  • SMO/Scripting SQL Assessment API - Updated way how rules are stored in the JSON format and also updated the mechanism of applying overrides/customizations.
  • SMO/Scripting SQL Assessment API - Updated rules to support SQL on Linux.
  • SMO/Scripting SQL Assessment API - Updated the ruleset JSON format and added SCHEMA version.
  • SMO/Scripting SQL Assessment API - Updated cmdlets output to improve readability of recommendations.
  • XEvent Profiler Added error_reported event to XEvent Profiler sessions.
Bug fixes in 18.4
  • Analysis Services Fixed an issue where the DAX Script editor for multi-dimensional databases didn't show tables in the IntelliSense.
  • Analysis Services Use DAX Parser to convert to an Engine string. This is for international separators, decimal, and whitespace.
  • Always Encrypted Fixed an issue where the claim validation was not case insensitive.
  • Always Encrypted Fixed an issue where error/warning reporting was not properly working.
  • Copy Database Wizard Fixed assorted truncation and layout issues in the rendering of this dialog.
  • General SSMS Fixed a long outstanding issue where SSMS was not honoring the connection info passed at the command line when SQL files were also specified.
  • General SSMS Fixed a crash in SSMS while trying to display Securables on "Replication Filter" objects.
  • General SSMS Mitigated the removal of the -P command-line option by having SSMS look at its cache of credentials: if the required credential were found, the connection would be established using it.
  • Import flat file Fixed an issue where Import Flat File functionality not handling text qualifiers correctly.
  • Object Explorer Fixed an issue where dropping an Azure SQL Database in Object Explorer was showing an incorrect message.
  • Query Results Fixing an issue introduced in SSMS 18.3.1, where grids would be drawn slightly too narrow and show ... at the end of the longest string in every column.
  • Replication Tools Fixed an issue that was causing the application to throw an error ("Could not load file or assembly…") when trying to edit SQL Agent jobs.
  • SMO/Scripting Fixed an issue when Script Table As… for SQL DW whose collation is Japanese_BIN2 was not working.
  • SMO/Scripting Fixed an issue where ScriptAlter() ended up executing the statements on the server.
  • SQL Agent Fixed an issue where the agent operator UI would not update the operator name when it was changed in the UI, nor would it be scripted. See UserVoice for more details.
Known issues (18.4)
  • Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). See UserVoice for more details.
  • There are redraw issues when switching between multiple query windows. See UserVoice for more details. A workaround for this issue is to disable hardware acceleration under Tools > Options.
You can reference UserVoice for other known issues and to provide feedback to the product team.
Versienummer 18.4
Releasestatus Final
Besturingssystemen Windows 7, Windows Server 2012, Windows 10, Windows Server 2016
Website Microsoft
Download https://aka.ms/ssmsfullsetup
Licentietype Freeware

Reacties (1)

Wijzig sortering
Dit is de versie van SMSS die samen is uitgegeven met SQL Server 2019. SQL Server 2019 RTM is eergisteren (4 nov) vrijgegeven en is beschikbaar via VLSC.
SQL Server 2019 is now generally available
(Heb de redactie op 4 november 'getipt', om voor mij onduidelijke reden is de SMSS 18.4 wel een item geworden, maar het veel belangrijkere SQL Server 2019 RTM niet)


Om te kunnen reageren moet je ingelogd zijn


Apple iPhone 11 Nintendo Switch Lite LG OLED C9 Google Pixel 4 FIFA 20 Samsung Galaxy S10 Sony PlayStation 5 Elektrische auto

'14 '15 '16 '17 2018

Tweakers vormt samen met Hardware Info, AutoTrack, Gaspedaal.nl, Nationale Vacaturebank, Intermediair en Independer DPG Online Services B.V.
Alle rechten voorbehouden © 1998 - 2019 Hosting door True