A Fine Slice Of SQL Server
Erin Stellato has an update for us:
We’re rolling towards conference season and the Azure Data Studio engineers have been working hard on two things:
- adding new functionality
- improving stability and performance within the application
Read on to see what they’ve pushed out with Azure Data Studio 1.46.
Comments closedErin Stellato gives us an update:
In this release we updated to VS Code version 1.79.2, from version 1.70, bringing ADS nearly current with VS Code. Keeping up with VS Code is an artifact of Azure Data Studio being a fork of VS Code, and the team accomplished a major feat with this latest merge. Many of the changes are not immediately obvious to users, but there are improvements across security, performance, and the application interface.
Read on for the highlights.
Comments closedErin Stellato has an update for us:
It seems like just last week we were just releasing Azure Data Studio 1.43 (oh wait, that was last month) and here we are announcing Azure Data Studio 1.44!
This release comes in the midst of Microsoft Build, where numerous Copilot-adjacent announcements have been shared for different applications. We are excited to announce that the GitHub Copilot extension is now available in the extension gallery with the Azure Data Studio 1.44 release! For complete details and some examples, please see Drew’s post, Introducing GitHub Copilot for Azure Data Studio.
Click through for what’s new.
Comments closedErin 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 closedErin 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 closedSteve 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 closedErin 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 closedDeborah Melkin reviews the logs:
I don’t remember the search criteria, but I did stumble upon this page, Azure Data Studio Troubleshooting
As I read through this, I hit the section about Debug log location. I remember that I had a problem installing something on Azure Data Studio last summer and someone at Microsoft had helped me by pointing me to the log files.
Read on for the full story.
Comments closedChad Callihan tries out schema comparison in Azure Data Studio:
Do you need a tool for comparing database schemas? Azure Data Studio can be your answer. Let’s walk through using Azure Data Studio’s Schema Compare extension.
Read on for an overview of the product.
Comments closedErin 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