A Fine Slice Of SQL Server
In this video, I show off a not-so-well-known capability in Visual Studio Code and Azure Data Studio: creating profiles.
Profiles are very useful in Visual Studio Code, though probably less useful for Azure Data Studio. I think the primary benefit to that would be handling things like zoom levels and menu layouts when you switch from a laptop on the go to something plugged into a larger monitor.
Comments closedMy company is moving from an Azure PostgreSQL single server to a flexible server. We want to set up managed identity/Entra access instead of having roles with passwords for every person/app. In particular, we want to use Entra groups.
Read on for some notes on why, as well as how to use Entra ID groups for management and some of the rough edges that remain.
Comments closedJosephine Bush packs up and moves down the road:
I wanted to migrate some connections without recreating them and wondered how to do that in Azure Data Studio. It turns out to be easy. I post about whatever I’m working on, and here’s a short one for you today.
Read on to see how to do this on Windows and MacOS. But that leaves the most critical question: what about on Linux?
Linux follows the same pattern as Windows: File –> Preferences –> Settings, and then Data –> Connection.
Comments closedErik Darling makes an observation:
I was quite publicly mystified by the coupling of Azure Data Studio into the SQL Server Management Studio installer. They’re different tools for different people.
This isn’t a tirade against Azure Data Studio, nor is it a victory lap since apparently the feedback item I posted was part of the decision to remove it.
This is purely informational, since the announcement that it’s not in there anymore is nearly as quiet as the announcement that it was being included back in SQL Server Management Studio 18.7, and only slightly louder than the availability of a command line switch to skip installing it.
I say this as someone whose primary SQL tool is Azure Data Studio: good. There’s a lot of functionality overlap between the two but it’s better making both of them optional.
Also, I’m subscribed to that same RSS feed Erik mentioned and fully agree with Erik’s assessment of Erin. Even if she is a Michigan fan.
Comments closedDavid Levy gives us the latest:
The February release of Azure Data Studio (version 1.48) includes several new features and enhancements, such as:
- Support for restores from URLs, including S3-compatible storage, via the restore dialog
- Query Editor now includes SPIDs in tab titles
- You can now specify a connection when launching ADS from the command line
- You can now enable Ledger when creating a database in the Create Database dialog
Read on for more about each of these topics.
Comments closedBarney Lawrence fixes a problem in Azure Data Studio:
This is a solution to a bug I’ve encountered in Azure Data Studio when trying to create new connections. that leads to an error message of cannot create property ‘groupid’ on string ‘.File this post under “things I couldn’t find a neat answer to in Google so I figure I’d best create a page for it”.
Read on for Barney’s answer as I lament how far downhill Google has gone as a search engine.
Comments closedI know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS).
Click through to see the normal workflow in SQL Server Management Studio, followed by the workflow in Azure Data Studio. I’d also recommend, at some point, finding good extended events sessions and saving the T-SQL to create them.
Comments closedJosephine Bush needs to import a file:
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to import data from flat files – yay!
I’ve used this extension a few times in the past on Linux and Windows and it’s pretty good, especially if you have a fairly straightforward flat file. If it’s a messy file, you’ll still get inscrutable errors. And, as far as data sources go, GIGO.
Comments closedSomething that a lot of people don’t know is, you can import some Visual Studio Code extensions into Azure Data Studio and have them work.
I emphasize the word “some” here because I have seen cases of extensions failing to install. I don’t know exactly why certain extensions fail or what percentage of them will work, so give it a whirl and see what you get.
Comments closedDavid Levy announces a new release of Azure Data Studio:
Another change that is sure to be noticed is that we have enabled parallel message processing by default. This change will improve the performance of the application when connected to SQL Server data sources. We have introduced two new settings to manage this new behavior. The first setting, Mssql: Parallel Message Processing is set to true by default. The other setting, Mssql: Parallel Message Processing Limit, has a default of 100. This setting controls the number of threads used for parallel processing. We are excited to hear your impressions on the impact of this change.
Read on for the full list of changes.
Comments closed