Release 1.42.2

Version 1.42.2

• Release date: May 4, 2026
• Release status: GA

What's new in 1.42.2

• Fixed an issue where the extension may not launch for some users in proxy or offline environments

Release 1.42.1

Version 1.42.1

• Release date: April 28, 2026
• Release status: GA

What's new in 1.42.1

• Fixed an issue where the Object Explorer Filter dialog sometimes would not render immediately
• Fixed an issue where the platform-specific VSIX files for offline installation (posted on the GitHub releases page) would not be able to launch on macOS. Installations from the VS Code marketplace were unaffected.

Release 1.42.0

Version 1.42.0

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

What's new in 1.42.0

• Released Backup Database, Restore Database, Flat File Import, Create/Rename/Drop Database, Global Search, and Query Profiler dialogs as generally available (GA)
• Added Active Directory Default authentication support in the Connection Dialog, enabling passwordless authentication using the currently signed-in Windows identity
• Added the ability to use VS Code accounts for Microsoft Entra ID MFA authentication (preview). Enable by setting either mssql.enableExperimentalFeatures or mssql.preview.useVscodeAccountsForEntraMFA. Users will need to re-sign into Microsoft Entra ID accounts that existing connections use for authentication.
• Improved the Connection Dialog to distinguish between editing an existing connection and creating a new one, with the ability to modify connection parameters and test the connection before saving
• Optimized Microsoft Entra ID sign-in flows to reduce repeated authentication prompts.
• Added a new background task panel in the SQL Server activity bar to display active and completed deployment tasks (SQL container provisioning, SQL database in Fabric deployments) with real-time progress
• Improved SQL Notebooks to display SQL Server error messages inline in cell output, improved cell output formatting and spacing, and set the MSSQL kernel as the default when creating a new notebook
• Fixed several Query Results Grid issues with VECTOR, JSON, and XML data types including incorrect rendering as hyperlinks and values
• Improved SQL Database Projects with a documentation menu option, automatic folder creation for new objects, correct schema name in templates, and a projectGuid update prompt
• Improved first-time setup speed and reliability by packaging the required components directly with the extension instead of downloading them at first-launch.
• Fixed a long-standing issue that could cause the extension to freeze or become unresponsive while running queries.

Release 1.41.0

Version 1.41.0

• Release date: March 18, 2026
• Release status: GA

What's new in 1.41.0

• Added Data API builder (Preview) support, enabling users to create REST, GraphQL, and MCP endpoints for SQL database tables from a visual interface within Visual Studio Code
• Added GitHub Copilot integration in Data API builder (Preview), allowing users to generate Data API builder configurations using natural language through GitHub Copilot chat and agent tools
• Added Code Analysis settings dialog (GA) for SQL Database Projects so developers can configure DacFx rules directly to enforce code quality standards in their database development workflow
• Added SQL Notebooks (Preview) support, allowing users to write and run SQL queries in native Visual Studio Code Jupyter notebooks with interactive results, sorting, filtering, and Markdown documentation
• Added support for Fabric databases to the Query Profiler (Preview)
• Released View & Edit Data as generally available (GA)
• Released Data-tier Application (DACPAC) dialog as generally available (GA)
• Released Microsoft Fabric integration as generally available (GA)
• Improved Object Explorer context menu organization and usability

Release 1.40.0

Version 1.40.0

• Release date: February 25, 2026
• Release status: GA

What's new in 1.40.0

• Added the Global Object Search dialog, enabling users to easily search for objects across their entire database
• Added Backup Database and Restore Database dialogs (both Preview) allowing users to back up locally or to URL, and to restore from database, .BAK file, or URL.
• Added Flat File Import dialog (Preview) allowing users to import data from CSV and TXT files
• Added Create, Rename, and Drop Database dialogs (Preview) enabling users to easily manage their databases
• Added Query Profiler (Preview) to support users in monitoring and analyzing their database performance
• Added support for SQL Server 2025 containers on ARM-based macOS devices
• Added the ability to import connection configuration settings from Azure Data Studio to the Migration Toolkit Dialog, and a MSSQL Data Management Keymap to add familiar shortcuts from Azure Data Studio
• Fixed several SQL Database Projects issues including Fabric SQL project database reference deletion, unresolved system database references, and tasks.json placement when creating a project in an existing workspace

Release 1.39.0

Version 1.39.0

• Release date: January 28, 2026
• Release status: GA

What’s new in 1.39.0

• Added the Azure Data Studio Migration Toolkit to help to import existing Azure Data Studio connections and connection groups into the MSSQL extension
• Enabled Table Explorer/Edit Data, Data-Tier Application Dialog, and Publish Project feature previews default
• Added workspace-level support for extension connections and connection groups
• Improved usability and fixed auto-run for Schema Compare
• Added support for copying and exporting data in Table Explorer/Edit Data
• Improved usability for deleting rows and undoing changes in Table Explorer/Edit Data
• Fixed issues in Query Editor and Language Service

Release 1.38.0

Version 1.38.0

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

What’s new in 1.38.0

• Improved the experience for deleting rows in Edit Data
• Updated the query results grid sorting and filter options
• Fixed an issue in the results grid where copying data may throw an error on Linux
• Updated GitHub Copilot integration to use user-friendly names when referring to connections
• Improved handling of improperly configured proxies that may interfere with MSSQL's operation
• Added ability to sign into multiple tenants and browse Azure SQL Managed Instances in the Connection Dialog
• Added ability to copy a connection profile's connection string directly from Object Explorer
• Enabled support for using the MSSQL extension in VS Code Virtual Workspaces
• Consolidated Linux distribution support to x64 and arm64
• Fixed issues in Edit Data where cells with invalid data could not be reverted and empty non-nullable cells would incorrectly display NULL
• Fixed an issue where the inMemoryDataProcessingThreshold setting was not getting followed
• Fixed an issue where modern UIs and the results grid may lag at initialization
• Fixed an issue in Schema Compare and the Publish SQL Project dialog where a loaded profile doesn't connect if it uses Microsoft Entra ID authentication

Thank you to @ghiscoding for contributing improvements to the Edit Data feature's use of SlickGrid React!

Release 1.37.1

Version 1.37.1

• Release date: December 2, 2025
• Release status: GA

What's new in 1.37.1

• Fixed flickering scrollbars issue happening in query results grid.

Release 1.37.0

Version 1.37.0

• Release date: November 18, 2025
• Release status: GA

What's new in 1.37.0

• Released general availability of GitHub Copilot integration, including Ask Mode, Agent Mode, Slash Commands, and a new onboarding experience, providing schema-aware exploration and scaffolding, query generation, explanations, optimization guidance, and contextual assistance based on your active database connection.
• Introduced Edit Data (Public Preview), an interactive grid for browsing, editing, adding, and deleting table data directly in the editor with real-time validation and script previews. Set mssql.enableExperimentalFeatures: true to enable.
• Introduced Data-tier Application dialog (Public Preview) to deploy and extract .dacpac files and import or export .bacpac packages through a modernized workflow inside VS Code. Set mssql.enableExperimentalFeatures: true to enable.
• Introduced Publish SQL Project dialog (Public Preview) to assist users in deploying a SQL Database project (.sqlproj) to existing database or to a new local SQL development container. Set mssql.enableExperimentalFeatures: true to enable.
• Added a "What's New" panel to highlight major updates, new features, learning resources, and onboarding tips.
• Added support for Microsoft Entra ID authentication to and browsing resources in Sovereign and Government clouds
• Fixed an issue where users may be prompted for reauthentication continually after a Microsoft Entra ID token has expired
• Fixed an issue where long-running queries could not be cancelled
• Fixed an issue where query result aggregations (count, sum, average) were not displaying when selecting rows or columns
• Improved rendering and stability of query results grid
• Improved keyboard accessibility for query results grid

Release 1.36.0

Version 1.36.0

• Release date: September 12, 2025
• Release status: GA

What’s new in 1.36.0

• Introduced Fabric Connectivity (Public Preview) to browse Fabric workspaces and connect to SQL databases or SQL analytics endpoints directly from the Connection dialog
• Introduced SQL database in Fabric provisioning (Public Preview) to create Fabric SQL databases from the Deployments page with capacity awareness and automatic connection on completion
• Added GitHub Copilot Slash Commands (Public Preview) providing quick chat shortcuts for connection management, schema exploration, and query tasks
• Enabled Schema Compare to be launched from external extensions and SQL Projects through a new run command, also used to support the Update Project From Database feature
• Improved query results performance and stability including incremental streaming, smoother tab switching without freezes, honoring mssql.persistQueryResultTabs setting, and preventing file‑close race conditions during execution
• Improved connection reliability when opening via VS Code URIs and resolved authentication issues, including preserving saved passwords after failed connections
• Fixed an issue where invalid Microsoft Entra ID account entries could result in no accounts or tenants appearing in the Connection dialog
• Fixed an issue where the Most Recently Used list saved the active database instead of <Default>