Press "Enter" to skip to content

Category: Visual Studio Code

VS Code Extension for Availability Group Read-Only Routing

Denny Cherry announces an extension:


Microsoft introduced Read-Only Routing to Always On Availability Groups many versions of SQL Server ago. However, Microsoft never added any sort of UI to SQL Server Management Studio. Years ago, DCAC released a Windows application to manage your Read-Only Routing configuration. We’ve converted our Windows application into a VS Code extension called SQL Always On Read-Only Routing Configuration, which you can download from the website or via VS Code.

Click through to learn a bit more about the extension. You can also view it in the VS Code Marketplace.

Leave a Comment

The Final Month of Azure Data Studio

Rebecca Lewis plays a funeral dirge:

Azure Data Studio retires on February 28, 2026. No more updates, no more security patches, no more support. Microsoft announced this a year ago and has been pointing everyone toward VS Code with the MSSQL extension ever since.

Sounds straightforward. Install VS Code, add an extension, and carry on. Yet it is not really that simple, and it depends a lot on how you used ADS.

I appreciate that Rebecca has a table of functionality, including what is available right now and what is not yet ready. I remember trying the VS Code MSSQL extension early on and realizing just how much work they had to do, and it looks like they’ve done a good amount of that work. Running on Linux, I was always a proponent of Azure Data Studio, even when it was SQL Operations Studio and you had a messy bundle of files to install manually (I was one of the very early beta testers).

The good news is that I do believe the SQL Server tools team will continue development on this. The success of non-SSMS tools has been hit or miss, but having a multi-OS, developer-friendly way to interact with SQL Server is important.

1 Comment

Microsoft Fabric Extension for VS Code now GA

Sunitha Muthukrishna announces an update to an extension:

Manage Fabric items programmatically: Use item definitions to unlock scripting and work with your items as files. You can update and deploy Fabric items to existing workspaces or new workspaces directly from VS Code—saving you time and effort. Fabric items, that have Item definitions API support, support this capability.

Read on to see what else made the cut.

Comments closed

Migrating Azure Data Studio SQL Notebooks to VS Code Polyglot Notebooks

Haroon Ashraf gives us a somewhat unwieldy process:

As a SQL/BI developer, I want to run and store my SQL scripts and documentation efficiently in a Notebook as an alternative to using Azure Data Studio SQL Notebooks since Azure Data Studio is retiring soon. Read on to learn more about Visual Studio Code Polyglot Notebooks.

I liked the simplicity of having a SQL kernel in Azure Data Studio. Haroon shows how to work around it and get to roughly the same spot, but I do hope the SQL Server tools team is able to migrate that SQL kernel over to VS Code prior to Azure Data Studio’s ultimate demise.

Comments closed