Press "Enter" to skip to content

Category: Azure Data Studio

April Tools Day

Published 2023-04-03 by Kevin Feasel

Erin Stellato dispels some myths:

Myth #1 Azure Data Studio is the only standalone solution now that SSMS is deprecated.

SQL Server Management Studio (SSMS) is not deprecated.  We thought about writing that in ALL CAPS, but figured bold is sufficient.  SSMS has not been deprecated, and we are not planning on deprecating it.  You will see new functionality being added to Azure Data Studio, but we have a fair number of things lined up for SSMS, including migration to the Visual Studio 2022 shell, which brings 64-bit support.

Bold plus all caps might have been a bit too much, yeah.

Click through to see what’s happening in the world of SQL Server tooling from Microsoft.

Comments closed

Azure Data Studio 1.42 Released

Published 2023-03-23 by Kevin Feasel

Erin Stellato shows off what’s new in Azure Data Studio:

I just finished writing up the release notes for Azure Data Studio 1.42, and I cannot get over the amount of work the engineering team has completed since January.  Go big or go home.

For regular users of Azure Data Studio, we hope you are starting to experience the improvements we have been making in the application.  This continues with the 1.42 release, though we also found time to introduce new functionality as well. 

Read on for some of the highlights.

Comments closed

Working with Remote Jupyter Books in Azure Data Studio

Published 2023-03-17 by Kevin Feasel

Steve Hughes reaches across the internet:

When working with Azure Data Studio and its support of Jupyter books, you will find there is an option for remote Jupyter books. As shown in the image below, you can open that Jupyter book and follow through the dialogue for a couple of Microsoft books that are readily available.

Click through to see how this option differs from standard Jupyter books (which are themselves different from Jupyter notebooks) and how you can create one.

Comments closed

Azure Data Studio 1.41 Now Available

Published 2023-01-26 by Kevin Feasel

Erin Stellato has a bundle of updates for us:

The query results window got a fair bit of attention this release as we work through the backlog of open issues. First, we introduced a new configuration option to show or hide the action bar in the query results view. The Query Editor > Results: Show Action Bar option can be found in the command palette (CTRL + , ) if you type Show Action Bar. By default, the action bar is shown in the query results pane, as seen in the screenshot below:

Check out the full set of changes in the article.

Comments closed

Table Designer and Query Plan Viewer in Azure Data Studio

Published 2022-11-21 by Kevin Feasel

Erin Stellato announces two features in GA for Azure Data Studio:

Azure Data Studio provides users with the ability to complete operational tasks such as deploying a database, creating tables, and writing queries.  A logical next step for many users is troubleshooting or improving query performance, a task that is now easier with the general availability of Query Plan Viewer.  From the query editor, you now have the ability to display the estimated or actual plan for a query or set of queries.  This graphical plan provides a visual map to understand the steps the SQL Server engine takes when it retrieves or modifies data.  Saved plans can also be viewed in Azure Data Studio, and for enhanced troubleshooting, two plans can be compared to understand differences and more easily identify problems. 

The lack of a good execution plan viewing tool was a major limitation in Azure Data Studio (and the SQL Sentry plugin wasn’t a good fix even when it was available).

Comments closed

Azure Data Studio November Update

Published 2022-11-21 by Kevin Feasel

Timi Oshin and Erin Stellato have an update for us:

In this release of Azure Data Studio, we have exciting news to share across several of our core features and extensions. The first is the announcement of the general availability of Table Designer and Query Plan Viewer. We would like to extend a huge thank you to our engineering teams who have worked tirelessly over the past few months on improvements to these features. We would also like to thank the MVPs and community members who provided feedback on these features. We are grateful for continued engagement from users as we work to make Azure Data Studio the tool of choice for cloud database management across multiple platforms.

There’s a lot in this release, so check out the full changelog.

Comments closed

Creating a SQL Server Assessment Dashboard

Published 2022-10-18 by Kevin Feasel

Robert Blackburn builds a dashboard:

We must periodically evaluate the state of our databases. Luckily for SQL Server, Microsoft provides us with a customizable assessment through their SQL Assessment API Repo and API Documentation. You can change the rules per database and output the results to a database to track history.

However, that will take more than an hour. Let’s create a dashboard with the default rules in under an hour. We will use Azure Data Studio (ADS) and Power BI Desktop (PBI). If you are not familiar with them, both are free. Azure Data Studio is automatically installed with SSMS 18.7 and higher. You can also install them individually.

Read on to see how this works. Granted, it will not auto-update but unless the assessment output format changes between runs, at least you wouldn’t need to modify Power BI and could just refresh the data.

Comments closed

Deploying an Arc-Enabled SQL Managed Instance

Published 2022-09-12 by Kevin Feasel

Warwick Rudd continues a series on Azure Arc-enabled data services:

Now that we have our Azure Arc-enabled Data Controller configured and available, we can now deploy our first Arc-enabled SQL Managed Instance into our environment. As previously mentioned depending on the type of configuration required for your environment with your Arc-enabled Data Controller (Directly connected or Indirectly connected modes) this will dictate the approach available for you to setup / configure your Arc-enabled SQL Managed Instance.

Click through for a step-by-step guide.

Comments closed