- Release date: December 18, 2024
- Release status: GA
- 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
- Release date: November 20, 2024
- Release status: GA
- 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.openQueryResultsInTabByDefaultsetting, allowing users to set this behavior as the default (applicable only whenmssql.enableRichExperiencesis 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.
- Release date: October 23, 2024
- Release status: GA
- Added
mssql.enableRichExperiencessetting 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
- Release date: September, 4, 2024
- Release status: GA
- Fix Query messages lost switching tabs bug
- Add
mssql.enableExperimentalFeaturessetting to enable early preview connection, query plan, and table design experiences - Fix several accessibility bugs
- Release date: July, 31, 2024
- Release status: GA
- update STS dependency to address Transaction Isolation Level bug
- Release date: January, 10, 2024
- Release status: GA
- update STS dependency to address CVE-2024-0056
- Release date: November 8, 2023
- Release status: GA
-
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:
- Release date: September 20, 2023
- Release status: GA
- Enabled connection pooling by default and added command support to clear pooled connections - #17786
- Added setting to configure
maxCharsToStoreto allow reading large data strings - #1052 - Bug Fixes
- Fixed status bar to show correct 'Encryption' option for connection - #17671
- Release date: August 7, 2023
- Release status: GA
- Fixed an issue with not being able to download the SQL Tools Service Component in a proxy-enabled environment (#17755)
- Release date: July 26, 2023
- Release status: GA
- Added new setting to support enabling connection pooling for performance improvement - #17733
- Bug Fixes:
- Fixed issue where creating connection with connection string would fail - #17737
- Fixed issue where Copy actions wouldn't work on Data Grid cells - #17722
- Added missing DB Create syntax keyword colorization - #17732
- Improved connection description when selecting connection from quick pick - #17737
- Fixed authentication issue where user account could not be found in MSAL Cache in Linux - #17747
- Release date: June 5, 2023
- Release status: GA
- Performance improvement in Query Editor language service by enabling connection pooling (microsoft/azuredatastudio#22970)
- Fixed an issue where hyphenated user accounts failed to login to Azure SQL Server (microsoft/azuredatastudio#23210)
- Release date: May 24, 2023
- Release status: GA
- Added support for Linux ARM64 runtime - #17639
- Use preferred username instead of email for Azure accounts - #17606
- Removed prompt to select tenant when SQL Auth Provider is enabled - #17611
- Updated msal-node npm package to v1.16.0 - #17605
- Bug Fixes
- Release date: March 22, 2023
- Release status: GA
- Upgraded AAD Azure account management to support MSAL authentication.
- Added native MacOS and Windows arm64 support - #17614
- Added "Group by Schema" to Object Explorer - #17543
- Add Object Explorer connection timeout setting - #17548
- Accessibility Fixes
- Screen Reader is not reading the full information related to the database name - #17204
- After pressing tab key from "More actions" keyboard focus is going to bottom status bar instead of going to the "messages" dropdown - #17192
- Message window does not expand and collapse with the help of keyboard and shortcut key - #1687
- Release date: January 25, 2023
- Release status: GA
- BREAKING CHANGE - Connection Encryption is now Enabled by Default - #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
- Fix function syntax highlighting including non-function keywords #17462
- Match "other" keywords last - #17464
- Syntax Update (Mostly from SQL 2022) - #17465
- Add SELECT ALL and FULL/NATURAL JOIN syntax to grammar - #17508
- Special thank you to https://github.com/hanohrs for their help with this!
- Release date: August 24, 2022
- Release status: GA
- Added support for creating Azure Functions with SQL Bindings from Views in the Object Explorer
- Fixed issues with Integrated authentication in Unix environments #17333
- Release date: June 15, 2022
- Release status: GA
- Add support for dependent extensions
- Fixed issues
- Release date: May 20, 2022
- Release status: GA
- Adds extension APIs for managing Azure resources
- Release date: April 22, 2022
- Release status: GA
- Fix regression in Object Explorer that causes timeouts expanding the Tables folder. microsoft/azuredatastudio#19166
- Release date: April 20, 2022
- Release status: GA
- 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. #17267 - Fixed error with heirarchyID data type in results pane. microsoft/sqltoolsservice#1450
- Release date: February 24, 2022
- Release status: GA
- 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 #17221
- Release date: December 15, 2021
- Release status: GA
- Fix AAD token refresh bugs
- Fix Azure SQL DB connectivity bug
- Add support for SELECT * column expansion
- Add Untrusted Workspace support
- Release date: November 17, 2021
- Release status: GA
- Hotfix for credential keychain prompt on VS Code startup #17064
- Release date: October 27, 2021
- Release status: GA
- 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
- Release date: January 20, 2021
- Release status: GA
- Fixed bug in AAD support causing Integrated Auth connections to fail
- Release date: December 10, 2020
- Release status: GA
- 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
- @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…
- Release date: March 5, 2020
- Release status: GA
- 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
- @sukano for
fix string highlighting containing escaped characters (#1630) - @testingcan for
added create and drop snippets for views (#1215)
- Release date: December 16, 2019
- Release status: GA
- 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
We would like to thank all our users who raised issues.
- Release date: November 11, 2019
- Release status: GA
- Fix missing row count and dropped Object Explorer connections bugs
- Release date: October 17, 2019
- Release status: GA
- 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
We would like to thank all our users who raised issues.
- Release date: April 22, 2019
- Release status: GA
- 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
We would like to thank all our users who raised issues.
- Release date: March 22, 2019
- Release status: GA
- 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
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)
- Release date: June 28, 2018
- Release status: GA
- 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
- Note that this option is false by default because it may cause high memory usage.
- If you use this option and have feedback on it please share it on our GitHub page.
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:
- @ChristianGrimberg for adding support for Deepin Linux
- @nschonni for closing issue #704 by adding a new TSQL formatter issue template
- 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.
- Release date: April 10, 2018
- Release status: GA
- 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
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.
- Release date: December 11, 2017
- Release status: GA
- 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 Nsyntax. - 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.
- 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.
- Release date: November 8, 2017
- Release status: GA
- 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.
- Release date: September 22, 2017
- Release status: GA
- 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 fileaction or click on theMSSQLstatus 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 Statementwhere it did not handle 2 statements on a single line correctly. - Improved support for SQL Server 2017 syntax by refreshing IntelliSense and SMO dependencies.
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.
- Release date: July 18, 2017
- Release status: GA
- 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:
sqlGetSpaceUsedshows space used by tables. Thanks to Rodolfo Gaspar for this contribution!sqlListColumnsshows columns for tables matching aLIKEquery. 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.enableIntelliSensewas set tofalse. - 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.showBatchTimetotrue. - 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.
- Release date: May 2, 2017
- Release status: GA
- 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 Languagecommand 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 Definitionsupport #769
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 Excelfeature - 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.
- Release date: March 1, 2017
- Release status: Public Preview
- 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 inmssql.formatand change any of the options
- To format a .sql file, right-click and choose
Refresh Intellisense Cachecommand added. This will rebuild the intellisense for a connected database to include any recent schema changesNew Querycommand 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.
- Release date: February 2, 2017
- Release status: Public Preview
- HotFix for issue #669 "Results Panel not Refreshing Automatically". This issue impacts users on VSCode 1.9.0 or greater.
- Release date: December, 2016
- Release status: Public Preview
- Peek Definition and Go To Definition support for Tables, Views and Stored Procedures. For a query such as
select * from dbo.Personyou can right-click ondbo.Personand see it as aCREATE TABLEscript. - 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.
- Release date: Nov 16, 2016
- Release status: Public Preview
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.
-
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.
Report issues to Github Issue Tracker and provide your feedback.
-
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.
-
For Mac OS, see OpenSSL requirement on macOS
-
For Windows 8.1, Windows Server 2012 or lower, see Windows 10 Universal C Runtime requirement
-