>> We've talked a lot about
the different Azure SQL deployment options
and the SQL server options.
But what are all the offerings from SQL from Edge to Cloud?
Learn more in this episode of Data Exposed.
[MUSIC].
>> Hi, I'm Anna Hoffman,
and welcome to this episode of Data Exposed.
Today I'm joined by Bob Ward,
a Principal Architect on the Azure Data team.
Thanks for joining us today, Bob.
>> Hi, Anna. Thanks for having me today.
Pretty excited to be on your show.
You're a celebrity now with this Data Exposed show.
It's about time I finally showed up on this thing.
>> I don't know about that. But we're really
excited to have you on the show.
>> Yeah.
>> Today we are going to be talking about
Azure SQL from Edge to Cloud,
and that's a big span of places to be.
Before we get into that, I just wanted to ask you, Bob,
can you share with us a little bit of the history of
SQL and how we got to where we are today?
>> Sure. Anna, I got a surprise for you.
Right here on camera in front of you,
there's these things that you don't know what they're called.
They're called diskette.
They were actually made before you were born.
Actually these four things right here in
1993 is what I was handed when I joined Microsoft,
and this is how you installed SQL Server on OS/2,
SQL Server 1.1 on OS/2.
SQL was a departmental server back in those days.
But we had an amazing group of people that decided,
quite frankly with the backing of people like Bill Gates,
to make this an amazing product,
and that journey of SQL Server versions just kept growing,
and growing, and growing,
and we got this reputation for ease of use, low cost.
Then we just started really knocking out of the park when it comes
to making this really an enterprise class product.
Quite frankly, if you think about SQL as a modern platform today,
it's a real force in the industry.
>> Thanks Bob. As we've gone through the years,
we've even gone to Azure SQL,
newer versions of SQL Server.
But I've even heard about this idea of
IoT with the idea of running Azure SQL,
SQL Server on the Edge.
Is that true? Can you tell us a little more about that?
>> Sure, Anna. I've brought to you a pitcher today.
I'm going to paint a picture of a where everywhere SQL
lives and if it's going to be from SQL Edge to the Cloud,
it's starts with Azure SQL Edge,
which we announced this past May at Build.
This is SQL Server running on a footprint Anna,
small enough to run on a drone,
or on a robot or small device.
>> Wow.
>> But it is the power of the SQL Server engine,
allowing us to do processing at the IoT Edge itself.
But it concludes with some amazing technology
like built-in streaming,
machine-learning, data retention, all those type things.
Azure SQL Edge is the SQL Server Core engine,
but we're just trying to front a way to bring
that processing power down to where the IoT device lends itself.
Now, last year, in 2019,
we announced the latest version of SQL Server,
SQL Server 2019 with all sorts of
amazing functionality like intelligent query processing,
accelerated database recovery,
amazing data virtualization capabilities,
along with this technology called a big data cluster,
where we are going to take SQL Server and
run a complete analytics platform
running on Power BI Kubernetes but
integrated where we even install a Hadoop cluster with SQL.
SQL Server 2019 is a powerful release for us last November.
People are still talking about it,
asking me a lot of questions about how do
I take advantage of SQL 19.
SQL 19 is going to run wherever you need it, right?
It could be in the Cloud, it could be on your datacenter,
it could be on Windows,
or if you look to the right here,
it could be SQL Server on Linux.
A lot of people running SQL 19 run this on Windows,
but a lot of people still ask me and don't even
know we've got a full version
of SQL Server on Linux that we started the journey and SQL 17.
That runs on all your favorite distributions,
Ubuntu, SUSE and Red Hat.
Well along that journey we brought containers into the fold.
Now SQL Server running in a container environment.
Giving that amazing simplified deployment experience
is a very popular way to run SQL Server.
Then if you're going to run containers, how you do at scale,
we support SQL Server running on Kubernetes,
and SQL Server Big Data Cluster is an example of doing that.
If you look across the top right here,
you've got the Edge and now you're into
your datacenter where you're going to run SQL 19 on Windows,
SQL Server on Linux,
SQL Server containers, or in Kubernetes.
At the bottom of this screen in my picture I'm painting for you,
we'll talk about Azure SQL.
Anna, you and I have spent a lot of time talking about
Azure SQL over the last several months,
and from left to right, it starts with running
SQL Server on Azure virtual machines.
This is where you have access to
the complete control of the guest operating system.
You pick your SQL Server version,
you pick your operating system type,
Windows versions, Linux versions.
You control the guest OS.
We will manage the infrastructure though.
That's why it's called infrastructure as a service.
We will own the host, we will own the storage,
the networking, and you just bolt into that.
We're going to give you some advantages for running in the Cloud.
We're going to give you managed backups,
we're going to give you automated security updates,
and a very integrated experience to run
performance through Azure Storage.
If you move from left to right though in the Azure SQL family,
you have something called an Azure SQL Managed Instance.
This is where you don't care about the operating system.
You don't care about the virtual machine,
in fact you want us to manage, all of those things.
You just want a SQL Server Instance,
and you want those surface level features
like SQL Server Agent or database mail or Broker,
but you want platform as
a service capabilities like automated HADR.
You want SLAs, you want
a very simplified deployment experience
and we give that with Managed Instance.
The little icon to the right is something
called a Managed Instance pool.
Where you can have much more dense version of these instances.
What's going to get you a very simplified,
lower core options, even
faster deployment and configuration experience.
At the far right is your most managed offering
for Azure SQL called Azure SQL database,
where now you have choices of
elastic pools, Hyperscale, serverless.
This is, you just worry about the database.
You don't even worry about the instance
behind the scenes of SQL Server.
We manage all of that.
Think of the idea of a contained database
and that is what you deal with.
Again, you want those paths capabilities.
You want simplified deployment.
You want automated built-in HADR.
You want even things like automatic tuning,
we can help you manage indexes.
That's Azure SQL database.
Now, if you think about these two worlds, your world on top,
your on-premises world at the bottom,
our Azure SQL world,
how do you meet in the middle?
We've introduced this year,
two announcements of services called Azure Arc.
Now arc not being a circle,
a half circle, arc being a way to arc between two worlds.
You have Azure Arc-enabled SQL Server,
where you can run Azure services in
your datacenter with your existing deployment of SQL Server,
connect to the Azure world and get things like
Advanced Threat Protection type services or
integration with other Azure resources in the Azure portal.
Then there's Azure Arc Data Services where
we're going to give you the Managed Instance concept,
more of like what you see in the Azure SQL Cloud,
more of that passed I capability.
But you see here I've got the Kubernetes symbol.
This is where we're going to use the power of Kubernetes to build
a complete platform in your environment where you run,
but again, give you that feeling of Azure SQL.
Now if you look across all of this, this is overwhelming,
but look at all the different places where SQL now exists,
whether it be in your datacenter,
in the Cloud or hybrid environments.
I'm sure you want some commonality here.
If you think about languages,
the popular T-SQL language runs across all of this,
and you want machine-learning.
Python and R with things like
SQL machine learning services also exist across these properties.
What about tools used using
Management Studio or maybe are new tool Azure Data Studio.
All of these tools connect across anything you see on the screen.
It gives you that same experience used from a tool perspective.
Then finally, I've got this question a lot.
Is this the same SQL Server running in every one of these icons?
Anna, it is the same SQL Server engine that comes with security,
performance and availability, which
is the meat and potatoes of SQL Server.
It is the same core engine running,
whether it's the Edge or in the Cloud,
or even in Azure Arc.
This is an amazing transformation of
a departmental server that ran in a bunch of
diskettes many years ago,
now to quite frankly Anna,
a force in the industry,
and it is SQL Edge to the Cloud.
>> Thanks Bob. I think this was a great overview of
not only all the different offerings that we have as a team,
as a SQL team and as a SQL organization,
but also the commonality that you
see between each of these deployment options.
We talked about this a little bit,
how it's just SQL and I think that's
a really big advantage to
this scene that you've
painted for us and I really like this picture.
I think it was probably the fastest what to use when,
but it was very clear to me.
I appreciate that.
If viewers want to learn more,
what would you say? Where should they start?
>> Yeah, it's hard to start, right?
There's so much stuff to choose. What should I do?
If you think just about Azure SQL itself on the bottom there,
you and I have spent quite a few months doing a lot
of content in the form factor you want to learn with.
Azure SQL Fundamentals on Microsoft Learn,
Azure SQL for beginners on YouTube,
or even our very popular GitHub site called akr.ms.sqlworkshops.
It literally has training on anything you see here on the screen.
We have a lot of different places where you can go
and find more information about anything we're seeing here,
and it's just going to get bigger and better Anna.
We're going to continue to build content,
and I love the way you phrased it.
We're going to build content to
make sure you understand how to run
SQL in a specific form factor where you need it.
But we're always going to give it that common thread
of it's just SQL,
that's the SQL language.
It's the database engine you know and love,
built and run best in the environment where you need it.
>> Awesome. Well, thanks so much for being on the show, Bob.
I know, I appreciated it.
I'm sure our viewers did as well.
For our viewers, if you liked this video,
please like this video,
leave us some sort of comment,
and we hope to see you next time on Data Exposed.
[MUSIC]