Category: Azure Data Studio

Anjali Agarwal and Laura Jiang announce a new product:

The release of the Azure Data Studio extension generator is now available. Install the generator through npm and get started with extension development with these Azure Data Studio extension tutorials.

The Azure Data Studio extension generator is a command line tool designed to help extension authors get started with the process of extension development. It includes extension templates that enable users to create and publish extensions with minimal technical knowledge required. In our most recent release, we have added three highly requested extension templates to the generator.

Anything which helps make extension development easier is fine by me.

Kevin Chant offers some insights for us:

One of the options within the SQL database Projects extension is that you can publish your project to another SQL Server database. Of course, this is only for one database.

So, what do you do if you want to update multiple databases with one project? Well one option is to create a dacpac from your project and use that dacpac to update multiple databases.

You have a couple of options if you wish to do this.

Read on for some helpful tips.

Alan Yu announces the most recent set of changes around Azure Data Studio:

The notebooks viewlet in Azure Data Studio now includes a dynamic search experience. When you are dealing with hundreds of notebooks, it can be tricky navigating and finding the notebook you need. With this experience, we make it faster to search through notebook content.

Once notebooks are listed in the Notebooks viewlet, users can easily search for content across all notebooks and see how many instances the search term appears in a certain notebook. You can then interact with the notebook.

It’s a notebook-heavy month.

Wolfgang Strasser takes the database project extension for a spin:

There is currently one requirement to start your database project development in ADS, it is that you need the Insider build of ADS (that you can download here). After the installation, you’ll need to install the extension. Please search for it in the list of extensions and install it in your ADS instance.

Tom Norman and I talked about it in detail on last night’s episode of Shop Talk (to be posted later today). It’s a good start, but there are still some rough edges and missing functionality. I’d expect that to improve over time, though.

Randolph West vouches for some Azure Data Studio extensions:

It’s worth mentioning that for the most part Azure Data Studio extensions are extremely lightweight, both in download size and memory usage. Installing this many on SQL Server Management Studio (SSMS) would slow it down dramatically.

Note: not all extensions can be installed from the Extensions pane. For many of them you must visit a website, download the VSIX file and install it manually using the File > Install Extension from VSIX Package menu option. In most cases you can trust extensions from reputable publishers, but always take care.

Randolph has quite a few more extensions than I do, but I can’t say any of those are a bad choice.

Alan Yu announces this month’s changes to Azure Data Studio:

The key highlights to cover this month include:

– Feature tour.
– Notebooks enhancements.
– Drag and Drop Tables in Query Editor.
– Azure Account icon added to Activity Bar.
– Insiders Build highlights.
– Bug fixes.

Read on for the set of changes.