Skip to content

Latest commit

 

History

History
577 lines (463 loc) · 34.4 KB

CHANGELOG.md

File metadata and controls

577 lines (463 loc) · 34.4 KB
Raw

Change Log

Version 1.27.0

  • Release date: December 18, 2024
  • Release status: GA

What's new in 1.27.0

  • Added the ability to filter query result rows by value
  • Added the ability to maximize a specific result set from a query result with multiple sets
  • Added a prompt for adding a firewall rule when using the new Connection Dialog to connect to an Azure SQL Database logical server
  • Fixed usability bugs encountered when viewing query plans
  • Improved performance when resizing the new query results pane with many result sets
  • Fixed several bugs related to the query result message display

Version 1.26.0

  • Release date: November 20, 2024
  • Release status: GA

What's new in 1.26.0

  • Added the ability to open query results in a tab for the new UI, replicating the functionality of the previous query results experience.
  • Added the mssql.openQueryResultsInTabByDefault setting, allowing users to set this behavior as the default (applicable only when mssql.enableRichExperiences is enabled).
  • Added ability to view the actual query plan for executed queries in the new UI.
  • Added support for Visual Studio Code theming in the new UI.

Version 1.25.0

  • Release date: October 23, 2024
  • Release status: GA

What's new in 1.25.0

  • Added mssql.enableRichExperiences setting to enable modern experiences (public preview), including a connection dialog, table designer, new query results pane, query plan viewing, and object explorer filtering. Learn more
  • Added multiple result set support in new query results pane
  • Added browsing your Azure subscriptions to connect to a SQL database

Version 1.24.0

  • Release date: September, 4, 2024
  • Release status: GA

What's new in 1.24.0

  • Fix Query messages lost switching tabs bug
  • Add mssql.enableExperimentalFeatures setting to enable early preview connection, query plan, and table design experiences
  • Fix several accessibility bugs

Version 1.23.0

  • Release date: July, 31, 2024
  • Release status: GA

What's new in 1.23.0

Version 1.22.1

  • Release date: January, 10, 2024
  • Release status: GA

What's new in 1.22.1

Version 1.22.0

  • Release date: November 8, 2023
  • Release status: GA

What's new in 1.22.0

  • Azure Active Directory (Azure AD) is renamed to Entra Id - #17824

  • Added command for clearing Azure token cache - #17807

  • Added support for setting Firewall rule name in firewall rule - #17803

  • Removed Azure tenant config filter setting - #17798

  • Bug Fixes:

    • Fixed Firewall Rule creation issues when prompted - #17607
    • Fixed proxy error 502 when downloading Sql Tools Service - #17772
    • Fixed an issue where connection profile could not be saved after enabling trust server certificate #17805

Version 1.21.0

  • Release date: September 20, 2023
  • Release status: GA

What's new in 1.21.0

  • Enabled connection pooling by default and added command support to clear pooled connections - microsoft#17786
  • Added setting to configure maxCharsToStore to allow reading large data strings - microsoft#1052
  • Bug Fixes
    • Fixed status bar to show correct 'Encryption' option for connection - microsoft#17671

Version 1.20.1

  • Release date: August 7, 2023
  • Release status: GA

What's new in 1.20.1

  • Fixed an issue with not being able to download the SQL Tools Service Component in a proxy-enabled environment (microsoft#17755)

Version 1.20.0

  • Release date: July 26, 2023
  • Release status: GA

What's new in 1.20.0

  • Added new setting to support enabling connection pooling for performance improvement - microsoft#17733
  • Bug Fixes:
    • Fixed issue where creating connection with connection string would fail - microsoft#17737
    • Fixed issue where Copy actions wouldn't work on Data Grid cells - microsoft#17722
    • Added missing DB Create syntax keyword colorization - microsoft#17732
    • Improved connection description when selecting connection from quick pick - microsoft#17737
    • Fixed authentication issue where user account could not be found in MSAL Cache in Linux - microsoft#17747

Version 1.19.1

  • Release date: June 5, 2023
  • Release status: GA

What's new in 1.19.1

Version 1.19.0

  • Release date: May 24, 2023
  • Release status: GA

What's new in 1.19.0

  • Added support for Linux ARM64 runtime - microsoft#17639
  • Use preferred username instead of email for Azure accounts - microsoft#17606
  • Removed prompt to select tenant when SQL Auth Provider is enabled - microsoft#17611
  • Updated msal-node npm package to v1.16.0 - microsoft#17605
  • Bug Fixes
    • Added validation for servername before attempting connection microsoft#17680
    • Fixed an issue when selecting "Add Azure Account" during profile creation prompts for profile name first microsoft#17664
    • Fixed a bug where SQLCMD variables weren't getting JSONified microsoft#17683

Version 1.18.0

  • Release date: March 22, 2023
  • Release status: GA

What's new in 1.18.0

  • Upgraded AAD Azure account management to support MSAL authentication.
  • Added native MacOS and Windows arm64 support - microsoft#17614
  • Added "Group by Schema" to Object Explorer - microsoft#17543
  • Add Object Explorer connection timeout setting - microsoft#17548
  • Accessibility Fixes
    • Screen Reader is not reading the full information related to the database name - microsoft#17204
    • After pressing tab key from "More actions" keyboard focus is going to bottom status bar instead of going to the "messages" dropdown - microsoft#17192
    • Message window does not expand and collapse with the help of keyboard and shortcut key - microsoft#1687

Version 1.17.0

  • Release date: January 25, 2023
  • Release status: GA

What's new in 1.17.0

  • BREAKING CHANGE - Connection Encryption is now Enabled by Default - microsoft#17484
    • Moving to Microsoft.Data.SqlClient 5.0.1 dependency with STS Update
    • By default, saved connection profiles will connect with encryption and only accept trusted server certificates. This is a breaking change for some connections and some saved connection profiles may require updates to connect.
    • See https://aka.ms/vscodemssql-connection for more information.
  • Introduced HostNameInCertificate Connection Property.
  • Exposed getServerInfo API to allow Target Platform to be set automatically when creating SQL Projects from database
  • Accessibility Fixes
    • Fixed Screen Reader not reading status of "loading query" - microsoft#17451
    • Fixed Screen Reader to announce messages table in a clearer manner - microsoft#17450
    • Fixed issue where Results Table was not minimizable with keyboard - microsoft#17452

SQL Grammar Fixes & Updates

Version 1.16.0

  • Release date: August 24, 2022
  • Release status: GA

What's new in 1.16.0

  • Added support for creating Azure Functions with SQL Bindings from Views in the Object Explorer
  • Fixed issues with Integrated authentication in Unix environments microsoft#17333

Version 1.15.0

  • Release date: June 15, 2022
  • Release status: GA

What's new in 1.15.0

Version 1.14.2

  • Release date: May 20, 2022
  • Release status: GA

What's new in 1.14.2

  • Adds extension APIs for managing Azure resources

Version 1.14.1

  • Release date: April 22, 2022
  • Release status: GA

What's new in 1.14.1

Version 1.14.0

  • Release date: April 20, 2022
  • Release status: GA

What's new in 1.14.0

  • All SQL bindings functionality released in 1.13 moved to SQL bindings extension in extension pack
  • Fixed connection string generated for SQL bindings on connection to <default> database. microsoft#17267
  • Fixed error with heirarchyID data type in results pane. microsoft/sqltoolsservice#1450

Version 1.13.0

  • Release date: February 24, 2022
  • Release status: GA

What's new in 1.13.0

  • Adds context menu item for object explorer table nodes to create an Azure Function with SQL binding for that table
  • Updated SqlParser to fix some intellisense issues
  • Fixed decimal datatype handling microsoft/azuredatastudio#275
  • Fixed BatchParser execution error caused by missing resource files microsoft#17221

Version 1.12.0

  • Release date: December 15, 2021
  • Release status: GA

What's new in 1.12.0

  • Fix AAD token refresh bugs
  • Fix Azure SQL DB connectivity bug
  • Add support for SELECT * column expansion
  • Add Untrusted Workspace support

Version 1.11.1

  • Release date: November 17, 2021
  • Release status: GA

What's new in 1.11.1

Version 1.11.0

  • Release date: October 27, 2021
  • Release status: GA

What's new in 1.11.0

  • SQL Project and Workspace preview extension pack
  • Support Apple M1 with Rosetta2 enabled
  • Fixed bugs in Azure Active Directory authentication
  • Add support to script triggers
  • Additional SQL query execution settings
  • Colorization improvements

Version 1.10.1

  • Release date: January 20, 2021
  • Release status: GA

What's new in 1.10.1

  • Fixed bug in AAD support causing Integrated Auth connections to fail

Version 1.10.0

  • Release date: December 10, 2020
  • Release status: GA

What's new in 1.10.0

  • Azure Active Directory authentication support
  • Accessibility improvements
  • Fixes in SQL syntax colorization with comments
  • Added new functions/keywords to SQL syntax highlighting
  • Fixed keyboard shortcuts for results

Contributions and "thank you"

  • @asottile for make SQL plist parseable xml (#1660)
  • @KamasamaK for Allow multiple whitespace between keywords (#1683)
  • @sharechiwai for fixed README.md version 1.9.0 release date typo (#1757)
  • @SJMakin for Ammend sql.configuration.json to address syntax highlighting issue fo…

Version 1.9.0

  • Release date: March 5, 2020
  • Release status: GA

What's new in 1.9.0

  • Added new Query History feature
  • Added Run Query and Cancel Query buttons on the editor
  • Added rows affected count to status bar
  • Added Object Explorer support for connection string based connections
  • Removed redundant MSSQL output channel for logs
  • Fixed leading tabs when copying multiple selections
  • Fixed styling of NULL cells in query results
  • Fixed leading tabs when copying multiple selections
  • Fixed resizing messages pane causing double scrollbars to appear
  • Fixed errors are not getting cleared when a file is closed

Contributions and "thank you"

  • @sukano for fix string highlighting containing escaped characters (#1630)
  • @testingcan for added create and drop snippets for views (#1215)

Version 1.8.0

  • Release date: December 16, 2019
  • Release status: GA

What's new in 1.8.0

  • Added support for scripting context menu actions on the Object Explorer
  • Added support for adding a new firewall rule to a server
  • Added differentiation between database connections and server connections
  • Reduced extension size from 10 MB to 6MB
  • Open pinned doc when starting a new query
  • Fixed scrolling and heights for multiple result sets
  • Fixed bug to use the correct database for new query from Object Explorer

Contributions and "thank you"

We would like to thank all our users who raised issues.

Version 1.7.1

  • Release date: November 11, 2019
  • Release status: GA

What's new in 1.7.1

  • Fix missing row count and dropped Object Explorer connections bugs

Version 1.7.0

  • Release date: October 17, 2019
  • Release status: GA

What's new in 1.7.0

  • Announcing IntelliCode support
  • SQL Server Connections viewlet
  • Added support for SQLCMD Mode
  • Updated SqlClient driver
  • Users can adjust size of SQL results window
  • Users can navigate with keyboard away from SQL results screen
  • Fixed copy paste with keyboard shortcut
  • Added Copy Header option to results grid
  • Fix "Save as CSV" exception

Contributions and "thank you"

We would like to thank all our users who raised issues.

Version 1.6.0

  • Release date: April 22, 2019
  • Release status: GA

What's new in 1.6.0

  • Extension install no longer requires reloading VS Code
  • Update Query Results Webview API calls for compatibility with VS Code May release
  • Fix "Save as CSV" exception

Contributions and "thank you"

We would like to thank all our users who raised issues.

Version 1.5.0

  • Release date: March 22, 2019
  • Release status: GA

What's new in 1.5.0

  • Update vscode-languageclient to fix issue #1194 Refresh Intellisence cache option don't work
  • Import CSV export options such as setting delimiter, line separator, encoding and include headers
  • Add missing SQL keywords to colorization list
  • Fix Peek Definition\Go to Definition bug on SQL Server 2017

Contributions and "thank you"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute features or localization of the tool:

  • @praveenpi for updated sql2016-crud-demo (#1156)
  • @benrr101 for Fix for #1178 by replacing all whitespace with non-breaking spaces. (#1181)
  • @eashi for Use correct tag for gulp package (#1154)
  • @shaun-hume for Fix spelling errors in README.md (#1148)
  • @bruce-dunwiddie for Fixed typo on serverproperty. (#1147)
  • @franciscocpg for Adding support for antergos platform (#1144)
  • @SebastianPfliegel for Added more saveAsCsv options (#1128)
  • @mattmc3 for Add missing keywords (#1133)
  • @ChiragRupani for Added support for specifying delimiter while exporting query results as CSV (#1120)
  • @zackschuster for fix typo in CHANGELOG.md (#1119)

Version 1.4.0

  • Release date: June 28, 2018
  • Release status: GA

What's new in 1.4.0

  • Updated to .NET Core 2.1 to address issues where some Mac users encountered connection errors
  • Added support for Deepin Linux
  • Updated query results display to use VS Code's new webview API
  • Added a new experimental setting "mssql.persistQueryResultTabs" which when set to true will save your scroll position and active selection when switching between query result tabs

Contributions and "thank you"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute features or localization of the tool:

Version 1.3.1

  • Release date: April 10, 2018
  • Release status: GA

What's new in this version

  • Fixed issue #1036 where copy/pasting Unicode text can fail on Mac depending on the active locale environment variable
  • Fixed issue #1066 RAND() function using GO N produces the same result
  • Syntax highlighting more closely matches SSMS for local variables, global system varaibles, unicode string literals, bracketed identifiers, and built in functions
  • Show all error messages instead of just the first one when query execution results in multiple errors

Contributions and "thank you"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute features or localization of the tool:

  • @rhires for updating and editing the Kerberos help documentation
  • @zackschuster for cleaning up the VS Code API wrapper to remove a deprecated function call
  • We would like to thank everyone who contributed to localization for this update and encourage more people to join our open source community localization effort.

Version 1.3.0

  • Release date: December 11, 2017
  • Release status: GA

What's new in this version

  • Fixed an issue where peek definition and go to definition failed for stored procedures.
  • Improved performance for peek definition and go to definition.
  • Added support for GO N syntax.
  • Fixed issue #1025 where query execution would fail when executing from file paths containing special characters
  • Fixed issue #785 Inactive connection can't reconnect with out VS Code restart
  • A community-contributed fix for snippets that failed on databases with case-sensitive collations.

Contributions and "thank you"

  • Thank you to Stefán Jökull Sigurðarson for contributing the fix for snippets that failed with case-sensitive collations, which was ported here from the SQL Operations Studio repository.
  • We would like to thank everyone who contributed to localization for this update and encourage more people to join our open source community localization effort.

Version 1.2.1

  • Release date: November 8, 2017
  • Release status: GA

What's new in this version

  • Support for multi-root workspaces in preparation for the feature's release in Visual Studio Code. When running with multi-root workspaces, users will be able to set many configuration options at the folder level, including connection configurations.
  • Exporting results as CSV, JSON, or Excel files now shows the operating system's save-as dialog instead of using text-based dialogs to name the saved file.
  • Fixed issue #998 Intellisense against Azure SQL DBs very inconsistent.

Version 1.2

  • Release date: September 22, 2017
  • Release status: GA

What's new in this version

  • Support for macOS High Sierra.
  • VSCode-Insiders users will see their connections are now read from and saved to the Insiders settings file instead of the regular Visual Studio Code location. Fixes #242.
  • Saving connections no longer affects comments in the settings file #959.
  • Intellisense errors and suggestions can be disabled on a per-file basis #978. Use the MS SQL: Choose SQL Handler for this file action or click on the MSSQL status bar item when a .sql file is open to disable intellisense on that document.
  • Fixed issue #987 Cannot change password of a saved profile.
  • Fixed issue #924 Database name with $ is not showing up correctly in database list.
  • Fixed issue #949 Drop database fails most of the time because the db is in used.
  • Fixed issue MS SQL: Execute Current Statement where it did not handle 2 statements on a single line correctly.
  • Improved support for SQL Server 2017 syntax by refreshing IntelliSense and SMO dependencies.

Contributions and "thank you"

We would like to thank everyone who contributed to localization for this update and encourage more people to join our open source community localization effort. mssql for Visual Studio Code was opened for community localization since February 2017 for the following languages French, Italian, German, Spanish, Simplified or Traditional Chinese, Japanese, Korean, Russian, Brazilian Portuguese. If you see a string untranslated in your language, you can make an impact and help with translation. You can find out how by checking https://aka.ms/crossplattoolsforsqlservercommunitylocalization.

Version 1.1

  • Release date: July 18, 2017
  • Release status: GA

What's new in this version

  • Preview support for Integrated Authentication (aka Windows Authentication) on Mac and Linux. To use this you need to create a Kerberos ticket on your Mac or Linux machine - see this guide for the simple process. Once this is set up, you can say goodbye to SQL passwords when connecting to your servers!
    • This feature is in preview in .Net Core 2.0. The corefx repository tracks issues related to SqlClient and we recommend issues setting up Kerberos tickets be raised there.
    • macOS "El Capitan" and older versions will not support this feature or any other features requiring a new SqlToolsService version. To benefit from Integrated Authentication, "Execute Current Statement" and other new features we recommend updating to the latest OS version.
  • New code snippets:
    • sqlGetSpaceUsed shows space used by tables. Thanks to Rodolfo Gaspar for this contribution!
    • sqlListColumns shows columns for tables matching a LIKE query. Thanks to Emad Alashi for this contribution!
  • Support for connecting using a connection string. When adding a connection profile you can now paste in an ADO.Net connection string instead of specifying server name, database name etc. individually. This makes it easy to get strings from the Azure Portal and use them in the tool.
  • Support for empty passwords when connecting. Password is no longer required, though still recommended! This is useful in local development scenarios.
  • Improved support for SQL Server 2017 syntax by refreshing IntelliSense and SMO dependencies.
  • Fixed all code snippets so that tab ordering is improved and snippets no longer have syntax errors
  • Fixed issue where snippets were not shown when mssql.intelliSense.enableIntelliSense was set to false.
  • Fixed issue #911 where tools service crashed when Perforce source code provider is enabled in the workspace.
  • Stability fixes to reduce the likelihood of SqlToolsService crashes.
  • Fixed issue #870. Added an "Execute Current Statement" command that executes only the SQL statement where the cursor is currently located.
  • Fix issue #939 "Show execution time for individual batches". To enable open your settings and set mssql.showBatchTime to true.
  • Fix issue #904. Added a "Disconnect" option to the status bar server connection shortcut. Clicking on this now lists databases on the current server and a "Disconnect" option.
  • Fix issue #913. OpenSuse Linux distributions are now supported.

Version 1.0

  • Release date: May 2, 2017
  • Release status: GA

What's new in this version

  • We are please to announce the official GA of the MSSQL extension! This release focuses on stability, localization support, and top customer feedback issues
  • The MSSQL extension is now localized. Use the Configure Language command in VSCode to change to your language of choice. Restart the application and the MSSQL extension will now support your language for all commands and messages.
  • Community-added support for Save as Excel, which supports saving to .xlsx format and opening this in the default application for .xlsx files on your machine.
  • Numerous bug fixes:
    • IntelliSense improvements to support configuration of Intellisense options from user settings, plus keyword fixes.
    • Query Execution fixes and improvements: #832, #815, #803, #794, #772
    • Improved support for downloading and installing the tools service behind proxies
    • Improvements to Go To Definition / Peek Definition support #769

Contributions and "thank you"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute features or localization of the tool:

  • Wujun Zhou, for adding the Save as Excel feature
  • The many contributors to our community localization. A full list is available on this TechNet post. Particular thanks to Mona Nasr for coordinating our community localization efforts.

Version 0.3.0

  • Release date: March 1, 2017
  • Release status: Public Preview

What's new in this version

  • T-SQL formatting support is now included. This is a highly requested feature, and this release includes a basic parser with configuration options for some of the most common T-SQL formatting styles.
    • To format a .sql file, right-click and choose Format Document.
    • To format part of a document, highlight a selection, right-click and choose Format Selection
    • To change the formatting settings, hit F1 and choose Preferences: Open User Settings. Type in mssql.format and change any of the options
  • Refresh Intellisense Cache command added. This will rebuild the intellisense for a connected database to include any recent schema changes
  • New Query command added. This opens a new .sql file and connects to a server, making it quicker to get started with your queries
  • Fixed support for SQL Data Warehouse connections.
  • Prototype localization support added. We will be adding full localization support in a future update.
  • Improved Peek Definition support. Multiple bug fixes, and additional supported types.
    • Supported types: Tables, Views, Procedures, User Defined Tables, User Defined Types, Synonyms, Scalar Functions, Table Valued Functions
  • Support for Windows x86 machines
  • Fix for issue #604 where results that included HTML were not rendered correctly
  • Multiple fixes for syntax highlighting
  • Fixed issues where query execution failed due to parser failures.

Version 0.2.1

  • Release date: February 2, 2017
  • Release status: Public Preview

What's new in this version

  • HotFix for issue #669 "Results Panel not Refreshing Automatically". This issue impacts users on VSCode 1.9.0 or greater.

Version 0.2.0

  • Release date: December, 2016
  • Release status: Public Preview

What's new in this version

  • Peek Definition and Go To Definition support for Tables, Views and Stored Procedures. For a query such as select * from dbo.Person you can right-click on dbo.Person and see it as a CREATE TABLE script.
  • Support for additional operating systems including Linux Mint and Elementary OS. See Operating Systems for the list of supported OSes.
  • Output window now shows status of SQL tools service installation to make it easier to track install-time issues.
  • Progressive Result Sets: when running multiple queries at once, you'll now see result sets appear as soon as they are done processing instead of waiting for all queries to complete. The extension supports result set-level updates with per-row updates coming in a future update.
  • Multiple results view improvements: improved keyboard navigation, configuration settings to alter default font style and size, support for copying with column headers.
  • Multiple IntelliSense improvements: Support using [bracket].[syntax], handling of " at the end of a word, improved performance when connecting to same DB from a new file.

Version 0.1.5

  • Release date: Nov 16, 2016
  • Release status: Public Preview

What's new in this version

The SQL Tools team is excited to announce that the first public preview release of mssql for Visual Studio Code is available in the Visual Studio Code Marketplace. Try it and provide your feedback or report any issue to GitHub Issue Tracker.

If you are new to VS Code and the mssql extension, see the getting started tutorial for step-by-step guides. For more about how-to guides see the mssql extension wiki.

Quick summary of the mssql extension features

This extension makes it easy to connect to, query and modify your SQL Server, Azure SQL Database, and Azure SQL Data Warehouse instances.

  • Create and manage your frequent connections to SQL Server, Azure SQL Database and Azure SQL Data Warehouse as a profile. The mssql extension keeps the recent history of your connection activities and saves passwords in a secure store, making connecting to your database easy. Create, Edit, Remove and Clear your recent connections. See manage connection profiles for more details.

  • Productive T-SQL editor features including IntelliSense with suggestions and auto-completion, syntax highlighting and real-time T-SQL error checks and reporting.

  • Execute T-SQL scripts and view results, all with a native Visual Studio Code look and feel. View query results and related messages without needing to tab between them.

  • Save query results as CSV or JSON.

  • Customize shortcuts, color themes and options to meet your preference.

  • This is an open source project under the MIT license. Go check out how to contribute.

Upcoming changes and features

  • Top customer reported issues in GitHub Issue Tracker.

  • Faster performance: Progressive query results. As soon as SQL Server returns results to the extension these should be shown to the user, even for large queries.

  • Delivery of additional T-SQL editor features, for example support for Go To Definition and Find All References.

  • More bugs fixes and fine tuning of features.

Fixed Issues

Report issues to Github Issue Tracker and provide your feedback.

Known Issues

  • The mssql extension process may crash due to a bug in the product. It requires to restart VS Code to recover. Before restarting VS Code, please save your files.

  • Installation Prerequisites: this extension requires the user to install some components needed by .Net Core applications, since this is used for connectivity to SQL Server.