Download the May Public Preview

release date: May 7, 2018
version: 0.29.3

The May Public Preview is focused on stabilization and bug fixes. This build contains the following highlights:

• Announcing Redgate SQL Search extension available in Extension Manager.
• Community Localization available for 10 languages: German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese and Traditional Chinese.
• Reduced telemetry collection, improved opt-out experience and in-product links to Privacy Statement.
• Extension Manager has improved Marketplace experience to easily discover community extensions.
• SQL Agent extension Jobs and Job History view improvement.
• Updates for whoisactive and Server Reports extensions.
• Improve Manage Dashboard Properties scrolling.
• Fix GitHub Issues:
  • Fix issue 703: Entering HTML-like text in edit data causes value to display incorrectly until refresh
  • Fix issue 821: sqlopsstudio.deb package dependency
  • Fix issue 1260: Keyword 'distinct' not highlighted
  • Fix issue 1332: Edit data revert row doesn't work
  • Fix issue 1215: SQL Agent extension and the status bar
  • Fix issue 1316: SQL Agent Don´t resize after change windows size

For more information, see the Change Log, and Releases.

release date: April 25, 2018
version: 0.28.6

The April Public Preview contains bug fixes and improvements.

• Improvements to the SQL Agent Preview extension.
• Improved large and protected file support for saving Admin protected and >256M files within SQL Operations Studio.
• Integrated Terminal splitting to work with multiple open terminals at once.
• Reduced installation on-disk file count foot print for faster installs and startup times.
• Continue to fix GitHub issues:
  • Fix issue 37: When the chart viewer throws an error, unexpected behavior occurs.
  • Fix issue 462: Feature Request: Option for Server Groups to be expanded by default.
  • Fix issue 606: intellisense - Bad suggestion for 'update' command.
  • Fix issue 967: Expect query plan when select XML showplan in the result grid.
  • Fix issue 1023: Add square brackets for ms_foreachdb call from flyfishingdba.
  • Fix issue 1048: Pre-login SSL/TLS handshake error.
  • Fix issue 1050: Clear insights view before showing error.
  • Fix issue 1057: Restore and new query actions in explorer-widget are broken.
  • Fix issue 1068: Dashboard Output windows pops-up with error message for Azure SQL Database.
  • Fix issue 1069: Connection Dialog shows Server Required error when initially displayed.
  • Fix issue 1070: Server Groups now require a double-click to expand.
  • Fix issue 1072: Select control background is semi-transparent.
  • Fix issue 1115: Fix all high contrast accessibility issues in SQL Operations Studio.
  • Fix issue 1101: Extension fails to upgrade "Download Manually" link goes to wrong location.
  • Fix issue 1103: V Scroll not working on Home Tab.
  • Fix issue 1104: SQL extension tabs stopped working.

A significant highlight for the April Public Preview is the Visual Studio Code 1.21 platform source code refresh. This brings in several updates to the core editor and workbench from the previous 1.19 sync point. Some examples include the following:

• New Notifications UI - Easily manage and review SQL Operations Studio notifications.
• Integrated Terminal splitting - Work with multiple open terminals at once.
• Save large and protected files - Save Admin protected and >256M files within SQL Operations Studio.
• Improved large file support - Text buffer optimizations for large files.
• Improved Settings search - Easily find the right setting with natural language search.
• Global snippets - Create snippets you can use across all file types.
• Explorer multi-selection - Perform actions on multiple files at once.
• Errors & warnings in Explorer - Quickly navigate to errors in your code base.
• Drag & drop, copy & paste across windows - Move files across open SQL Operations Studio windows.
• Git submodule support - Perform Git operations on nested Git repositories.
• Terminal screen reader support - Integrated Terminal now has "Screen Reader Optimized" mode.
• Centered editor layout - Maximize your code viewing screen real estate.
• Horizontal search results (preview) - You can now view search results in a horizontal panel.

For additional details, checkout the Visual Studio Code February Release Notes, and the Visual Studio Code January Release Notes.

For more information, see the Change Log.

release date: March 28, 2018
version: 0.27.3

The March Public Preview continues to address the top GitHub issues and is focused on improving our extensibility story. Specifically enabling Extension Manager, improving dashboard management, and providing SQL Agent and insights extensions. This release includes the following enhancements:

• Enhance the dashboard extensibility model to support tabbed insights and configuration panes.
  • Extension Manager enables simple acquisition of extensions.
  • Dashboard extensions for sp_whoisactive from whoisactive.com.
  • For details, see Extend the functionality of SQL Operations Studio.
• Add additional extensibility APIs for connection and object explorer management.
• Continue to fix important customer impacting GitHub issues.

release date: February 15, 2018
version: 0.26.7

The February Public Preview includes some feature suggestions and high-priority bug fixes. This release includes the following enhancements:

• Introducing Auto-Update Installation, which provides a notification when a new release is available to download
• The Connection Dialog 'Database' field is now a dynamically populated drop-down list that will contain a list of databases populated from the specified server.
• Fix issue 6: Keep connection and selected database when opening new query tabs.
• Fix issue 22: 'Server Name' and 'Database Name' - Can these be drop downs instead of text boxes?
• Fix issue 549: Silent/Very Silent Install results in application opening after installation.
• Fix issue 481: Add "Check for updates" option.
• SQL Editor colorization and auto-completion fixes:
  • Fix issue 584: Keyword "FULL" not highlighted by IntelliSense.
  • Fix issue 345: Colorize SQL functions within the editor.
  • Fix issue 300: [#tempData] latest "]" will display green color.
  • Fix issue 225: Keyword color mismatch.
  • Fix issue 60: Invalid sql syntax color highlighting when using temporary table in from clause.
• Introduce Connection extensibility API.
• VS Code Editor 1.19 integration.
• Update JustinPealing/html-query-plan component to pick-up several Query Plan viewer improvements.

release date: January 17, 2018
version: 0.25.4

The January Public Preview includes some feature suggestions and high-priority bug fixes. This release includes the following enhancements:

• Saved Server connections are available in the Connection Dialog.
• Enable Hot exit. Hot exit is off by default, to enable see Hot exit setting.
• Tab-coloring based on Server Group. Tab coloring is off by default, to enable see Tab color setting.
• Change Server name to Server in the Connection Dialog.
• Fix broken Run Current Query command.
• Fix drag-and-drop breaking scripting bug.
• Fix incorrect pinned Start Menu icon.
• Fix missing Azure Account branding icon.

release date: December 19, 2017
version: 0.24.1

The December Public Preview includes several bugs fixes across all feature areas, as well as the following enhancements:

• Create Firewall Rule Dialog is now available to assist connecting to Azure SQL Database and Azure SQL Data Warehouse.
• Added Windows Setup, and Linux DEB and RPM installation packages.
• Manage Dashboard visual layout editor.
• Script As Alter and Script As Execute commands.
• Run Current Query with Actual Plan command.
• Integrate VS Code 1.18.1 editor platform.
• Enable Sideloading of VSIX Extension files.
• Support "GO N" batch iteration syntax.

release date: November 15, 2017
version: 0.23.6

• Initial release of [!INCLUDEname-sos].

See one of the following quickstarts to get started:

• Connect & Query SQL Server
• Connect & Query Azure SQL Database
• Connect & Query Azure Data Warehouse

Contribute to [!INCLUDEname-sos]:

• https://github.com/Microsoft/sqlopsstudio