>> If you've been doing data for awhile,
you know for sure the SQL Management Studio.
But for about four years now
there's a new tools coming up and there's a little bit of
a whole lot tons of questions and today with me I
have Erin will answer all those questions.
Hi Erin, so there's so many things,
different tools and everything.
Can you help us demystify the identity of Azure Data Studio?
>> I can, and I assume you're asking because you've
used SQL Server Management Studio or
SSMS and you know about Azure Data Studio.
Just for a refresher,
for folks who may not or who just want a little reminder.
This is Management Studio and Management Studio
is a tool that has been
around since the release of SQL Server
2005 so at this point where a good,
like it's almost a legal adults in the United States.
We've had SSMS for so long and the thing about SSMS,
Number 1, it's not going anywhere.
For those of you who are like what's happening,
rest assured, we're not getting rid
of SQL Server Management Studio.
But for folks who are new to SQL,
new to Azure, coming into
Management Studio and understanding
where they need to go and what they need to do.
This UI right here can be a little bit overwhelming.
Like I've got all my databases here, I've got security,
I've got server objects,
I've got replication and let me just zoom in here.
I can't make SSMS bigger automatically,
but I need to open up,
zoom it in order for us to see that,
so hold on one second,
let me get that going so that you can understand.
This is one of the challenges working with SSMS quite frankly.
Is that if I wanted to look at something a little bit more detail,
I'd have to change
my resolution on my screen to make that a little bit bigger,
mess around with it and for some folks that's
really frustrating, which I get.
But once I have zoom it opened. There we go.
I can come in here and now we can see,
in a little bit more detail.
All of this stuff and all this stuff is great,
particularly for a lot of folks who are managing SQL On-prem.
You have the agent, you have SSIS in here.
We've got management which expands out to maintenance plans.
We've got high availability, we've got replication.
But for some folks,
this is just a lot and they don't need
all of that so for those cases,
Azure Data Studio is a
little bit easier and notice that with Azure Data Studio,
I can just do a quick Control
plus here and I can zoom in that way,
so depending on the Big GA. As an aside,
is native dark mode.
You can look at Azure Data Studio on a light mode,
but you can also put it into dark mode.
All you have to do is go into File, go into Preferences,
and then you have this color theme and you can
change how your appearance is within Azure Data Studio.
I still haven't answered your question though.
>> It's already there. Like one big check for me
was like Data Studio is
not there to replace the other one is complete.
As a developer, I see that as like the big Visual Studio,
like the visuals to ID and Visual Studio code.
That's the same thing like sometime you need a smaller tool to
just Hack-and-Slash and like
sometime you need the bigger one and also,
I'm assuming this one when you install it on your machine is much
lighter than the big studio manager.
>> It is, so fun facts for those who may not know,
when you install Management Studio.
It's 18 something in higher build, 18.6,
we install Azure Data Studio with Management Studio
so for those of you running a later build a management Studio,
you have Azure Data Studio already,
but it is more lightweight.
The benefits here really for Azure Data Studio are lightweight.
It's modern and it is extensible,
meaning because it has a smaller footprint.
The way that we get the additional
functionality is through extensions,
just like in VS Code,
but it is also cross platform so SSMS is Windows only.
Yes, for those folks who are running Linux or Mac,
as well as Windows,
you can use Azure Data Studio,
so those are some of the biggest benefits as well as
this interface is a little bit slimmed
down and so for folks who are new to Azure,
new to SQL, it's less overwhelming to hop in here.
>> Yeah, it's true. I like that because it's true
like you need to learn one tool.
I'm switching between Windows and Linux often and
now I need to learn just one tool and I
could have it on each platform and extension,
I love that because depending on the projects,
you just extend what you need and you keep
your solution thin and light.
>> Exactly. We have folks who use VS Code,
well a lot of developers love VS Code and that's great and VS Code
is really about developing and it is not very UI centric,
it's pretty much Command Line.
Azure Data Studio is actually a fork of
VS Code and so that's why it looks very similar.
Folks who've used VS Code are
familiar with Azure Data Studio, which is great.
But Azure Data Studio is data centric,
so you can still do your projects in here.
You can still do development in here.
But this is much more about the data piece, your SQL database,
or if you're using Mongo or you're using MySQL, our post-classic,
we have extensions for that so this would be
the place to go for things that you're doing related to data.
>> Excellent. I know there's also an extension for Gusto.
>> There is, yes.
>> I used that recently.
>> Actually I had started doing
that in the web and then I was like,
oh, we have an extended for that.
I can just do it right, and Azure Data Studio.
>> Wonderful. I love it.
Now we know in a bit more about
the identity was it the nitrogen crisis.
Like I'm guessing there was a lot of questions.
>> There have been yes,
identity crisis I think is a perfect word for it,
because Azure Data Studio came out
and we were talking about doing operational tasks and then we
had some pivots and we focused a lot on notebooks
and and other things and
now we're coming back and were like listen,
there are some operational things that we really need
to folks to be able to do with an Azure Data Studio,
so I don't think we have time to talk about that today.
Maybe we could talk about
our road-map down the road and I can share what's coming.
>> You know what? I love the idea.
We'll have you back and we'll continue to
learn about Azure Data Studio. Thank you.
>> Thank you. [MUSIC]