SQL Operations Studio Adopts VS Code Extension Model

The extension model introduced with Visual Studio Code and subsequently tracked by the Visual Studio IDE is proving so popular it has been applied to SQL Operations Studio.

Still in preview, SQL Operations Studio, which was introduced last year, is an open source, cross-platform data management tool that works with SQL Server, Azure SQL Database and Azure SQL Data Warehouse from Windows, macOS and Linux machines.

Unveiled at Microsoft's Connect() conference last November, the open source tool just received its fourth update, with a new extension manager included in a bevy of updates.

Extension Manager
[Click on image for larger view.] Extension Manager (source: Microsoft).

As with VS Code and Visual Studio, extensions will be the primary method used by data developers and others to add functionality to SQL Operations Studio. "We've adopted the in-product extension management experience from Visual Studio Code," Microsoft said in a blog post last week. Like the code editor, the tool's extension UI includes:

  • A "Marketplace" of Recommend Extensions, which can be easily discovered and installed
  • A List of Installed Extensions, which can be disabled or uninstalled
  • An Extension Details page that displays the extensions readme content and other metadata

Microsoft said extensibility of the tool is a key focus of the dev team, which plans to make future features available both via first-party and third-party extensions. "We look forward to working with the community to build a rich tools ecosystem," Microsoft said. "Please contact us on Gitter if you're interested in building an extension."

For extension developers, Microsoft noted that because the core SQL Operations Studio platform is built on VS Code, most of the VS Code extensibility APIs are available. More on that is available in the documentation titled "Getting Started with SQL Operations Studio Extensibility."

Other new features coming in the March update include:

  • Enhancement of the Manage Dashboard extensibility model to support tabbed Insights and Configuration panes
  • Dashboard Insights extensions for sp_whoisactive from and a Server Reports example
  • Addition of additional Extensibility APIs for connection and objectexplorer management
  • Community Localization opened up for 10 languages
  • More fixes of important customer-impacting GitHub issues

Full details are provided in the release notes.

About the Author

David Ramel is an editor and writer for Converge360.

comments powered by Disqus


  • GitHub Copilot for Azure Gets Preview Glitches

    This reporter, recently accepted to preview GitHub Copilot for Azure, has thus far found the tool to be, well, glitchy.

  • New .NET 9 Templates for Blazor Hybrid, .NET MAUI

    Microsoft's fifth preview of .NET 9 nods at AI development while also introducing new templates for some of the more popular project types, including Blazor Hybrid and .NET MAUI.

  • What's Next for ASP.NET Core and Blazor

    Since its inception as an intriguing experiment in leveraging WebAssembly to enable dynamic web development with C#, Blazor has evolved into a mature, fully featured framework. Integral to the ASP.NET Core ecosystem, Blazor offers developers a unique combination of server-side rendering and rich client-side interactivity.

  • Nearest Centroid Classification for Numeric Data Using C#

    Here's a complete end-to-end demo of what Dr. James McCaffrey of Microsoft Research says is arguably the simplest possible classification technique.

  • .NET MAUI in VS Code Goes GA

    Visual Studio Code's .NET MAUI workload, which evolves the former Xamarin.Forms mobile-centric framework by adding support for creating desktop applications, has reached general availability.

Subscribe on YouTube