- Coming up we take a look at a new deployment option
for Azure SQL Database called Managed Instance.
Many of you have applications powered by SQL Server
and want to migrate and modernize with the cloud.
There are a class of applications
that have complex database environments
and require things like SQL CLR,
SQL Server Agent, and cross database queries.
In the past, these dependencies prevented you
from migrating to a managed PaaS service.
Well, the great news is that all of these and more,
are now supported
with the new Azure SQL DB Managed Instance.
That means you have access
to the most intelligent database service
with zero code changes and near 100% compatibility.
Let me show you how it works.
We'll start by creating a new Managed Instance in Azure.
In the portal, search for managed instance
as you normally would.
And give your service a name.
Select a subscription, region, performance level,
all the common parameters
when you're creating your database service.
Select Create,
and within minutes you can begin using your new service.
I've already created a new Managed Instance,
so let's migrate my application databases to Azure.
I have my Stack Overflow Enterprise
application deployed locally.
This is connected to two databases hosted
on SQL Server 2008 R2 in My Data Center,
and the application requires cross database joins
to render these views.
Let's migrate our databases
to Azure SQL DB Managed Instance.
I'm going to use the Database Migration Service.
I start by giving it the name
of my SQL Server 2008 R2 environment in My Data Center.
The service can also migrate
from other sources like Oracle, MySQL,
and any supported version of SQL Server.
I point it to the Azure SQL DB Managed Instance
that I created earlier.
I select the two databases I'd like to migrate,
and finally I point it to a temporary storage location.
The service will use this to store objects
during the migration.
And that's it.
We'll give our service a name,
and we're off to the Cloud.
The service will begin migrating my databases
to the new Azure SQL DB Managed Instance.
It will restore the databases and all dependent objects.
The database migration service
supports multiple scale models
from megabyte to terabyte size systems
with minimal down time.
We can click in and view the progress of my databases,
and you can see that in just a few seconds,
our databases have already completed the migration.
So let's return to our application.
Without making any other changes,
I'm going to point my application
to my Azure SQL DB Managed Instance,
and let's rerun our application.
In a just a few seconds we've migrated,
and our application just works.
No code changes needed.
And as you can see,
our application is now connected
to Azure SQL DB Managed Instance with full support
of my cross database joins
and all other SQL Server dependencies.
No, this is not a virtual machine,
this is a managed database service.
I don't need to patch my operating system,
upgrade my SQL environment,
or worry about any machine configuration.
Azure manages all of these and more.
It's durable, highly available, secure,
and now I have access
to all the intelligent capabilities I only get
by running SQL in Azure.
For example, right here in the portal,
I have access to a full range of performance insights.
Azure is keeping a history of my database telemetry,
and I can find and easily drill into those queries
that are consuming the most resources.
In fact, Azure continuously monitors
all the queries being executed.
We're using machine learning
to understand the database workload.
And we produce recommendations
on how to improve performance.
I can take the script that Azure provides,
and apply this directly on the system myself.
Or, if I choose,
I can let Azure automatically apply the updates for me.
Azure can auto tune my database.
We are the only cloud that offers this innovation.
We've also been innovating with security.
Over the years, we've introduced Auditing, Threat Detection,
and now we're introducing Vulnerability Assessment.
The Vulnerability Assessment will scan my database
using a series of best practices,
so I can maintain a secure and compliant database.
For example, many of you need to comply
with regulatory requirements like GDPR and PCI.
Among many things,
the Vulnerability Assessment can detect
where I have sensitive data being stored in my database.
It will also include recommended steps
to protect the data,
and I can take immediate action right here
in the portal and apply a dynamic data mask
so that I can limit the exposure of the sensitive data
to end users and applications.
So, that was a quick overview
of Azure SQL DB Managed Instance.
You can learn more by following the link shown.
Try it for yourself,
and let us know what you think.
Thanks for watching.
(energetic electronic music)