>> Learn about all the announcements
that happened at Microsoft Build,
including SQL Server 2022 public preview,
Azure SQL Database Ledger and a whole bunch of
developer updates this week on Data Exposed.
>> [MUSIC]
>> Hi, I'm Anna Hoffman and welcome to
this episode of Data Exposed.
Today, I'm joined by the famous Bob Ward.
Bob, thank you so much for coming on the show again.
>> Anna I'm so happy to be on your show.
I would say you're the more famous person,
I occasionally get invited.
I feel it's a privilege and honor whenever I get asked to
become on the famous Anna Hoffman's Data Exposed Show,
so it's great to be here today.
>> Well, we can agree to disagree on that one.
But we were excited to have you on the show.
We're coming off the world win of
Microsoft Build just wrapped up a couple of days ago.
What are your thoughts?
What are your reactions to build?
>> Build is such a great event for
so many years for Microsoft and for the developer community.
It's become more than just actually for the developer community,
and as we like to make announcements at things like Build.
Build's a great event,
these Microsoft events to make announcements,
and we certainly did that here.
For sure, made some really cool apps and in fact,
I would say I would call Build 2022 the aftermath of SQL.
It sounds like a movie, doesn't it?
>> The aftermath of SQL,
and what does that mean? Why do you call it that?
>> Well, it's just because
we had this momentum build up to this event,
and then we made some pretty big announcements, and so,
you are talking about the aftermath of those announcements.
>> I love it. For those who missed some of the big announcements,
they got a clue from the title of this episode,
but we're going to go through all of them,
get some more details,
tell folks how they can learn more.
Bob, when I think about Build,
one of the first things I noticed was
some announcement that Rohan made.
Can you share a little bit? What was he talking about?
>> Let's to it. Let's dive in and
talk about that some a little bit.
Aftermath for SQL, it just sounded catchy.
No, seriously, when you think about what we
do today with data for Azure Data.
Anna, you and I both work for the Azure Data Organization,
We work on all technologies.
I work on anything that's got the word SQL on it.
But think about these things.
Think about governance, about analytics, databases together,
people feel like this diagram
and we'll see those little fractured.
Rohan announced a new initiative for
Microsoft called the Microsoft Intelligent Data Platform,
and the idea is that can we bring the assets together,
we have an Azure data,
and give that seamless,
integrated feel for these three areas?
For databases, for analytics and governance,
and notice how they build on each other.
Operational databases can build on analytics.
Governance can be used to actually centrally control,
and give you lineage and give you
insights into what's going on for analytics and databases.
That's the idea, you're going to see a lot more
from Microsoft in the future about this name,
but the intelligent data platform
name and in fact, if you think about it,
think about the other Cloud services from Microsoft,
this platform can power all of that,
whether it's Dynamics, Microsoft 365 or the Empower Platform.
What you saw from Rohan was a taste
of what we're seeing here in the future,
a very integrated way and
an actual simpler way for people to use Azure data Cloud services.
>> No, I love it and like you said,
I think we'll all be looking forward to seeing what else comes
out of this new platform that we're talking about.
Now, of course, I want to jump into
the biggest announcement from the SQL Server side,
and that was SQL Server 2022 public preview.
Can you tell us about it and what it
means that for folks who didn't even know that what it is?
>> As you know Anna,
I've been working in SQL Server technology now for 29 years,
and any time I get to be involved in
announcements for what we're
doing in a release, it's pretty exciting.
It's pretty exciting internally to craft together the story.
It's obviously super exciting for
our customers to finally get their hands on something.
We started this journey for
this particular release of SQL Server last November,
making an announcement of a private preview,
and we've had the excitement there, obviously,
from many different customers of what this can provide.
But, everybody's like, "I want to download it.
I want to use it," so it's very exciting get a chance in
Rohan session and on my session to announce
the public preview of SQL Server 2022.
As you may have seen, if you watched me right out of the gate,
I said, "I'm sure you just want to download it."
Forget Bob's talking points.
I guess you should go get the bit,
so here's the link right here again Anna.
Get SQL Server 2022.
Just go to that link,
you'll be able to pull off
the evaluation edition of the Public Preview of SQL Server 2022,
we call that CTP 2.0 Community Technology Preview 2.0.
That's traditionally the number we use when we go public preview.
We've been in the CTP 1.X range ever since last November.
It's really cool to just be part of
this and get to see the excitement around.
I get see people finally downloading
it and giving us the feedback that we
need as we move into the rest of
this calendar year and eventually making it generally available.
>> Awesome. I know we probably lost half our viewers right then.
They just gone to the link and downloading it and they're
getting ready to play with it.
>> What are you saying? I'm going right now to download it.
>> To those that stuck around,
there's a lot of stuff in this already as a public preview,
what are some of the big things to do?
>> Well, I created this slide for you.
Here's my problem, I love everybody in their organization,
engineering organization and people ask me,
what's your favorite feature and
I'm lease somebody's out every time I do that.
This is not my top 10,
it's not ordered but as I went through and looked
at the public preview documentation we're putting together,
these are things that just stuck out for me.
Thinking about linking Synapse for SQL,
which is an announcement made by the way,
in build, not just linking Synapse for SQL Server 2022,
but also for Azure SQL Database.
There's very easy way of just seamlessly getting
data into analytics for Synapse,
that's a big part of it.
But here's one thing that I haven't talked
as much about during private preview,
and that's integrating Azure Arc during the setup process.
If you want to do Azure Active Directory,
if you want to do per view,
if you want to use that new Azure Arc enabled technology,
it's now in the SQL Server setup bit.
You go into the gooey, you put in your Azure information,
and now you're connected to Azure to light up some new scenario.
That's something that's landed,
it's brand new, people haven't
seen it even in the private previews.
Then of course, it goes without saying,
this whole built in query intelligence,
parameter sensitive plan optimization.
Anna, we have finally saved the world from parameter sniffing.
It's hard to believe that we've done that, but we have.
This DLP feedback, I haven't talked a lot about that as much,
but it's now part of this,
that's a really interesting one.
I've got some demos that I'm going to share with you at the end of
the session that I've built
for folks to start playing around these features,
that's an interesting one.
Then you start looking at this middle area of
the core engine SQL Ledger.
We made an announcement in Build for
SQL Ledger General Availability for Azure SQL Database,
and it's also part of the SQL Server Public Preview.
One of the things we showed as a demo
on build that we haven't really
focused as much on is this multiparty idea.
You've got a supply chain and you've got multiple parties,
there's no central authority for the supply chain,
but they need a centralized system,
they can all trust the data,
and that's what Ledger can provide.
We've such a more interesting scenarios
in our build demos for that.
Then system page latch concurrency,
that just sounds like a mouthful,
it sounds very technical, it's a technical product.
But here's the thing, it's maybe even
possible now with all the enhancements
we've done through SQL Server,
the last releases, and with this one to have a hands free TempDB.
Yes, that's true. Hands free TempDB, install SQL Server,
let us pick the defaults,
just use TempDB, don't configure anything
else that could be groundbreaking.
David Plus and I were chatting about
this over the last week or so.
I've got some demos to show that actually may be possible finally.
Then contained availability groups. Oh, my gosh.
We actually announced this a little
bit at SQL bits and we made some talks about it.
Didn't really hit the public news as much, but finally,
you can have availability group now in SQL Server
and your system instance objects like agent jobs,
logins, link servers can now be part of
the availability group and it's called container AGS.
Really exciting to see that one layer.
A lot of customers are asking for that for like a decade.
It's really cool to see that land.
Then TDS 8.0 this is interesting one.
Tabular data stream is the protocol that we have for
SQL Server for our communication between apps and SQL.
We have a new version of that
and the reason we have new versions is
for supporting new encryption techniques,
what we call strict connection encryption,
where it must be encrypted.
This also supports the latest version of TLS 1.3 and
some really interesting technology we built into
this to help avoid things like man in the middle attacks.
That one, it didn't get a lot of press during private preview,
but I want to call it out because it's
actually really cool technology.
Then S3 data virtualization,
this is becoming more and more of a popular thing,
people are using S3 object storage,
our partners pure storage,
Mineo, Dell has a solution,
all these partners have these solutions for S3.
We can now use poly base built into the engine to go
out to external tables and S3
and then even do native backup restore.
A lot of interest around this one.
Didn't get as much press when we
announced the private preview, but I want to call that out.
Then SSMS 19,
but why is it on your list for SQL Server 2022?
You and I great friend and colleague now Aaron Celotto,
Program Manager of this area has
really done an amazing job of really
looking at the Strategy for Management Studio and
there is a new preview release,
the version 19 that
we've launched here as part of our build announcement.
Look for that, that's going to be the preferred tool along with
Azure Data Studio to use for SQL 2022.
Of course, there's also
so much stuff we're putting into the product,
but these are just a few that they stood out for me.
>> No, awesome. There's definitely a lot on this list,
so thanks for sharing it with us
and sharing a little bit more about it.
For folks who've been following around
the SQL Server 2022 series that we've been doing,
we've done a couple episodes with
David Plus on some of these things,
so folks might want to check that out.
You mentioned SSMS 19 and aggregate a
studio and you mentioned also a
couple of things around Azure SQL database,
I love to know, what are we
doing this big movement around developers?
What are we doing for developers
when it comes to Azure SQL database?
>> Well, we look at it this way,
build is a conference for developers.
If you think about and look at the screen here,
these are challenges that we know developers face.
It says that I need to get seamless access
to data with the code I'm writing.
Azure database can be one of those databases,
but it feels clunky to get access and integrate it with the data,
and then I need DevOps,
I need to accelerate DevOps in new exciting ways.
We made several new announcements here,
so check this list out here.
Number 1 in public preview,
a local developer experience. What do I mean by that?
We've launched something called the Azure SQL Database Emulator.
Imagine you Anna as a developer on
your laptop using Visual Studio code,
you go in and build
an Azure SQL database application without being connected Azure.
Yes, I know. We're going to use the power of containers to
give you that local developer feel and our great friend Silvano,
who works on this, calls it the inner outer loop.
The inner loop being is that you
do local development on your laptop,
or you push changes to GitHub back and forth,
but you haven't even connected to Azure.
Then when you're ready,
using DevOps processes and CIC pipelines,
you push those changes into Azure database itself.
Or even supporting things like
GitHub code spaces where you can see that technology,
you're literally using GitHub
as a VM to do all your development work.
This is pretty cool technology,
we're just starting the journey here,
but literally is a local development experience
for Azure database developers.
Then look at the next one, Azure Functions SQL bindings.
Now, with Azure functions,
what people just love that technology we can do,
but easy binding,
that's the integration of data with those functions for
either input or output of your Azure SQL database information.
Before it was very clunky using
Azure functions to make all this work,
now as a developer,
Azure functions and Azure databases will feel like this to you.
Then we know JSON is super important,
so we have JSON functions that we've added into the product
to make JSON a much more integrated feel into the T-SQL language.
By the way, that works not only for Azure SQL database,
but that's also in SQL Server 2022.
A private preview for something
called HTTPS endpoints or rest endpoints,
this is a really interesting one.
You're a developer, you like the database,
you like doing server side programming,
but you want to take data from the database and
push it to a rest endpoint. Well, how do you do that today?
You can't, it's really hard to do.
You've actually built client code to make that work,
so now we're introducing a series of
SQL procedures for you to take
data that you can consume inside
the database and push that into a rest endpoint.
You may have seen in our build presentation,
my colleague Drew do some really interesting end to end
development scenarios showing all of this stuff together.
That new rest endpoint is a private preview.
Go look for that we have
a sign up where you can get involved in that program.
Then finally, as I mentioned, the general
availability of SQL Database Ledger,
that's for Azure SQL Database,
that includes things like Automatic Digest storage for you.
That's a very well integrated field for developer and of course,
Ledger being that tamper evidence technology using power of
Blockchain Inside SQL is
also in the public preview for SQL Server 2022.
Look at all these stuff,
they're just lots of announcements, right?
>> Yeah, there's definitely a lot here,
a lot in SQL Server 2022 as well.
As we wrap up, what's your advice?
Where should people start?
>> Lots of resources.
Get SQL Server 2022 we talked about that.
The next one, aks.ms/sqlserver2022,
that's our main web page,
it's like a central place for you to go and get
information about the release as we
move down this path towards general availability.
Of course, here's the link for data exposure.
We have a series we done with you,
we're going to continue doing that with you in this calendar year.
If you want to see that series, you go there.
Then I couldn't help but add this in here.
If super says, Bob's SQL demos,
why would it say Bob's SQL demos?
That's my GitHub repo but
I've got a little surprise for everybody.
In that repo is a folder called Demos and SQL Server 2022.
I've built about six or seven different scenarios
out there that you can go right
now and try with your public preview to
go see what is parameter sensitive plan optimization?
What is DOP feedback? What is SQL ledger?
If you want to try out what's this
TempDB thing he's talking about?
I've already built these things,
it's a pretty rough just step by step process,
not a full set blown workshop yet, hint.
But anyways, it's a set of labs you can go through to
see and just get your hands on immediately with SQL Server 2022.
Of course, we have a link here for set ups link for SQL,
if you want to go right to that technology either with
SQL Server or Azure SQL Database.
Then Azure SQL Database,
you go to this link to see all our new announcements.
Then the last one is interesting,
I didn't mention this is part of our announcement, Sunetra,
our great colleague in the preview team,
did a really slick demo for something
called Dynamic Lineage with Azure SQL.
Really interesting technology,
the ability to track changes and look at
dependencies across all your different types
of SQL programming assets.
Her demo that she showed was
really powerful because it's all about
the runtime analysis instead of static analysis.
If you've got some SQL code you need,
you'll certainly check out that technology as well.
>> Awesome, cool. Well, Bob,
it's always a pleasure to have you on the show.
Thanks so much for joining us.
To our viewers, thanks so much for joining us.
Go ahead and get hands on with SQL Server 2022,
check out some of these other great resources that Bob shared.
If you like this video, go ahead, give it a like,
leave us a comment, and let us know what
you think of all these build announcements.
We hope to see you next time on Data Exposed.
[MUSIC]