May Preview Insiders Build 0.29.1

May Preview Insiders Build 0.29.1

Please checkout the latest 0.29 insiders build at https://github.com/Microsoft/sqlopsstudio/releases for current release notes.

Note: insiders builds are produced directly off master. They provide access to the latest bug fixes and improvements. They may also have more bugs in some areas. For the latest stable build checkout the April Public Preview release.

April Public Preview (0.28.6)

April Public Preview 0.28.6

The April Public Preview 0.28.6 release contains several additional bug fixes and improvements. Checkout the release notes for the 0.28.1 build to see all the core editor and workbench improvements delivered through the Visual Studio Code 1.21 platform source code refresh.

Highlights for this build include the following.

• Improvements to SQL Agent Preview extension
• Accessibility improvements for keyboard navigation, screen reader support and high-contrast mode.
• Improved large and protected file support for saving Admin protected and >256M files within SQL Ops 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
• Improvements to Server Reports extension
• Continue to fix GitHub issues
  • #37 When the chart viewer throws an error, unexpected behavior occurs.
  • #462 Feature Request: Option for Server Groups to be expanded by default
  • #1023 Add square brackets for ms_foreachdb call from flyfishingdba
  • #1050 Clear insights view before showing error
  • #1057 Restore and new query actions in explorer-widget are broken
  • #1068 Dashboard Output windows pops-up with error message for Azure DB
  • #1069 Connection Dialog shows Server Required error when initially displayed
  • #1070 Server Groups now require a double-click to expand
  • #1072 Select control background is semi-transparent
  • #1115 Fix all high contrast accessibility issues in sqlops
  • #1101 Extension fails to upgrade "Download Manually" link goes to wrong location
  • #1103 V Scroll not working on Home Tab
  • #1104 SQL extension tabs stopped working
  • #967: Expect query plan when select XML showplan in the result grid
  • #606 intellisense - Bad suggestion for 'update' command
  • #1048 Pre-login SSL/TLS handshake error
  • #1150 Various types of query charts throw exceptions and don't render

SQL Agent for SQL Operations Studio Preview extension

Since SQL Operations Studio was released for Public Preview, one of the most requested features was providing SQL Agent support. Bringing over the most popular SSMS features has always been on our roadmap, but we wanted to make sure we did this the right way. With SQL Operations Studio, we had an opportunity to bring a modern user experience to our features while maintaining the same functionality that our users are experts with.

Please try out our early SQL Agent Preview extension. In this initial release we've focused on Jobs List and Job History scenarios. Configuration scenarios to create Jobs, Operators, Alerts and Schedules will be coming in future releases.

Contributions and "thank you

We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:

• flyfishingdba for Add square brackets for ms_foreachdb call (#1023)

Changelog

-- Updates for 0.28.6
4b88b67bed45eac857bc42b7861202cdc035711e update Server Reports README (#1250)
a2734807ca818cc364cb71c2ba0260a8123c9b61 Agent bugs and fixes (#1243)
d0d4df313e787abfb143501939119268f94f3337 Initial improvement in sp_whoisactive (#1249)
1efd5e6502fd7a371f9238c0f555bb29d2a6464f change keyboard shortcut for focusOnCurrentQuery (#1241)
b12cac0ac30f0f968d746d5576f87ee343cdad47 Changed DB Space Usage and DB Buffer Usage to show only top 10 data and update README (#1248)
-- Updates for 0.28.5
3b90530717fa16ae289f6b4255b8f65cb089a893 Feature/agent finishes (#1237)
f199c7a63ca14e5be15b2ffeac25ae4a05014c28 Fix instance of "Code" in git fetch user prompt (#1234)
50a2526d1fd235cdbf56297487473dcf75335887 Only show SQL Agent for on-prem instances (#1233)
7fb8a28b5953d124de97852bc299950d09ad9c85 properties isn't scrolling (#1225)
30a825438e012b44479d7d2b1fe94864c41d7d5e Fix issue where chart type select is missing for tables (#1232)
f63da13210b9e218a014eaa93399168669bdc894 Handle errors when chart is invalid for given data (#1226)
08d73675d40c695dac1eb89475b3cc492b18f20b Fix bar chart displaying extra series (#1230)
f0f6c00a0eabbc05a728a175482501bdd9b29982 Updated extension gallery link to Azure blob storage (#1220)
965458ca74b66eb266eacd5db94227028a4c0260 Add Query Editor API to sqlops.proposed (#1196)
b30f7ee41c03b8f25efc8ca54084841430776cd2 Add Redgate Search to recommended extensions list (#1212)
a2eb53ce0b1d0db9d824c3fc9fcf58b0d5f2fda0 add theming for selectbox in edit data (#1210)
619c816e7f92d8d119c1c2d0945cd19e6b2f5bfe (tag: 0.28.4) Fix flex container and card layout issues (#1195)
3d6fb7a8fa8e941306109f69bc094e307b9ff8c2 Update SQL Tools Service to 1.4.0-alpha.23 (#1202)
-- Updates for 0.28.4
891624c085594d9bfa9ddca151b5e2e4e7622316 Fix #1198 Extension gallery doesn't show dashboard contributions in Contributions tab (#1200)
a7c4686980a54eecaff165ed4fa361dd64f7e3b9 Feature/input box component (#1190)
93aa052856e5397766d287f8ec32a3eefcdc980d Initial work for custom model view dialogs (#1183)
61d05f67826da4329dcb1df7b0d2d0c227e8e8bb adds coloring for unfocused tables (#1182)
60ccae48f1214a8b8ff019743a08bfaade200ac0 add auto refresh interval to insights (#1173)
4b454581fd355239f0148c0652ede35f0c332037 fix task icon in dashboard (#1174)
f0aadebd2c907f876a1ff10161663c633fb636d5 fix chart viewer accessibility (#1164)
d3f0ac7954d269f931691d95ece5eaa687646d8c refactor model components to not reference any dashboard services (#1168)
134f76c17f9893edda92be9a45cabb93134f6d39 Feature/agent finishes (#1149)
b9c877a1097b4abc294795893c2d3bd841507130 Add a "Telemetry Opt-Out" menu item (#1172)
aa243a8aae7c8a436a05a8dffe6ec0aad3aec70c ensure npm install copies typings (#1170)
e5c1c6f5449d780faf0e775738dadc330ca60f9b fix regression in insight widget where the data is set twice (#1163)
9e9f85079e88aa86cdc380fa26e3476fbd85eeec fix up backup dialog for accessibility (#1155)
ae8e2e1f8973876babe05aa6c60a85391ffa5b58 Add showTopNData option to insight charts (#1157)
b2c70e9301266e6021945a80b479e6fa9ea5f072 Feat/model backed ui (#1145)
e022f4a0d173c2d303f9f993c51f4ee76f6702bc add title to back button (#1154)
8bc32e6371dcdc2a8d7dd7e6fae0c03a390d7ffd add accessibility for panel (#1138)
f739c47984f0949afe64212d5f58cdb0cd198a9d Adds aria labels to all input ui (#1136)
13fb9fdfd24254281841db71f8cb3b2fd125304e Add keyboard shortcuts for focus on current query and go to next output query tab (#1153)
9a5f51bfbfb7d5b991e23964d6b7aeb35ed3d1a1 Focus on the first focus-able when toggle result and message (#1147)
06bab6a38c6a5362eb7450bc93817e745ddefe99 Add Privacy Statement and License menu items  (#1148)
c35a14d8fdc14fb29765f9f101cbeea203d9d3f7 Fix incorrect source header from previous commit (#1146)
b9140731476c58441a2c2b78312f3b6974ead70b Add missing double-quotes to insights schema description (#1139)
04ae18143b14e56cbca46acf8f3da27f3926cdbf fix backup URI (#1137)
efe8e81b6ecf4dc42b0d51cf5b8a04e8a2f44d4a Connection inputs labels (#1129)
c33ddfabf9bfc4fcc2afdbdc2ea11efb66a1020d add necessary attributes for accessibility on the results grid panes (#1126)
8ec5451e6423ab836676f3dde473c78fee79852c Feature/agent2 adbist (#1113)
091d4cb924e03ac7bb875eba48e9358f5f680203 enable keyboard for explain button and Line1 link in message pane (#1132)
cd0210c88a9ae4802919d452de328d17d74cbd7e Port VS Code telemetry opt-in dialog (#1130)
ed10f984b650ebe027eba2710240704e9e747baa refactored collapsing widget, fixed refreshing a collapsed widget (#1107)
-- Updates for 0.28.3
495b4ee7c298430b4118a10db1c8a2d9bc317d88 fix all high constrast issues in sqlops (#1115)
7833c28b7a01867b26cdb98b92590917e1466ea3 fixed the bug with using vs code url to download manually (#1108)
bbfb68b082b9b10debc5a89c958c126ec66834f6 fix the keyboard issue where table is empty (#1110)
a327889d05dcc0645abbb6542ec1ab0a31b156d8 Fix Dashboard Errors (#1106)
5ac89e5a498f488ec9f0d08405dfef384935e89d Open query plan link when select XML showplan in the result grid (#1092)
849653927a095949bcea6a565c3be58e0c00828a Fix #1095 "Run kinit" helper no longer runs kinit (#1102)
-- Updates for 0.28.2 build
3545483fc1087b8f3756f3b2e5b399353c625bd2 Update action collapsed state with emitter (#1099)
e5a1896414d958752fb42a7d7aabeb49014d03d7 Clear connection validation messages on open (#1097)
bec8e7268815bb9f7b7d3bf54cb00445d4f3ebd9 fix problems with low result count breaking insights (#1052)
86748e6d69c2afafe0b65e8f1542242e64bd0bae clear insights view before showing error (#1050)
596f09f7544ed1769f8c721e47ebd4378f208ecd add custom action for explorer actions (#1059)
563e25f07373f10b16ca19d0a02eecebb4ff2fdc add custom output channel (#1087)
21826583019142a7b12fb0df0abea5bb12b55429 Fix OE single click and expand groups by default (#1096)
3990719054d1362d914e9c5274d5bb97e607bc10 Rename registeredServers to objectExplorer (#1093)
071b510fba986969b73d14da0c1edbb8fd2dce6b add dropdown background color for sqlops light and dark themes (#1088)
d2d2ade9f7c29349ffbbca778903356b3f1e999b register feature for language client for agent (#1086)
d97d2e5c91a9b3fbe882e0119a0bf07ee72f66ad Reenable logging for SQL Tools Service (#1089)
a6ba44e435ef5ebe5ef720748d76bb129e774662 Fix accessibility issue for clear history button in connection dialog (#1084)
782623cba9a641d58c14d77926463fb95355632b fix keyboard issues in task and explorer widgets (#1064)
36045c5381c2e361566f0dfab0c23e737a41ce97 added caching for jobs view and history page (#1056)
-- Updates for 0.28.1 build
7e49167530f59d2ba8b68bae386124d757f906a0 Bump SQL Tools version to 1.4.0-alpha.18 (#1075)
dafb7809875f49856b9b38e823a2f7dbd72733dd Merge VS Code 1.21 source code (#1067)
5fba3e31b4265f0a7eb8ed20b929b62e9412273f fixed css ...

April Preview Insiders Build 0.28.5

April Preview Insiders Build 0.28.5

Please checkout the latest 0.28 build at https://github.com/Microsoft/sqlopsstudio/releases for current release notes.

April Preview Insiders Build 0.28.4

April Preview Insiders Build 0.28.4

Please checkout the latest 0.28 insiders build at https://github.com/Microsoft/sqlopsstudio/releases for current release notes.

April Preview Insiders Build 0.28.3

April Preview Insiders Build 0.28.3

Please checkout the latest 0.28 insiders build at https://github.com/Microsoft/sqlopsstudio/releases for current release notes.

April Preview Insiders Build 0.28.2

April Preview Insiders Build 0.28.2

Please checkout the latest 0.28 insiders build at https://github.com/Microsoft/sqlopsstudio/releases for current release notes.

April Preview Insiders Build 0.28.1

April Preview Insiders Build 0.28.1
The April Preview Insiders Build 0.28.1 is this month's initial test build. Note that the Insiders builds are based directly off master with little stabilization. We publish these for users that would like access to the very latest updates. If you prefer a more stable build check out the March Public Preview.

The most significant highlight for this build 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 Ops 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 Ops 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 Ops 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.
• PREVIEW: Horizontal search results - You can now view search results in a horizontal panel.

For further details checkout the VS Code February Release Notes and the VS Code January Release Notes

Contributions and "thank you"
We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:

• flyfishingdba for Add square brackets for ms_foreachdb call (#1023)

March Public Preview (0.27.3)

March Public Preview (0.27.3)
The March Public Preview release is focused on improving our Extensibility story and continuing to address top GitHub issues. Specifically enabling Extension Manager, improving the Manage Dashboard and providing a couple Insights extensions. Please see the following details.

• Enhance the Manage Dashboard extensibility model to support tabbed Insights and Configuration panes
• Dashboard Insights extensions for sp_whoisactive from whoisactive.com
• Extension Manager enables simple acquisition of 1st-party and 3rd-party extensions
• Add additional Extensibility APIs for connection and objectexplorer management
• Community Localization open for 10 languages
• Continue to fix important customer impacting GitHub issues
  • #572 Jump to object in Object Explorer
  • #850 Can we create a table as an insight widget?
  • #730 Script as Delete should be Script as Drop
  • #760 Save Query dialog shows *.sql twice
  • #90 Make database selection dropdown list wider
  • #132 Copy empty string from results pastes "null"
  • #885 too much whitespace in tree
  • #614 Saving dialog - Remember last selected folder
  • #704 Insight Last Updated time doesn't update on refresh
  • #764 Add shortcut for toggle results pane

Community Localization Open
Recently we announced SQL Operations Studio availability on the new Microsoft Community Localization platform. Localization is now opened for 10 languages: French, Italian, German, Spanish, Simplified Chinese, Traditional Chinese, Japanese, Korean, Russian, and Portuguese (Brazil). You can contribute to localization for both software and docs. https://aka.ms/SQLOpsStudioLoc.

Extension Manager enables simple acquisition of 1st-party and 3rd-party extensions
The Extension Manager makes it easy to discover and acquire additional SQL Operations Studio functionality. We've adopted the in-product extension management experience from Visual Studio Code. For users unfamiliar with this UI it consists of the following components.

• 'Marketplace' of Recommend Extensions which can be easily discovered and installed
• List of Installed Extensions which can be disabled or uninstalled
• Extension Details page that displays the extensions readme content and other metadata

Extensibility is a key tenet of the SQL Operations Studio project roadmap. We plan to make available both 1st and 3rd features as extensions. We look forward to working with the community to build a rich tools ecosystem. Please contact us on Gitter if you're interested in building an extension.

Note: If you don't see the Extension Manager icon you may need to enable it using the Activity Bar context menu Extensions command.

Dashboard Insights extensions for sp_whoisactive from whoisactive.com

The March release introduces improved Manage Dashboard extensibility. Extensions can now provide
tab panels to the dashboard to group related functionality. Check out the sp_whoisactive extension
as a great example of using the dashboard insights extensibility points.

Here are some notes from the extension readme. Sp_whoisactive is a procedure written by Microsoft MVP Adam Machanic. It is a very useful tool for activity monitoring and troubleshooting.

• Who is Active is a DMV-based monitoring stored procedure that uses 15 different views to show a large amount of data about what’s running on your server
• Who is Active was designed to be extremely flexible, and includes options to not only get different types of data, but also to change the output column list and sort order

Checkout the source code for the whoisactive extension and other extensibility samples at https://github.com/Microsoft/sqlopsstudio/tree/master/samples.

Changelog

-- Changes for 0.27.3 build
5127811dc1c7f71b246a8be50f9c1cee9ecadeab Tabs should fill entire panel (#995)
f2db47893fdc16718e14ed788b90d448454132bd Go back to using VS Code's tab close icons (#997)
-- Changes for 0.27.2 build
2f8f6064a147958fd3c1c713ed89b41053450db4 Fix Script as Drop label (#988)
ab91c88b342543fe213218a07419eacdb0bd9530 Revert "Results grid options (#962)" (#979)
-- Changes for 0.27.1 build
f91010c398913a292fb5e76fd9080e0624b1dcd8 add table insight (#976)
cd0d0f911bd0cdc9462208728a3622479a0ddc2b Feature/extension recommendations (#977)
a226e90c3829a91716786a34bddcd32ff4d109a2 return copy of array rather than reference (#971)
357bb1916e7c1e24a99fb457504662efca68c5fc Initial SQL Agent merge for March release (#961)
7099b116515ab8a6703da8934f1088f213aecd78 Add sample for server reports (#960)
27e9e8ec2b0b861667f9f090717b2e57a952048b Changed Ops to Operations (#959)
cb1d630cfbba5765f4e9ce4489f78f1e49fae6f6 Connection dialog tabbed panel should use block display (#964)
cb7b8b956f08b857e505759d53c43aa0e49b3abb Fix for duplicate extensions shown in "Save File" dialog. (#779)
a0608a51c159960d1f215239d1eb09d61bbeef1a Bring in recent tools service changes (#957)
217f5e7ee52592877c143dd39f8a4bd0b86eb92c fit and finish for dashboard (#951)
50c4fd79b713abb3c47c562ef49bfadc13061f5a Add the first version of whoisactive project (#943)
f76e8ae2c54e35be8bf78541d2d005b182403d6e fit and finish for open dashboard dialog (#954)
089577c5a8ab8d6ecf4cbef10a899eabf79e826f fix action execution in insight dialog (#942)
c116f933e24cbda663387cae3d29a95cbeabeee7 Resize grids and detect changes when toggling panel visibility (#944)
-- Changes for 0.27.0 build
fe496ab03b08712ea9d12a2022bec330f7e834fb fix the UI for nav bar (#937)
3c3d8417e9f94c4230d41c620252f55627d5f04b vbump slickgrid (#934)
2b2672e4bd34d2ebe3be88d6116eeb27c537084e Enable object explorer find nodes API (#936)
1bfc8c1914be89fa40d77959fe238d47a55e374f Ellipse on editable dropdown for long values (#908)
2f854cce4a8f12ddeee46c3fdd1e12db1bc559be correctly detect undefined for input strings during copy (#906)
40550d0840e21025a313220105dc3a13ca2de8f4 rename context key databasename to databaseName (#903)
38bedea0bddadd29fc94a8aaeece9e5c92e0afe3 Add findNodes Object Explorer API (#916)
75ab5c1a36690ea7fd0164bf63c39ac1f1beadb2 add samples (#920)
3d7c081068de793c9c6163213a06bfeb2acdf1ed Fix formatting in Localization section of readme
c276bd8a37cee640b4a635ce17eed5a4f1f79989 Add localization 'Help Wanted' section to readme (#915)
890bece70c9f9369f77950f846f81cf3fd20ea98 changing the extension gallery url for insider builds (#902)
4a4fe584d507cae6b6305e12910926d5274cb9b0 Fix tab contrib to be accurate (#901)
bcd72d21c7236f502a434c0b93ac0275d096363b Tasks schema registration (#900)
722f5e56cd3efa024ec45f7e85f9a43f7f444dc5 Add dashboard context (database vs server) to scoped context (#893)
f3c7b2416b25d9f0c9348cdd29123979f4261dcc Support icons in panel  (#895)
383d74ceb42040cafbbba8842a15d7b6a259d62a Dashboard Minor code cleanup (#894)
64f61b2954924f01f75c9a5d3757cba324dae12d Fix several dashboard issues and add telemetry (#889)
5c0002404adb9bcf67559633ea1af6378c62cee1 Task context + schema (#849)
66f39fd3eb68fe804f2f1711e742f8106c86fa38 supporting sql built-in extensions (#890)
e79e3bdf1d4685d31f68879ea8bb5abcee6f85aa Adjust ObjectExplorer spacing to 25px (#886)
9dd3ec91797049aa7a07d6d33c844e362b081b94 add window resize listener to webview for resize (#866)
c06ab27d085bff69cb305467da1735fbdbb93190 Object Explorer API (#783)
fab4185c1f3915d40039a4e5e9e81693468d5cbb Change visibility type for panel hiding (#864)
bc4b399f87c11f5235e7881845cd3e7a4fcd8599 Fix "always show" for dashboard tab to behave like pinned by default (#879)
52544fa9535321a6d312ac7064fbba7dcef00a91 changed the format of rowspan and colspan to be string or number (#859)
8b2ea4f0a05f91a94976fa21a05ed4160808d218 Capabilities Cache (#831)
45b1ae1fb17f477d220c30fc906fa4c60340d9f9 Improve experience in "open installed features" dialog (#876)
090ac6eab23e2f9e9df49b663a2b388101ebfbc9 Persist save file location throughout a session (#772)
b7169f3da974eaed915843a39e50050554bac577 Add Gitter badge (#868)
587c3ab43621945de2bb019af8be8caf8cf5939d Handle error when loading the dashboard (#862)
80bbd9dbf3b4008d0e8168dc00265ef1edca8f41 update insight last update time on refresh (#841)
c019175fffd47b142a2cf8b62bcf2d79d8c77400 fix the lock files (#861)
7f79ab47ace08d9a8a0cc8074886b079b343051e Error handling for dashboard tab contributions  (#851)
ba188189a82d398a4a437d759a7edf0bc95bb9e9 Credentials and Serilization shouldn't register for all features (#833)
8e6359b3a439b48b0397bf6d1b8e3cb135244c95 fix nav section layout (#854)
aac77ed9826f58e507d96aa70ca3de32f4a1c97b Update README to add section for design note links (#856)
1d284ea66ac76eeb3590ea4ec8b520bdb6cd5a13 fixed the grid layout schema and fixed layout bugs (#847)
9f5268101d569cc802e2557e17925d9b378ae472 integrate with contextkeyservice (#804)
0bba972657089f8ff9dd4b4ec33bb5bc89d9326d Fix few dashboard panel issues (#801)
bab9fc01ea127c17403f14b34d9e0d8a30d94626 focus on the first tab in the nav section by default (#823)
692ed02df862050cb1d7f5cab7f943dd00bbd960 Collapsible properties (#771)
2e67d03b567f930525dd2c3d8b0cf24b359dfd6c fixed the grid layout sizing issue (#824)
56ca3406c4f4f748b90cdc4136071613edb35d4e Fix pin, unpin and close icon issues (#822)
94e8ce5185116d2b324c178d67881488dea0dd30 Update version field in sql syntax file. (#828)
bb54b0280a062305f0773e111d5ab14448ef026d Do not apply hc arrow when loading items in OE (#827)
a99c34d817347cd9dc15ef7178a46ed85eeea84b fix install location for service (#811)
c06f45cf0e2f659781066f1...

March Preview Insiders Build 0.27.2

March Preview Insiders Build 0.27.2

Note: The March Public Preview (0.27.3) download files are duplicated into this release so that the files are available under the 0.27.3 tag.

The March Preview Insiders release is focused on improving our Extensibility story and continuing to address top GitHub issues. Specifically enabling Extension Manager, improving the Manage Dashboard and providing a couple Insights extensions. Please see the following details.

Please see build details in the March Public Preview release notes.

March Preview Insiders Build 0.27.0

March Preview Insiders Build 0.27.1

The March Preview Insiders release is focused on improving our Extensibility story and continuing to address top GitHub issues. Specifically enabling Extension Manager, improving the Manage Dashboard and providing SQL Agent and Insights extensions. Please see the following details.

Note: please see details in latest 0.27 build.