Released: May 16, 2018

Updates in 5.9.60

Features

• Active Directory - Universal with MFA support - Implemented new SSMS 17.2 - “Active Directory - Universal with MFA support” authentication method. This two-step authentication methond provides an extra layer of protection, such as a phone call, text message, or mobile app code, to deliver an even more secure access to data and applications.
• Code Completion - New statement suggestions:
  • TEMPORAL_HISTORY_RETENTION
  • HISTORY_RETENTION_PERIOD
  • IDENTITY_CACHE and Automatic database tuning
• Code Refactoring - Rename variables in UPDATETEXT, WRITETEXT, READTEXT, and REVERT statements in a few clicks using a handy Rename dialog window.
• Results Grid Data Visualizer - The Data Viewer allows you to instantly visualize data from the results grid via Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, or Spatial views.
• Copy Data As XML, CSV, HTML, or JSON from SSMS grid - An easy way to retrieve data from a SSMS results grid to a format suitable for you.
• Copy Data from a SSMS grid to the Clipboard or a File - Quickly copy data in any available file format to a file or the clipboard.
• Shortcuts to SSMS grid popup menu assigned - Added shortcuts to Find, Copy Data As...To Clipboard and Generate Script As...To Clipboard.