Announcing SQL Server Management Studio - June 2016 Release
Today, we are very pleased to announce the generally available release of SQL Server Management Studio (SSMS). This release includes all updates included in the April preview release, and features a new Quick Find dialog in SSMS, improvements in the SSMS installer to allow tracking of installation progress, bug fixes in the Always Encrypted experience, and many more.
Get it here: Download SSMS June 2016 generally available release
- The version number for the latest preview is 13.0.15000.23
New in this release
- SSMS is generally available starting with the June 2016 release.
- New quick find dialog in SSMS that is better integrated into the current document and allows searching via regular expressions (Microsoft Connect item # 2735513).
- Improvements in the SSMS installer to allow you to track installation progress and process exit codes for unattended installations via scripts.
- Bug fix in the SSMS context-sensitive F1 help to correctly display help documents and articles.
- Bug fix in the Query Data Store ‘Regressed Queries’ view to fix issue that caused SSMS to crash when scrolling.
- Bug fix in Excel Analysis Services OLEDB connector to allow connections from Excel 2016 to SQL Server Analysis Services.
- Bug fixes in SSMS connection dialog to show the connection dialog on the same monitor as the main SSMS window in multi-monitor systems (Microsoft Connect item #755689).
- Bug fixes in the Always Encrypted experience. Fixed bug where Always Encrypted menu option was not enabled correctly for Stretch databases. Also fixed bug in the Always Encrypted wizard where it was not properly using the SafeNet (Luna SA) HSM provider.
Please visit the SSMS download page for additional details including Microsoft connect IDs for issues that were fixed.
Known Issues
- PowerShell script generation from the Always Encrypted wizard is currently disabled. A fix for this issue will be available in a subsequent monthly SSMS update.
- The ‘Encrypt columns’ context menu item in Object Explorer is disabled for tables and columns when you are connected to an Azure SQL Database. This issue occurs when you are connected to an Azure SQL Database and right-click a table or column and choose ‘Encrypt column’. A fix for this issue will be available in a subsequent monthly SSMS update. As a workaround, right-click the database node in Object Explorer and choose ‘Encrypt columns’ to encrypt Azure SQL Database columns and tables.
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
June 02, 2016
Was this release supposed to turn on CodeLens in VS2015 Community edition?I've just installed it, and I now get the "x references" tip above every member in my VS2015CE projects. I thought that was supposed to be an "ultimate edition only" feature? - Anonymous
June 06, 2016
Hi SSMS-Team,its a great tool! The DBAs I know like it to organize their job.Some last but not least concerns remain for the GA version:1. The Help data in HelpManager 2.2 is still messed up with information from VS 2011 and SQL Server 2012. Typical regression problem, I suppose. Local Help is an enormeous productivity factor.2. There is no Startup option which automatically loads the last used solution and opens the files as they were open when closing SSMS. SSDT does it right away.3. The handling of DAC publiching between developer and DBAs is sparsly documented. But to handle the publishing process under full control of both parties is a key success factor for SSDT and SSMS. We need a more experience based design and documentation for the DAC process and its tooling. - Anonymous
June 07, 2016
Some folks over at dba.stackexchange.com are wondering if there's a way to connect the new SSMS to TFS: http://dba.stackexchange.com/q/140602/55371?stw=2Can you answer it for us? - Anonymous
June 09, 2016
How do I integrate this new SSMS with TFS? There used to be a source control section in the Options dialog but it's gone with this new SSMS. So how do we version control our scripts? Also, why did you remove a useful feature like that with no obvious replacement? - Anonymous
June 12, 2016
I’ll right away grab your rss feed as I can’t find your email subscription hyperlink or e-newsletter service.Do you’ve any? Kindly allow me realize so that I may just subscribe. Thanks. - Anonymous
June 13, 2016
We've been using TFS/Visual Studio Online for our SCC with SSMS 2014. I just downloaded SSMS 2016 and can't find any options for integration. How does one use SSMS 2016 with SCC? - Anonymous
June 15, 2016
One of the enhancements above is "3.Improvements in the SSMS installer to allow you to track installation progress and process exit codes for unattended installations via scripts."I just run an unattended install of version 13.0.15000.23 and the exe exited while it was still installing the .NET Framework and before the rest. I would expect the EXE to only finish with a Result Code once the installation has fully completed.Can you comment on this.Thanks