Share via

Announcing SQL Server Management Studio - April 2016 Release

  • Article

Today, we are very pleased to announce the latest preview of SQL Server Management Studio (SSMS). This release includes all updates included in the March refresh release, and features improvements in the SSMS installer to add human readable error messages, improvements in the Stretch database wizard to add support for predicates, and numerous bug fixes in the Always Encrypted wizard, and SSMS toolbar options.

Get it here: Download SSMS April 2016 Preview

  • The version number for the latest preview is 13.0.14000.36

New in this release

  1. Improvement in the SSMS installer to add human-readable error messages.
  2. Improvement in the Stretch database wizard to add support for predicates.
  3. Improvement in the AlwaysEncrypted Powershell commandlet to add key encryption APIs.
  4. Fix for Microsoft Connect item #2555163: to turn off IntelliSense in the SSMS toolbar if it has been disabled in the Tools,Options dialog.
  5. Improvements and bug fixes in the Showplan comparison user interface to reduce the spacing used by long query plans.
  6. Bug fixes in SSMS to fix issues that caused SSMS to crash when exiting.
  7. Bug fixes in the Always Encrypted wizard to retain user permissions during encryption and to allow database detach operations after the wizard is complete.
  8. Bug fix in Always Encrypted New Column Master Key dialog to provide feedback on attempt to generate a key using an unsupported Cryptographic Algorithm (CNG) provider.

Please visit the SSMS download page for additional details including Microsoft connect IDs for issues that were fixed.

Known Issues

The full list of known issues is available in Release notes available here.

Contact us

If you have any questions or feedback, please visit our forum or Microsoft Connect page. We are fully committed to improve the SSMS experience and look forward to hearing from you!

Comments

  • Anonymous
    April 18, 2016
    Coming from SSMS 2014, I liked to set the zoom in SSMS query editor at different levels, depending on the tab (i.e. window / query). But in SSMS 2016 March preview, when I change the zoom in one query pane, it changes in all open query tabs. Is this a bug or by design? Or is there a setting I can use to make query windows zoom independently of each other?
    • Anonymous
      May 19, 2016
      The March Preview is based on the Visual Studio 2015 Isolated Shell in difference to previous version that was based on VS2010. So my guess is that this is a change at VS to which SSMS is at prey. I tested this in VS2015, and indeed it behaves the same. I found no setting to control it. The VS people has a habit of doing all sorts of funny things without asking.
  • Anonymous
    April 21, 2016
    Where can we file a bug report?If you create a view with 2 tables that are linked on a foreign key, if you right-click the diamond icon between them (eg. to include ALL the items from Table1 even if no item exists in Table 2, it crashes 100% of the time (right at the point of right-clicking on that diamond icon).
  • Anonymous
    April 27, 2016
    It looks like this SSMS release doesn’t allow any 3rd party extensions. Any plans to reconsider this policy?
  • Anonymous
    May 11, 2016
    I'm having an issue with drag and drop in this version. If I have a query window open, dropping an SQL file into it does nothing. It still works if I drop the file into another area of the window. Dropping in the query window works in prior releases.
    • Anonymous
      May 16, 2016
      Thanks for your feedback. We are already addressing this for a future release.
  • Anonymous
    June 04, 2016
    I am having the same problem as Mike reported a month ago - If you create a view with 2 tables that are linked on a foreign key, if you right-click the diamond icon between them (eg. to include ALL the items from Table1 even if no item exists in Table 2, it crashes 100% of the time (right at the point of right-clicking on that diamond icon).Since this issue is not getting resolved very quickly, is there a recommended work around?
  • Anonymous
    June 22, 2016
    I am having the crash problem reported below. I select two tables and join the key fields. When I right-click on the link to change the join, the system always crashes and restarts. Version: Microsoft SQL Server Management Studio 13.0.15000.23