>> I just burped up my nachos.
Really amazing. I should've got those
giant like bootleg Margarita.
>> Oh my goodness.
>> Make me feel so good.
>> And you start gone to New Orleans and looking
for those beads tornado.
>> Hurricane.
>> This I'd be so much more fun. Just record this.
[MUSIC]
>> Hi, I'm Burke Holland.
>> I'm Julie Lerman.
>>This is five ways that you can interact with data
from your favorite editor, Vs Code.
[MUSIC].
>> Thing number one is the Azure Cosmos DB extension for VS Code.
Now this is an extension that I know I love.
I use it all the time.
What exactly does it do?
>> The extension lets you connect to
an Azure Cosmos database in Azure and see all of your databases,
all of your collections, your documents.
You can edit documents.
You can create documents.
So, you can really see it.
Now, there is the document explorer in
Azure portal which is also wonderful and awesome.
But if you're working in Visual Studio Code
and you want to see something about your data,
you can just open it up and look at it right there.
>> Yap. That's true and fun facts about that extension.
Because Cosmos DB supports the MongoDB API,
you can use that extension to connect to
any Mongo DB database not just Cosmos DB.
So, even if you're using MongoDB,
check out the Azure Cosmos DB extension
because you can use that to
query and manage your data all without ever leaving VS Code.
Because why would you want to leave.
>> Who want to leave Visual Studio Code.
>> I don't ever want to leave.
I want to die there.
[MUSIC]
>> Thing number two is the SQLITE extension for VS Code.
Now this is interesting. I had no idea that there
even was a SQLITE extension for VS Code.
>> Neither did I.
It's brand new.
Well, it's been around maybe for a little while,
but I'd been hoping somebody would
create one and used Postgres one.
But anytime I was using SQLITE on Mac OS,
I have to use a bigger tool or specialized tool just
to look at the data because they want to see what I created.
So, it's just nice to know somebody from
the community created this Extension.
It's out there. It's just SQLITE VS Code dash SQLITE,
I think [inaudible].
>> Yes. So, check that out. I know a lot of people using SQLITE.
I don't know a lot about SQLITE but it is- I guess it's a sort of
a cross-platform very lightweight datastore.
>> Open source.
>> That you can use with your application.
So, it's kind of like Microsoft Access.
>> No, not really.
>> See, it's not all like Microsoft Access, just that.
>> Good winging it.
>> Good recovery. I could do this all day.
Thing number three is something called Azure Data Studio.
Now, Julie, I thought we were
telling the nice people about Extension for VS Code,
and now we're talking about
what is this and how does this relate to VS Code.
>> Originally the SQL Server team created an extension for
Visual Studio Code called the MSSQL
Extension and I've been using that and really loved it.
Then what they did was they pulled it out and created
their own spawn of Visual Studio Code that
takes Visual Studio Code and just does the data access in there.
So, it interacts with the all variations of SQL Server databases.
It was originally called SQL Operations Studio,
but they changed the name to Azure Data Studio.
So, I'm hoping that eventually
it will be more than just interacting with SQL Server.
>> So, more databases?
>> Yes.
>> So, I've downloaded this recently.
You should check it out. It's fantastic.
Especially, if you're not on Windows,
because SQL Management Studio on Windows is wonderful.
But if you're on a different operating system,
you're just left high and dry.
This one looks like VS Code.
So, when you open it, you'll swear,
you'll be like this looks familiar.
>> And it has the source control.
So, you can maintain files.
>> It got all Visual aspects.
You can look at the tree,
you can execute queries,
you get the IntelliSense online.
>> Snippets.
>> Right. All of the code [inaudible].
>> Also access to a CLI, access to terminal.
So you could be doing some CLI stuff.
Maybe you're using an MSSQL command line
or just using some command line tool.
So, it's a very similar experience to using Visual Studio Code,
and if you know how to use Visual Studio Code,
you know how to use this.
You know how to work with the settings.
>> Yes. That's Azure Data Studio.
You should check that out and you've got an article on MSDN.
>> It just came out a couple of days ago [inaudible].
>> That'll be in the notes for the show.
You can check that link out.
Thing number four.
We talked about Azure Data Studio.
One of the things that it does is quite
interesting, something called profiling.
Tell us a little bit about that.
>> Well, the profiling actually is an extension.
So, the same way Visual Studio Code has the whole ecosystem with
extensions, so do Azure Data Studio.
So, the SQL Server team wrote
this extension that does database profiling.
So, like SQL Profiler.
I've used SQL Profiler all the time on my Windows machine.
But when I'm on my Mac and working with my databases,
it's not something I can use, there's no tool.
>> Right, there's no equivalent.
>> So, they've actually now created an extension.
It's in preview right now.
But they've created an extension that you can profile
the work that you're doing or
what's just what's happening in the database.
There's all different kinds of ways to do it.
>> So, it's a cool extension.
I actually don't use profiling.
What I do is I execute the query and then when it never returns,
I just call the DBA and ask them to fix it.
Also a perfect solution to your problems.
>> Actually, for your scenario that's probably the best path.
>> Best thing to do. Burke, don't
mess with the SQL. Let somebody else do it.
>> Yes.
>> Thing number five is
the Flat File Importer extension for Azure Data Studio.
Now, this one is interesting to me because anybody who has
ever tried to import a flat file into a database,
knows that that is a nightmare. It's terrible.
>> And you can use any foul language to describe that.
>> I feel like I did very well.
>> Yes. It is always a lot more work than you ever wanted to be or
expect it to be because you have to
tell how many columns there are,
what the format is,
what the schema is, all this stuff.
So, what's amazing about this,
it's like it uses Artificial Intelligence and it's something
that's kind of a bigger thing
that's being developed in SQL Server,
but they're taking advantage of it in the extension.
>> So, that's how hard importing a flat file is.
>> You need AI.
>> We need to have AI.
These are problems that we're solving with
AI, importing flat files.
>> But- but it's amazing, right?
>> It's amazing. So, that's a cool extension and you could
be able to import a flat file without using exploitative.
>> Your brain.
>> Yes or your brain all right [inaudible].
>> I don't do AI, I'm not AI.
>> Me neither.
>> Really it's a really cool what it does and it can
do CSV files, JSON files.
Now that's flat files.
So not like JSON
hierarchical files or anything like that. Maybe some day.
>> Right.
>> So, it's just in preview,
I was working with early bits with early version.
I actually got a chance to get on Skype with
the team and show them
things that I was doing because I was banging on it.
And it wasn't doing things the way I thought it would
be and they took notes and make changes. So, that was cool.
>> Awesome. So, that is
the Flat File Importer Extension for Azure Data
Studio complete with Artificial Intelligence to actually
get your flat file imported. I'm Burke Holland.
>> I'm still Julie Lerman.
>> Yap and now, you know five different ways
that you can work with data inside of Visual Studio Code.
>> And its spine.
>> Azure Data Studio.
>> All right.
>> Perfect.
[MUSIC].
>> My people, I love you both so much, bring it in.
>> You are the best Burke.
>> Thank you Keylan.
>> You really are.
>> Thank you Julie.