>> The first deployment option we're going to talk about for
Azure SQL is SQL Server on Azure Virtual Machines,
which is going to provide the promise of the Cloud
and allow you to have OS control.
Now, there are many reasons why we see
customers moving towards SQL Server on Azure Virtual Machine.
They might be having hardware that has contract that's expiring,
they might have SQL Server on 2008 or 2008 R2,
they might be wanting to move to the Cloud
as fast as possible but not wanting to
make big application changes or common times we see
people are leveraging third-party applications
that require access to that OS.
Now, SQL Server on Azure Virtual Machine is going to be
a great solution because it's really just SQL Server,
so you can get the version of the SQL Server that you need,
you can get the OS that you want,
and you can also get
all the features that are available in SQL Server.
In addition, by moving to an Azure Virtual Machine,
we're going to give you things like
free extended security updates for SQL Server 2008,
and we can allow you to set up things like
automated backups and point-in-time restore.
Now, a customer I really like to talk
about related to this is Allscripts because
they were able to move over 600 on-prem
VMs to Azure in a matter of weeks using Azure Site Recovery,
and an interesting thing here is that
they really took a phased approach.
So after they move to SQL Server in Azure Virtual Machine,
they started evaluating some of their workloads for
our past service Azure SQL Managed Instance.
Now in this series,
we're not going to spend a ton of time on
SQL Server on Azure Virtual Machines
because it's really just SQL Server.
However, there are a few considerations
that we just wanted to touch
on for you as you go through this process.
>> So in this series, as Ana mentioned,
we're not going to go into all the depths of
Azure Virtual Machine because the focus is going to be more on
the differences and similarities between
Managed Instance and database to your SQL Server environment.
But there are some important points
that you need to know because you are
deploying SQL Server in the Azure Infrastructure.
First of all, you're going to deploy a virtual machine just like
you're used to doing something and say Hyper-V or VMware,
you're deploying these things now in our data centers,
so we're going to give you interfaces to do that.
First of all, you're going to be able to deploy
SQL Server to what we call the Azure Marketplace,
which I've mentioned before through the ecosystem,
pre-installed versions of SQL Server both on Windows and
Linux available to you or you can just install it yourself,
you can install the OS to
the marketplace and then bring your media up
install SQL Server inside the VM environment in Azure.
Ana mentioned about Allscripts, so Azure migrates
a great option because you can literally lift and shift
the entire virtual machine VHD from a VMware or
Hyper-V right into Azure and just start
running away and operating with the virtual machine.
Now when you use the Marketplace,
we use something behind the scenes called the Resource Provider
to register your virtual machine with us,
so you can take advantage of licensing in addition flexibility.
You get things like automated backups and
security updates because we know that
you're running SQL Server this Azure environment,
and in fact through that Azure portal,
you can see all the different resources
of your Azure Virtual Machines with
SQL installed along with Azure SQL Database and Managed Instance.
If you don't have SQL Server
installed for the Marketplace and you install it yourself,
we do have a process for you to use the Resource Provider
to register your SQL Server with us.
Now, performance is an issue no matter where you
go and then your data center when you're
setting up SQL Server the virtual machines,
you establish the performance parameters,
you're using Azure now, we've got a lot of great options for you.
You're going to pick virtual machines sizes,
and so we're going to have things like memory or storage optimized
sizes that you can choose from to pick different memory options,
CPU options, and storage to
give the maximum performance for SQL Server.
Your database and your log,
those concepts you're used to doing,
you're still going to be storing those things on disks in
Azure and we have something called Premium Storage Managed Disks,
they're going to give you the best flexibility
and the best performance for your workloads.
In fact, we did some interesting stuff,
we have three read caching from our Azure Blob Storage,
which is really going to maximize
your performance and you just have to use storage,
you don't have to do anything special option there.
You do have to configure Azure Storage that way,
but it's not something extra you got to pay for,
just comes with Azure Storage.
Tempdb is going to be stored on
a local drive with fast SSD storage,
and if you need really low latency needs,
we do have something called ultra disks that you can configure
to put your transaction log or
your database in those environments.
Now you've got to set up networking
somehow because remember you're running
your VMs inside the Azure ecosystem and infrastructure.
That's okay, we have virtual network environments for you to
integrate not only your virtual machine
with other Azure resources,
but even with your on-premises assets,
could be your application,
your tools, whatever we need to do,
and Ana mentioned about some of the benefits of
using the Azure Infrastructure even with VMs,
we talked about automated backups and security.
While you're going to hear more in
this series about something called
Advanced Data Security and in preview right now,
you can even integrate
advanced data security services in Azure to your virtual machine.
Well high availability is got to be important to you of course,
and normally you're used to configuring
your SQL Server with things like
Failover Instances and even
have backups of your databases and your VMs,
well Azure, through the ecosystem,
has built-in HA with their virtual machines,
built-in DR using Azure Storage with
multiple copies of your database files
just by using Azure Storage.
We integrate with services like Azure Backup,
we support things like file-snapshot backups,
and you want to be able to do things like
failover cluster instance and availability groups.
We have that all set up for you so you
can integrate those technologies
within the Azure ecosystem, and for example,
SQL Server on Linux has just come out in the last few years,
we will even integrate HADR solutions with
Linux distributions like Red Hat to support
things like fencing and stone of protocols.
So we've got a wide range of solutions for you, again,
it's just SQL server running on a VM,
you're going to RDP in this thing and just going to
feel like a SQL Server in a VM.
But you want to make sure that that VM is deployed,
configured, setup for performance,
setup for availability using the Azure Infrastructure,
just like you might do in your data center.
Virtual machines can be a great option,
it could be your fastest option that you
have to move to the Cloud, and again,
there are advantages of running SQL Server in Azure because of
the infrastructure options we provide you,
but just remember, in the end,
this is the full range of SQL Server choices,
SQL Server editions and
SQL Server features that are running in Azure.
Hope to see you in the next video.