We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
Azure Data Studio versus SQL Server Management Studio
Microsoft have brought out a new SQL editor called Azure Data Studio, to act as a substitute for SQL Server Management Studio, but this owl cannot see any justification for its existence!

Posted by Andy Brown on 16 January 2020

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Azure Data Studio versus SQL Server Management Studio

Microsoft have released a new SQL editor, called Azure Data Studio (ADS); it was initially called SQL Operations Studio, apparently.  ADS runs on Windows, Macs and Linux, which as far as I can see is it's only real raison d'être.

Apart from anything else, I can't see what the Azure Data Studio program which runs on your desktop has to do with the Microsoft cloud-based Azure platform.

ADS and SSMS compared

ADS is a free download, and looks like this:

Azure Data Studio

Users of SSMS will recognise this!

Here's the equivalent diagram in SSMS:

SSMS equivalent

The same query in Management Studio.

New save options in ADS

You can save the results of running a query to more places in ADS:

Save options

On the right-hand side of the screen are these icons, allowing you to save your results to a CSV file, Excel file, JSON file, XML file or chart.

 

I wouldn't get too excited about the chart option:

Charting in ADS

This feature is so primitive, it's hard to believe anyone will find it useful!

Visual Studio extensions

As the diagram above suggests, you can install a host of Visual Studio extensions.  Here are a few of them:

Visual Studio extensions

You can choose to use another language (I noticed Korean listed when I scrolled down, for example), or a different SQL dialect such as Postgres.

SQL code snippets

The best thing about ADS is that you can create snippets.  For example, suppose you want to select some data but can't remember the command.  Type in the SQL prefix to see this:

Code snippets

ADS shows snippets for all of the main things you can do in SQL.

Now double-click on the option shown to get this:

-- Select rows from a Table or View '[TableOrViewName]' in schema '[dbo]'

SELECT * FROM [dbo].[TableOrViewName]

WHERE

-- add search conditions here

GO

I can see that this could be useful!

Conclusion

I like the code snippets in ADS, but wonder why Microsoft couldn't just have added them into Management Studio.  I don't really see the point of releasing a separate application designed to mimic the functionality of an existing program, but with less features.

I'm not the first person to wonder this, as this Reddit thread shows.  Azure Data Studio is - as far as I can see - a pale echo of an existing program which works perfectly well as it is.  Microsoft's rationale is to create a lightweight (it only takes up about 400 mb) program for people who just write queries, which will run on any operating system, but it still feels like a project looking for a justification to me! 

This blog has 0 threads Add post