June Preview Insiders Build 0.30.1

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 May Public Preview release.

May Public Preview 0.29.3

The May release is focused on stabilization and bug fixes leading up to the Build conference. 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
• Fix GitHub Issues
  • #703 Entering HTML-like text in edit data causes value to display incorrectly until refresh
  • #821 sqlopsstudio.deb package dependency
  • #1260 keyword 'distinct' not highlighted
  • #1332 Edit data revert row doesn't work
  • #1215 SQL Agent extension and the status bar
  • #1316 SQL Agent Don´t resize after change windows size
  • Improve Manage Dashboard Properties scrolling

Announcing Redgate SQL Search extension

Redgate SQL Search in SQL Operations Studio extension is now available in the Extension Manager Marketplace! Redgate SQL Search lets you find database objects across all databases in the active connection. From the search results it's simple to jump to the object in the Object Explorer or to view the object's definition.

We definitely recommend installing this extension. As SQL Ops Studio evolves we'll rely heavily on extensions to provide core functionality, so we expect that most users will want to have several extensions installed for the best experience.

Community Localization available

Community Localization resources for German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese and Traditional Chinese are available for the May Public Preview. We'll continue working over the next couple months to get the product 100% localized.

We'd like to thank the translation community for helping to make SQL Operations Studio available to users in their preferred language! https://aka.ms/SQLOpsStudioLoc

The below screenshot shows an example using the Italian locale.

Reduced telemetry collection, improved opt-out experience and in-product links to Privacy Statement

There are several updates in May Public Preview that improve privacy protections. Specifically we reduced the telemetry being collected, improved the opt-out experience by adding a notification on first launch and added a Privacy Statement item to the Help menu.

Extension Manager enhancements

The Extension Manager Recommended section has been replaced with a Marketplace section. The Marketplace will display all available extensions. Recommended extensions are sorted to the top.

Checkout out some of our 1st-party and community contributed extensions. And take a look at our Extensibility Getting Started page to see how easy it is to add your own extension to the marketplace!

Startup Performance improvements

We want SQL Operations Studio to be fast and efficient to maximize user productivity. Reducing the time it takes to launch SQL Ops Studio is one of the key scenarios where we've been making continual investments. Fortunately our upstream platform, Visual Studio Code, is also optimizing this same scenario. One key improvement we merged from VS Code's February release was ASAR Node module bundling.

We use product telemetry from the Startup scenario to understand how long users are waiting for SQL Ops Studio to launch. This telemetry allowed us to confirm that the April Public Preview delivered approximately 30%-40% startup time improvements for most users. Particularly users experiencing the slowest startups have seen the largest improvements.

The below chart shows startup times bucketed into key percentiles: 25%, 50%, 75%, 90%, 95%, 98%, 99%. This means, for example, at the 50% bucket half the startups were faster than that time and half the startups were slower than that time.

We hope you've noticed that the April release startup feels a bit more snappy! And thank you for opting-in to telemetry to allow us to effectively measure and improve SQL Operations Studio!

Contributions and "thank you

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

• French: Adrien Clerbois, ANAS BELABBES, Antoine Griffard, Arian Papillon, Eric Macarez, Eric Van Thorre, Jérémy LANDON, Matthias GROSPERRIN, Maxime COQUEREL, Olivier Guinart, thierry DEMAN-BARCELÒ, Thomas Potier
• Italian: Aldo Donetti, Alessandro Alpi, Andrea Dottor, Bruni Luca, Gianluca Hotz, Luca Nardi, Luigi Bruno, Marco Dal Pino, Mirco Vanini, Pasquale Ceglie, Riccardo Cappello, Sergio Govoni, Stefano Demiliani
• German: Anna Henke-Gunvaldson, Ben Weissman, David Ullmer, J.M. ., Kai Modo, Konstantin Staschill, Kostja Klein, Lennart Trunk, Markus Ehrenmüller-Jensen, Mascha Kroenlein, Matthias Knoll, Mourad Louha, Thomas Hütter, Wolfgang Straßer
• Spanish: Alberto Poblacion, Andy Gonzalez, Carlos Mendible, Christian Araujo, Daniel D, Eickhel Mendoza, Ernesto Cardenas, Ivan Toledo Ivanovic, Fran Diaz, JESUS GIL, Jorge Serrano Pérez, José Saturnino Pimentel Juárez, Mauricio Hidalgo, Pablo Iglesias, Rikhardo Estrada Rdez, Thierry DEMAN, YOLANDA CUESTA ALTIERI
• Japanese: Fujio Kojima, Kazushi KAMEGAWA, Masayoshi Yamada, Masayuki Ozawa , Seiji Momoto, Takashi Kanai, Takayoshi Tanaka, Yoshihisa Ozaki, 庄垣内治
• Chinese (simplified): DAN YE, Joel Yang, Lynne Dong, Ryan（Yu） Zhang, Sheng Jiang, Wei Zhang, Zhiliang Xu
• Chinese (Traditional): Bruce Chen, Chiayi Yen, Kevin Yang, Winnie Lin, 保哥 Will, 謝政廷
• Korean: Do-Kyun Kim, Evelyn Kim, Helen Jung, Hong Jmee, jeongwoo choi, Jun Hyoung Lee, Jungsun Kim정선, Justin Yoo, Kavrith mucha, Kiwoong Youm, MinGyu Ju, MVP_JUNO BEA, Sejun Kim, SOONMAN KWON, sung man ko, Yeongrak Choi, younggun kim, Youngjae Kim, 소영 이
• Russian: Andrey Veselov, Anton Fontanov, Anton Savin, Elena Ostrovskaia, Igor Babichev, Maxim Zelensky, Rodion Fedechkin, Tasha T, Vladimir Zyryanov
• Portuguese Brazil: Daniel de Sousa, Diogo Duarte, Douglas Correa, Douglas Eccker, José Emanuel Mendes, Marcelo Fernandes, Marcondes Alexandre, Roberto Fonseca, Rodrigo Crespi

Changelog

--- Updates for 0.29.3
b54b4a44459b6c97afc0ef78a95a7f4c778280fe Fix a null ref exception in dashboard layout (#1348)
03989a5af071d110b4d1e406a70089f679796229 Fix scrolling in Jobs view page (#1346)
1847c2e3228d80b99fdf92f28e4e95b36982028f added checkbox component (#1330)
f7371e9ed5b9896ea792bc8bfa13ab3824a99db9 Update SQL Agent extension readme and version (#1343)
f696274740a9044f50e82c4942e52758cb13f3c2 Add details for each chart and update README (#1341)
-- Updates for 0.29.2
96ecf79d32198862cfee70f84f2ea9395af6d85f resize when window resized (#1335)
6d243e0ac875242f87ae6092b12b27e5d3779da3 reverting row which escape is clicked and fixed the issue with reverting rows (#1333)
8bf60f133fff28688b9b4645be3294babe0518eb Fix widget title in home tab (#1325)
3b9a3aba87385d28de2eb34a42c53b08fce92148 Close insights dialog properly when escape is pressed (#1319)
7ee13b4afb6076214ef3f8ab61ec61ba6a1a2856 Integrate resources from Community Localization platform (#1313)
31ac8d6acc791622a98fe2771492e449f8923047 Trim server name (#1308)
e82b7615b308ad0af949de77e1adaa2b88516eb5 Add more options to chart viewer (#1307)
6f10f7a21a123015089d037e1e29c2605962d896 Agent Improvements/Fixes (#1284)
46fb68214f54ae4f3c4b4a9bfe67577e2794b7bb added taskbar instead of custom action bar (#1288)
c2381424bc873c1922db2cce0422e12af1ffa8d8 Combine messages to reduce rendering time when possible (#1309)
31328e79becfc67f771dfbb761f56cc4db1217d9 clear the widget error every time it refreshes (#1306)
96657e300a15ab697b94f33821fab73d69fdbb0d Open inactive editors as sql editors when needed (#1298)
a2e6aa9e648a05b6d7c64cf607530c908bc63ff0 fixed extension filter and search (#1301)
-- Updates for 0.29.1
29e5712052a51669f3b48d2c05d77c8ae77d5ec2 Update SQL Tools to 1.4.0-alpha.25
cd140b5527fe7721ff5a5a9a5c303225e75bee77 Encode HTML when entered in edit data cells (#1302)
a0456bf4f7d7bc2a2cf261d33a2f5bb261171935 Remove all ID fields from telemetry (#1299)
55e3947cf7623b215d9e30a2b7ef8f9cf15ff55c Pick up Electron 1.7.12 (#1291)
db5156e4cd68dd8de11534f16f4bb247cbf45c90 Fix app name in Report Issue dialog (#1292)
eece0677a783525276b1ee653c9e982d0303383e added libunwind8 to Debian dependencies (#1290)
24e8c20511880e00a67b27449f5f8a93bb7bd8dd Simplify button logic and enable button updates for custom dialogs (#1283)
886717d330382ec77e75aade9ad43195ec38bd16 added dropdown and form layout to model view (#1269)
26b27a616a80ec011eccd79e23b32e8e8f4d46c0 Refreshing package-lock for samples since it's stale (#1287)
0c663e5555ae45755834069323fd08bb6c08abf8 Add AppInsights context flag to envelope  (#1282)
0f087915f683201557bdc719e15514e16ff5cde5 Agent/loading icon (#1263)
a78fa9c0f2443f0dd418249a1aefad40a7e7b996 Scroll properties (#1244)
b1752ea6358f9c7695ab09662ed83e7763f1a2cb Show all available extensions in Extension Manager  (#1273)
ec150917c22be921dd8e7338e2bf2b724a75b857 Fix button handle bug and add tests (#1267)
7a9a69c4399cf40ea4a5e51200aaf0973ecc4139 Add TRUNCATE to the keyword colorization list (#1270)
9e9862c6f04a37e5d6e5673328b9d4a12b9a2de1 Agent action icons fix (#1255)
7b76d929cdf1dd1db2042e9a9b010df62ebaeee8 Update README and CHANGELOG for April release (#1257)
1811dfa4237683e08a019f603f16cbcc72a58cc0 Expose custom dialog extension APIs (#1206)

May Preview Insiders Build 0.29.2

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.

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

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 issues (#1066)
0315020cf00dd5ed40dc16009f613648b12249c2 change enum type to conform to new connection (#1053)
6dca89676834040eb8368355c513d9abf2979a79 When we click in recent connections the connection profile doesn't get updated (#1060)
90454fbe87815e088b01ffa0b632c7cfaa333c74 Fixing the provider name (#1051)
f9b2136494ac1e411389ad686c33e64a49677601 Fix the scrollbar issue in widget container (#1016)
e6a65599fd237195b90579e96aafd73d14cbc233 fix client options in mssql (#1044)
32ac907403d755dbeed9eeffcf30a807983531df crypto is part of node now (#1033)
3af05d62b2a927dce93765563083e24e615221c2 Add square brackets for ms_foreachdb call (#1023)
b5d8dfa5095ec854f934abb3f7c13990ff217e86 Agent WIP (#1031)
612987d1e594150b9e94dfaec67eceb274df5e5f fix the close icons in sqlops (#1032)
916598e02902f24218849b296a2402b94ff3b1be Agent work (WIP) (#1012)
c45c6349383e855aec6e66c9cb64d05727ff7a40 change layout to refresh (#1025)
1bed0d073338868a6febdecb0581c2b46b53c48e rename sqlops extension (#1002)
e0075b7633bf78ab3742ac1cf0ba1dfe40c31e89 fix error in task widget (#1017)
0029767561f06cd68e632d2d51eea263fff9ea12 add dev depencies to keep yanr from erroring during build (#1015)
93f9828d04bf6439bdf974b88ce696d4209058bb Focus connection dialog on password when prompting for it (#1019)
b2a96bbe501e8b442a71a41deed8b76523972642 Fix/use sqlops engine version (#1011)
2414f437575dbef36961943836b96d4e2fc7806d Refactor out extensions-modules and rewrite mssql extension (#909)
22c54a99171a77169a9b1a69a53d38b03001abd3 connection contribution point (#880)
31f75a46c82fe7b905a1ae838e711a1d6778540c add proper typings to sqlops (#1010)
ddfb61b46a90eff380ecaf71229ad628b5f57374 change settings to only affect grid; remove default fontfamily (#989)
9a2e8cffedd45e4eb5f06c7dfbbc3226087c8d49 Use nvarchar(128) for database name in db space script (#999)
08d97cc7950f031489821629a8d19f1c3cdc443f Bump SQL Ops to 0.28 for April release train (#993)

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

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

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

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
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)
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)
c06f45cf0e2f659781066f1b27b1f3841cf59035 Fix duplicate localization ids (#803)
8114498fb5291b4640b68de3f4e100a4010d4aeb writing telemetry into a file when running the app for perf tests (#802)
889b60a71bb877087da90dd959a44bd4662db25d support grid container in nav section (#796)
45023b2e7134f1b8693e6f9f5dda60ede4ec236f Revert "Remove widgetContent" (#795)
1c08e64651a4920fb56998528ed2868f70fea767 fix dataprotocol developement problems (#788)
3432dac261281b8955f9c9d46e59551fb66cf7fc Task contribution (#742)
5adab4fafba1254e29851d3153058b4e1e72a843 remove widgetContent (#784)
d45aebcd19386cc6bb41b7f6c789d5e0c5fca412 Bump SQL Ops to version 0.27.0 (#782)
6bf21e43407543f572e228cef549a2207d32fe41 fix layout issue for left nav bar and dashboard (#773)
7ee6dfa21efc89697b8289a6ff3e34125cd65e06 Add shortcut for toggle results pane (#764)
bd7341ddc2dade5a5ca2848ba6cd77ba1a09fb89 Tab contribution support both inline container and registered container (#766)
f9d8f479b5e9f4cb6b02fdbb91b7b45ae7e57abb Move dashboard properties, fix scroll (#758)
fdc956e116b0989f171476be3034e99381572549 Removed duplicate contribution from README.md (#753)
a44df9adab86b54b975b2f25332cf08e3dff3c9c vbump htmlqueryplan to 2.4 (#744)
dbc2ce0b3ac4ce49e73544d63fc7ff09b5ddd65a Refactor and rename dashboard tabs part 1 (#755)
51b8e02455d443662917b80fcf19bb6cfc135304 Support left nav bar and inner tabs (#751)
4f9dfe9afa5a66b904b19b8ebaf304f675e41189 initial check in for dashboard grid layout (#740)
db05ed840d54d7edf22fb44105cdc36c04812081 removed rating and installs from extension manager UI (#743)
8570910a430785ef9cac8f264bbc1f2f4c271af0 Move protocol client out (#643)
c166ce112b9aa029151a9aeff38294cf47bf2ee8 Refactor dashboard tabs to have widgets and webview tab contents  (#716)

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.

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.

February Public Preview (0.26.7)

0.26.7 takes an additional update to address https://github.com/Microsoft/sqlopsstudio/issues/717
0.26.6 takes an additional update to address https://github.com/Microsoft/sqlopsstudio/issues/693
0.26.5 takes an additional update to address https://github.com/Microsoft/sqlopsstudio/issues/687
0.26.4 is the final planned build for Feb. Though we may take additional fixes as needed prior to 2/15/2018.

February Preview Insiders Build 0.26.1

The February Preview Insiders Build 0.26.1 is the initial test build for this month's release planned on 2/15/2018. Some of the highlights in this build include the following.

• Fix #6 Keep connection and selected database when opening new query tabs
• Fix #22 'Server Name' and 'Database Name' - Can these be drop downs instead of text boxes?
• Fix #481 Add "Check for updates" option.
• SQL Editor colorization and auto-completion fixes
  • #584 Keyword "FULL" not highlighted by IntelliSense
  • #345 Colorize SQL functions within the editor
  • #300 [#tempData] latest "]" will display green color
  • #225 Keyword color mismatch
  • #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

Auto-Update Installation

The plan is to publish the February Public Preview release as an auto-update from the January Public Preview release. We want to use the February Insiders builds to test the auto-update feature. The 0.26.2 build will be released as an auto-update to 0.26.1 (assuming there are no issues that require publishing a new build to successfully support auto-update).

Connection Dialog 'Database' Drop-down

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.

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:

• SebastianPfliegel for Add cursor snippet (#475 )
• mikaoelitiana for fix: revert README and CONTRIBUTING after last VSCode merge (#574 )

Changelog

-- Changes for 0.26.7 build
cea52d2314b7306f57ba231c6ffa366cf262f5f0 add a false output channel to the other place we create a client (#720)
-- Changes for 0.26.6 build
f1b64918cefcd735d39fb4bedd5dde524c711356 Bump SQL Ops Studio to 0.26.6 (#702)
005e3f1476c234900ee49a52cfabe1d4e8a9639e fix packaged build dropdown icon (#701)
f5a866aa423983169f4ea81898169416bdc0a35f clone value to keep from getting previous settings (#688)
-- Changes for 0.26.4 build
f1ddea986ada5b616f985741714536a9f79ed3fb Change Windows setup so that sqlops restarts after auto-updating (#684)
040549d2647358a58d30a3d857292f5570471e72 Connection Dialog: Database dropdown followup issues fix (#662)
73fbd787d844d317f3e3bed7740143a5a8824934 Reinstate menu item to install from VSIX (#682)
b6f848eff18158b7708f8796509a624dba9bd19f Bump SQL Ops version to 0.23.4 for next build (#677)
6f21d6e27ed27cad9375dddf9839dcce971e8730 Output undefined channel for client (#675)
af9c3d38727f75969e0f9b9ca5454b38dce4af52 bump slickgrid (#674)
7806a29bed65ad8d42a92a6cb2f8e132de434625 Bump SQL Tools Service version for fix (#669)
0412b643d2dddc953763f5dfaea83d6c0729ec6c fix rerender insight widget issue (#663)
-- Changes for 0.26.3 build
d7ee37a9465937e5a8b65204dbb1d2fb12256e93 Bump SQL Ops to 0.26.3 (#659)
af53a13e6b66698b25aa78c478fa2d331bde0754 Register credential provider after language client onReady (#657)
98fa028ce55ae17c5f0c5c5b4754268b53ec67dc Bump tools service to 1.4.0-alpha-9 (#658)
6c83736626f9460ad8e9d62c0d49742e32ed5eaf Update flat action bar icons (#652)
959b4fbab520a6d51df833c9a1faa7e3ff4e2614 Object Explorer: Refresh OE node if database restored (#607)
3b7ff61000167f810a2aee676288ebf01f07d52c Reapply publish script changes lost in VS Code 1.19 merge (#653)
cf283a9266096a0e6eb01d8d08803a696ce6ff42 Remove unneeded files from packaged builds (#642)
e28b86ea8772a07aafab88864f149ea759bf1066 Fix some minor connection db dropdown bugs (#637)
362664c4d8b5d4dd19b0f495f2121e4e55e79978 Redo changes for object explorer arrow colors (#633)
c860a0edb2ad1fe2655642723825cc01768a1747 Update angular2-slickgrid version (#628)
-- Changes for 0.26.1 build
e5eaacca6bad043d3e157ff1e6275efe9d94f617 Bump SQL Tools Service to 1.4.0-alpha-8
a8c7c695093d83e0de5fc5ae800025c35e4ad19c Connection Dialog: Dropdown for database name (#583)
579e6bf0cb4d51122e58295fcc8ec8e2a4ac2f1e Fix additional regressions in master (#621)
24ea675d7dc49eb28378f241a93f0844a8870e4f Edit Data: Fix editing stopping after tab switch (#579)
3df522536f5a869b5e827fa933e9a7a26c5ba835 Introduce connection API (#598)
f5aa49ebb9fb38ff174723c0353b5c7efa601d8a Fixes the 'undefined' in connection tree when capabilities not loaded (#617)
3076390eb1cbb4fa440abf0597722ebb78f6b443 Skip opening sqlops after install if the setup exe is run with the VERYSILENT option. (#611)
b7c935c6024133a9ba341fecb2e58fa0f90cb1e0 Fix several regressions in master (#613)
bbb0f39a94b4a4f0560627dd37f076407bf29fbc Don't cut off dashboard icons when they expand (#601)
fe04fd72bce8883ead19c401a7fbe3b413cfc89a Update query editor colorization to match SSMS (#580)
234c2f7c9e3002f071037b4811d78b7f17495833 Random undefined access (#582)
1b2e264c7d56f46661ad9818cf33df6e66955256 Dialog with custom UI API  (#561)
03baf3610a5e56012ea0beb86f3224f20511ecf4 fix: revert README and CONTRIBUTING after last VSCode merge (#574)
251ae01c3e9ec484991a90891613b1de2ae339ce Initial VS Code 1.19 source merge (#571)
9a1ac207104d9cd958b8b4d3ea310336cd8849f3 Show current connection info in the status bar (#551)
f640bda80281b464bca376be8b07c5ef09e1cc83 bump slickgrid to take a hot fix (#552)
a63800deb1a7b8a4476bc3bafd2bf664ad800f97 Add global current connection (#505)
e432884e25b4689a9dec31c84f65100fd5a303ca Update jquery (#532)
006eedd3a18ec0f7bce811f74f3b306b766bbf28 Update vscode build publishing scripts for use with sqlops (#518)
cb4fe55bef456d094de5244fc6167b960afcf7b1 bump html query plan (#517)
e2efe69b73f1f138ec54729d98f71ca8aacd50cd fix sizing issues with explorer widget (#502)
edd867b6fcc8a8a3cf63147c4d09f42f10f62c8e Fix #494 Connection error when connecting to an Azure SQL Server with no firewall rule (#497)
78084964161fbe72e011cef1778a87f16dbb7394 Update dataprotocol client (#418)

Known Issues

We are working through issues in the February milestone for this month's Public Preview build. See this issue query for remaining planned work https://github.com/Microsoft/sqlopsstudio/milestone/5. A couple notable issues include the following.

January Preview Insiders Build 0.25.2
January release candidate build. We'll likely pick up this fix prior to planned Jan 17th release #469 Enable hot exit for saved files.

Change Log

Version 0.25.2

• Release date: January 17, 2017
• Release status: Public Preview

What's new in this version

The January release focuses on addressing a few of the top upvoted feature suggestions, as well as fixing high-priority bugs. This release period coincides with holiday vacations, so the churn in this release is
relatively scoped.

Here's some of the highlights in the January release.

• Tab-coloring based on Server Group
• Saved Server connections are available in Connection Dialog
• Enable HotExit feature Pending testing and bug fix port
• 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
• Change "Server name" to "Server" in Connection Dialog

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:

• alextercete for Fix "No extension gallery service configured" error (#427)

January Preview Insiders Build 0.25.4
Minor bug fix update that re-enables HotExit and fixes auto-update metadata. Please see previous 0.25 releases for additional details on January updates.

Change Log

475904d2b2e32e7f91284c199234399ee7d5d418 Fix #494 Connection error when connecting to an Azure SQL Server with no firewall rule (#497)
11ef8fc78418a433d1b51fcf07779602b1bfb8b2 Update changelog and readme for Jan release (#496)
fcb6f7f9ee63816bfb4bf3566281ba797a315fd2 open-url changes
94bd1c4d7d82c8d21bc9dbb5cb67b0d99ad091a5 Bump SQL Ops to 0.25.4 for next Jan release candidate build (#483)
e4a0e4e0c179e64f18d53c560e259917fb1588fd Add cursor snippet (#475)
a69a9778a616c227d9ed158e21fd4c4a63bdc445 Fix update package download paths (#476)
6d3995aa298394db3d9fb992e883fcf21e5fbbe0 Enable hot exit for saved files (#469)

January Preview Insiders Build 0.25.0
This is the initial January release insiders build. January release will primarily focus on bug fixing and minor feature improvements. Some highlights and full changelog are below.

• Enable HotExit feature to automatically reopen unsaved files
• Add ability to access saved connections from Connection Dialog
• Set SQL editor tab color to match Server Group color
• Fix broken Run Current Query command
• Fix broken pinned Windows Start Menu icon

Saved Connections available in Connection Dialog

The Connection Dialog now contains a "Saved Connections" tab that contains the list of saved server connections from the Servers "Object Explorer" viewlet.

SQL Editor Tab Color to match Server Group Color

SQL query editor and dashboard windows will have the same color as the Server Group used to open the window. This feature can be disabled using the following setting "sql.enableTabColors": false.

Changelog

ee80bddd174afdc2e04f1a087a34d2816dff6b4c Remove unneeded npm package references from mssql (#438)
c9067a0bafbfdd33388c5c3ce70c7b2afa32f367 Install tools service relative to extension (#437)
ecc978a69509063ba97e6e6c705e43107de84dc7 Update copyright date to 2018 (#431)
4a28e813c55ad19abb33d7da31b7c27557c596f8 changed icon color when tree selected for light theme (#425)
b8db4a76b4fc2e94171837000a55768987b396e2 Fix broken Run Current Query command (#420)
e8b1b1a75ff6fed3b7d244e3a07900cd30e3fff9 Add saved connections to connection dialog (#411)
874b242944e011b6c95edbb04bc8817e7e1f6144 fix theming issue for manage account status bar icon (#396)
da75681f83297707b1f8bcc8b2626980df3c79ca Fix issue where loading unsave sql file open as untitiledEditorInput (#385)
8afebd2e10f7a671e268768d270f3b860f6aa85d Extensions Cleanup (#359)
b1b3a92717b6481108b2588facd7b4052044af69 Add tab coloring by server group (#383)
3ffafbe5bc096a9214c1672ec82b13dea5fec096 Resize the start menu pinned icons to display correct (#382)
eb81a72b88a90f1579c003309f034f0f1f564f2c Update SQLOPS version to 0.25.0 for Jan release (#380)
2e70b55da82b431ed1a4eaef5a6b909a03c56bf1 Update pinned start menu icons (#379)
ad0c12ec9513977395af7da6d7d9e8e9051557d5 Change 'Server name' to 'Server' (#372)
572aebd8c8400e96abd0185d3473a6063a27a7e8 fixed bug where drag and drop would break scripting (#369)

Additional Notes

Linux binaries are 0.25.1 since they required a couple additional fixes to resolve recent regressions.

December Public Preview 0.24.1
December Public Preview 0.24.1 is a refresh release that picks up several bugs fixes across all feature areas, as well as a handful of highlights. See the full CHANGELOG for additional details.

• Azure Integration with Create Firewall Rule
• Windows Setup, Linux DEB and Linux RPM installation packages
• Manage Dashboard visual layout editor
• Script As Alter and Script As Execute commands
• Integrate VS Code 1.18.1 editor platform
• Enable Sideloading of VSIX Extension files
• Support "GO N" batch iteration syntax
• "Run Current Query with Actual Plan" command

Azure Integration with Create Firewall Rule

One of the more exciting features enabled in the December release is Azure Integration with Create Firewall Rule dialog. When a connection to an Azure SQL DB instance fails due to a server firewall rule the Create Firewall Rule dialog will allow the user to use their Azure subscription account to automatically configure the client IP address with the server.

Windows Setup, Linux DEB and Linux RPM installation packages

Windows Setup, Linux DEB and Linux RPM installation packages simplify and speed-up product acquisition. Our next steps are to support auto-updates and provide a more frequent insiders build.

"Run Current Query with Actual Plan" command

There is now a command "Run Current Query with Actual Plan" which will execute the current query and return the actual execution plan with the query results. This feature area is still in-progress as we work through the best UX for integrate this command directly into the query editor. While that design work is in-progress the functionality is still available via the Command Palette and you can define a keyboard shortcut if using this feature frequently.