>> SQL Server 2022 is now generally available.
Join us for the kickoff of this series to learn all about
the capabilities in SQL Server 2020 to this week on Data Exposed.
>> [MUSIC].
>> Hi, I'm Anna Hoffman,
and welcome to this episode of Data Exposed.
We are excited to be joined by Bob Ward.
Bob, thanks so much for joining us.
>> Yeah.
>> Today we're going to be talking about SQL Server
2022 some super-exciting news.
Bob, you want to break the news to everyone?
>> Well, you mean the fact that it's finally generally available.
Yeah, that would be an exciting news to break. Yeah. Exactly.
>> Well, we're excited. We're going to be
kicking off a new series for
SQL Server 2022 starting now.
Bob, I want to pass it over to you.
Tell us about SQL Server 2022.
>> When the journey started actually almost like a year ago we
dense the private preview of SQL Server 2022.
Many people don't know that the project name
is the city you see right here. Dallas.
>> Dallas?
>> Dallas. Yes. Yeah. Back in 19,
I got the great honor of naming
the project after a city where I live.
Dallas, Texas also might want to get caught.
My colleague Bob door,
who works in the SQL team as well,
both of us from Dallas.
Yeah, project Dallas is the code name
and it's finally great to see this thing finally launch.
>> Awesome we're excited to
see it launch excited to have it on the show.
What's in 2022?
>> Yeah. First of all,
one thing I need to make sure everybody understands,
what we're going to talk about 2022. Well, here's why.
There's so many customers that are on releases before SQL 16 and
don't realize all the things that happen in
these great releases coming up to SQL Server 2022.
In addition, some of the things that we've built in
the product are based on foundations of things we've already done,
like Query Store and PolyBase and intelligent query processing.
The first thing is really important to know
is what do you get when you upgrade from, say,
SQL 2012 or something like that to go to 2022,
you'd all this goodness,
but you get more.
Let's talk about it. I think
the greatest way to talk about 2022
to start with is like, why would you do this?
What is the value proposition?
We've connected now to Azure in
ways never even dreamed possible before.
With disaster recovery and analytics and security,
we're going to talk about that.
We're going to dive into those in some future episodes as well.
But the engine is heart of some of the things
we do in security is so important.
Look at this chart right here.
You know, we didn't make up this chart.
We're the least the most secure database
in the history of the last decade according to NIST organization.
But we're including functionality like ledger for SQL Server,
a blockchain built into the product.
You'll see that in future episodes in date exposed.
In addition, we want to make sure people know that
the benchmarks are still very important for
us and we think in the industry
to show a standard of SQL performance.
I'm proud to announce that we've recently in partnership with HPE,
just announced some new benchmarks for 2022.
But also, we're going to talk about built-in query intelligence,
which is getting you faster with no code
changes as part of the engine just built into the product.
Don't forget, this is an edge to Cloud Storage,
SQl Server 2022 as part of SQL edge to Cloud,
whether it be running on IoT devices
or in technologies like arc or in the public Cloud.
Overall, I think what we're providing as
the overall value of why you would
want to upgrade is pretty powerful.
>> Got it.
>> Yeah. But you were with me on the road in 2019.
I remember this talking about SQL lights.
I had the slides like my camera slide where I
showed like the major features of the product.
Anna, this is the wheel of power.
>> The wheel of power.
>> Everyone IT at my camera.
>> I invented this exactly, yeah.
Seriously, if you want to go figure out like what are
the major categories of the product, you look at it this way.
We talked about Cloud-connected.
We're talking about connecting to things like
Managed Instance or Synapse or purview.
Then you think about built-in query intelligence,
enhancing the Query Store for query tuning,
using the Query Store to get faster with no code changes,
all built in the query processor.
Then the meat and potatoes, [inaudible] potatoes.
It's security, scalability,
and availability and you'll see
some great functionality we put into the product in these areas.
But also we're taking
that data virtualization concept like PolyBase.
We continue enhance that technology as well.
We're going to light up things like Parquet files, data lakes,
S3 compatible storage providers,
things that we've never tried
before to use SQL Server as a data hub.
Also, we still care about the T-SQL language.
The T-SQL language is very important part of this product.
We've enhanced out in
some very core ways to help new developer scenarios.
Yeah, there's a wheel of power and you'll
take a quick photo on that real quick.
>> There's a lot here and from what I understand in this series,
we're going to break down all of these capabilities.
You're going to show us some demos. This is just the beginning.
>> Yeah, look for us in the future series to take each one of
these and break it apart a little bit and
show you what those capabilities look like.
>> Awesome.
>> But I thought would be important to know a couple of things
about the release that have not been known yet.
>> Sure.
>> Because we're doing preview for almost like a year now.
Starts with, how do you deploy SQL Server?
Here's the great news, it's just like it was before. Windows GUI.
Yeah, it just works. Windows GUI,
command-line, GUI interfaces,
command lines, package managers for Linux,
we have new Linux distributions.
We're supporting a new versions of these distributions.
Containers are still a big part of
the SQL 2022 stories and of course,
the marketplace images in Azure VM.
It's important to know that supported operating system,
the latest Windows supported
operating systems will work with SQL Server.
I love this story.
Your upgrade options that you had before are the same.
Did you know you can take a SQL 2005 database
even and restore it to SQL Server 2022 to upgrade?
>> Really?
>> Yeah.
>> It'll just work?
>> It'll just work it built out.
Then we are still supporting dbcompat as
a big option to help mitigate any risk for upgrades.
So the new compat level 160,
you'll see that show up in
future episodes where that's going to
light up some new functionality.
But we're going to support older dbcompat versus all the way
back to like dbcompat from 2008.
Yeah, if you're upgrading from older releases a SQL,
you bring it into SQL Server,
whether it's in-place or database for store,
will support those dbcompat options and then
was still support things like side-by-side installations.
For the SQL heads out there,
this will be very familiar to them and know that it's
that same feeling of deploying as they've had in the past.
>> [inaudible] We talked about deploying.
The next thing is setup.
>> If you're setting up the product,
what does that actually look like?
Well, there's a lot of
things going on and set up there a little bit different.
What are some things we've actually removed in the product?
Now, it's not that this is necessarily a bad thing,
but when you go into setup,
there are some things you won't see that you
used to see before, for example,
PolyBase connectivity is not there,
but doesn't mean the PolyBase features not there.
It's just the old Java way of
connecting the Hadoop's no longer available.
But we've got some new stuff. That's the cool part.
Example, inside SQL setup,
you can connect to Azure now.
Have you ever heard of this thing called
Azure Arc enabled SQL Server?
Yeah, you heard about that. You can do it now
inside SQL setup itself. Oh, wow.
>> You just log in?
>> You log in with your Azure login or use the service principle.
Now your SQL Server,
whether it's running on-premises or
Multi-Cloud, is connected to Azure.
That's going to light up some stuff for you.
Here's one of the things that's going to light up.
It's pretty interesting. Pay as you go
licensing now for SQL Server, have you heard of that?
>> I mean, I'm familiar with the concept with Azure,
but how does that work with SQL Server?
>> Yeah, that's pretty interesting.
Notice here in SQL setup,
if you select this option,
you can pick standard or enterprise.
You set up an Arc-enabled SQL Server to set up.
What we're going to do now is allow you a flexible licensing.
You can use your normal SQL licenses if you'd like,
or you can select this option and now you're going to
pay while you connect an Azure,
a hourly or monthly rate to Bill and think about
these scenarios like retail spikes
and business at holiday shopping,
you build it on Azure before.
Now you can do that SQL Server on-premises.
You can set up that SQL Server and say,
oh, I'd like to just for this month,
have a SQL deployed and just pay for
that month and not have to use your existing licenses to do it.
>> Awesome. Pretty cool.
>> I know.
>> I'm going to be excited.
>> We're going to [inaudible] a little bit on this because I think
people have tried to find ways to
do flexible licensing in their environment for
so pretty excited to see this land. Yeah, pretty cool.
The other thing is additions in it.
Up until this point in preview,
we never talked about the editions
of SQL Server at what features go on them.
Excited today to show you what is in
the various edition feature matrix
like Express, Standard and Enterprise.
It looked at even an Express
which is a free version of SQL Server.
You even get things like purview,
AD Authentication nature in there.
You can do a block chain and a free version of SQL Server.
Then if you go to standard, we're
still trying to make sure we support
the concept of the surface area being the same.
But if you go over to like enterprise,
this is we're going to light up some things that feel
enterprise like degree of parallelism, feedback, e.g.
or a contained availability group, things of that nature.
I'm excited to see this matrix because we're,
we're trying to keep the idea that
express has value for customers.
Standard has that same surface area,
maybe some limitations resource wise enterprise
being that full feature set.
Of course, don't forget developer additions free.
Still the same developer edition you know, and love today.
>> Awesome, cool.
>> Here's the summary. If you think about it,
remember back to our will power.
Azure enabled with all this great functionality,
built-in query intelligence, meat and potatoes of the engine.
Data virtualization that we're offering now.
And then T-SQL enhancements sprinkled with addition matrix.
All the new edition features
pay-as-you-go licensing connecting ourself to Azure.
It's one of the most power-packed versions
of SQL Server I think we've ever released.
>> Wow, this really exciting. There's a lot to come.
We're going to fall along this series,
but most people get started.
>> We've built a lot of
resources for you and there's a lot to see right here.
I think you guys have maybe can give resources to the audience.
Let me pick out a couple of you didn't maybe know about,
the deck you're seeing today in the deck you'll see on
the future versions of our series
will be here on this website here,
SQL Server 2022 decks.
Anna, you know what, I read another book.
I was like, I'm tired of their books, so yeah,
I just release SQL Server 2022 reveal, which is now available.
That's a huge deep dive.
My wife was commenting that it's 475 pages,
so it's not light reading.
But it's a nice book to deep dive.
Then we have a new workshop,
just like we did in the past with SQL 19, with Azure SQL,
we have a workshop on GitHub available for you to go on and do
self-study examples, death, the whole things there.
We're doing that in person and some events.
Then also of course, date exposed.
You know, we'd love the series that we're doing on here.
We have Microsoft Mechanics videos as well.
Then I'm proud also announced
a new Microsoft learning path with
the Microsoft Learn team for SQL 2022.
So lots of resources for you to cut out,
study more, and learn about the great relief for doing.
>> Awesome, cool Bob,
thanks so much for coming on the show.
To our viewers, thanks for tuning in.
We're going to keep this going.
We got lots of episodes planned in this series,
so be sure to check the description for links to learn
more and we hope to see you next time on Data Exposed.
>> [MUSIC]