>> Microsoft Build happened recently and we
released a ton of announcements on all things Microsoft,
but especially in the Azure SQL and Azure SQL Database space.
In this episode, you'll learn about all the latest updates,
including things related to Data API builder,
elastic pools for Hyperscale,
and Copilot support in Azure Data Studio,
learn all about it and see
some great demos and more this week on Data Exposed.
[MUSIC]
>> Hi, I'm Anna Hoffman,
and welcome to this episode of Data Exposed.
Today we have a super exciting episode.
I always say that, I really mean it
this time because we're going to be talking
about all of the updates for
Azure SQL that happened at Microsoft Build.
We had a bunch of sessions at Microsoft Build.
Some people were in person,
some people were online,
some people were probably both, but today,
I'm bringing on some wonderful friends from the product group,
bringing on Muazma, Drew, and Davide.
We are going to talk about the latest announcements.
We're going to recap what happened at Build.
We're going to show you some exciting demos,
and tell you where you can go to learn more.
Without further ado, I'm going to
share with you the updates that we
had at Microsoft Build in the Azure SQL Database space.
Lots of exciting things here.
I'm really excited about all of them, to be honest.
I'm going to ask Muazma,
what are your favorite things on this list?
Or what are some things that you feel like
we should make sure viewers know about?
>> Thank you, Anna. There's so much on
this slide to cover, but my favorite,
definitely about DG announcements that
we have around the Hyperscale point-in-time recovery.
We have some amazing announcements in terms of
the public preview of Data API Builder.
Some of the great announcements in
the migration space that you can read on
the offline migration as well as the migration journey planning.
My most favorite is definitely the new adjacent time,
which is in private preview so please watch for the sessions and
the call for action if you want to test that out. Thank you.
>> Awesome. Thanks, Muazma.
I definitely agree those are great things.
Another thing I want to highlight is
elastic pools for Hyperscale is really cool.
We're bringing all of the things together in this one tier
of Hyperscale, which is super exciting.
Davide actually had a session,
actually all three of you were there in person.
But Davide, you had a session,
and I'd love to hear some of the things that
you're working on and maybe if you can show us anything.
>> Thanks, Anna. Here's the news from my side,
Data API builder, it's been around for a couple of months now,
and we got a lot of good feedback.
If you're wondering what Data API builder is,
well, I can explain in a few minutes,
just make sure that you had to Azure,
select Data API builder on GitHub because this is open source.
What Data API builder allows you to do is take
your Azure SQL Database and turn it into an API.
I [inaudible] Graphical API,
so your developers can be super easily
and efficient in accessing the data.
I just have demo ready so let me show you.
First of all, let's start from the table I have.
I have a series table and the books table,
as you can see here,
I have information about the books I like and
the series to which these books belongs to,
and I want my developers to build a very nice front end
to make me able to search the books, share with others.
Besically manage my elite library.
What I would normally have to do after
creating the table is writing a lot of
code to make the current operation
available as a resto or graphical import.
Pagination, filtering, sorting,
selection, and also even taking care about the authentication.
Well Data API builder makes everything super easy.
I just need to initialize the Data API builder,
which basically create a configuration file.
Then I can do dab add.
Let's say I want to add the series table here.
As you can see, I'm just adding
the series table plus other information.
Make sure that in this case anyone can access it.
Then I also want to add my book table.
Again, same, I'm adding my book object here in
exposing it and once I have done that.
The only thing actually admit for support shorter
now at this configuration file here.
I can sample do dab config in configuration files,
just JSON file that contains
all the information needed to correctly exposed the objects.
Now the only thing I have to do is dab Start and that's it.
In just a few seconds you receive that now I
have the server listening on this sport, I can click.
Then I will be brought in
this case with my GraphQL editor because also
chosen to expose a GraphQL endpoint
so I can create a new document.
Apply, go here and say I want to query,
let's say my books.
I won't have all my books,
for example the tittle,
and the ID and the page number.
Here we go. I have the books.
Of course I can filter before I can create new books,
but I don't know how much time did I took?
Let's say one minute. That's efficient way
to expose data and make it API.
Now that's what I have to share with you
about the Data API builder. Hope you like it.
>> Awesome Davide. That is super course so people can get
hands-on with that today if they just head over to GitHub.
That is awesome.
I'm sure people wanted to learn more about this.
For viewers you can also see the full session. This is [inaudible].
>> Exactly. there is a full session on that I just delivered.
Just make sure you check it out.
It connect social Data API builder with
all the other cool feature that you are
announcing and presenting today,
so it's very nice to see everything working together.
>> Awesome, cool. Thanks so much Davide.
That's just a quick glimpse at the Azure SQL database updates.
This is where a lot of our updates landed,
but I did want to mention there
was one update for Azure SQL Managed.
It sends that a lot of people will be excited about.
This is ledger support in
public preview is bringing the power of Blockchain
to Azure SQL managed
instance databases without adding any extra costs.
Go check this out today.
Then finally, but certainly not least,
I brought Drew on.
Drew, always great to have you on the show.
Can you tell us what is going on in the tool space?
>> Thanks Anna. In addition to the Azure SQL bindings,
Azure functions integration going GA,
we have a lot of cool things going into Azure Data Studio.
For developers like you saw with Davide who worked with tables and
then build on top of it using something like
Data API builder or Azure functions,
you might be in an interface like Azure Data Studio.
It's great to see some of the new improvements coming into it,
like the branching by schema or now a preview for the dialogue
when you want to add new users
to improve the security of your application.
But last but not least,
is the addition of Copilot integration into Azure Data Studio.
I've got a table here with the address information.
If I want to write a query that grabs
city and postal code by the state.
Let me just ask Copilot to help me write an index on that query.
It's going to say what is that?
We will get SQL generated for us.
I didn't have to go look that up or try to remember it,
but Copilot was able to help me out in building that index.
If you're starting from scratch even so let's just say I need to
create a table when the columns,
I don't like those columns.
Let me do order total.
I'm going to create a table here that's for orders.
I know that I wanted to relate it to my customer table,
and I've got some column ideas that I want to use.
Let me just start writing my create table.
Let Copilot think about it.
It's generating an orders table for me.
It's doing the foreign key,
it's doing the primary key,
and it's even starting to pick out some data types for me.
With all of that Copilot is able to
help me build my database faster
and which is as great as a developer
if I've got tools like Data API builder.
Now I can also use Azure Data Studio
to develop faster through Copilot.
>> Wow, that is so cool.
We've been hearing a lot about Copilot,
but it's great to see how it applies in
Azure Data Studio today that
people can go try this out and take advantage of it.
Like you said, build apps faster.
Drew, thanks so much for sharing this with us
folks just have to go get the latest built of Azure Data Studio.
>> Exactly. Go grab the latest release
1.43 of Azure Data studio and you're all set to go.
>> Awesome, cool, thanks so much Drew, Davide, Muazma.
This has been a jam-packed episode.
We talked about all the announcements and we've
really only skimmed the surface on those announcements.
I'm going to put some links in the description for you to go
to our Azure SQL blog where you can read all
about all the different announcements if one
picked your interest or if you want to learn how
to get hands-on with things like
Data API builder or co-pilot in Azure Data Studio,
we hope you check it out.
That's all for our show today.
If you like this episode, go ahead and give it a like,
leave as a comment and let us know
your favorite announcement and we hope
to see you next time on Data Exposed.
[MUSIC]