(gentle upbeat music) - [Shreya] Like I mentioned, we are going to take a look at what are your different SQL
Server migration options, and Azure SQL deployment options. And choosing between these
options, deployment options. Choosing a particular tier, and then we'll quickly look at a Demo. Which shows you a very easy interface of how to pick one of these options. - [Host] You're also going
to show a Demo as well? - [Shreya] Yeah.
- [Host] That's fun. - [Shreya] I'm going to show a Demo. All right, so quickly jumping into, what are your different SQL
Server migration options available to you when you are
trying to upgrade or migrate your SQL Server from
one version to another. So, there are two basic ways
in which you can migrate your SQL Server, current SQL Server. Either you decide to upgrade
and modernize to Azure, and you bring your workload to Azure. - [Host] Move to cloud? - [Shreya] Exactly. Or you just decide to
modernize on premises. And you just decide to
upgrade from a older version of SQL Server to a newer
version of SQL Server, which is SQL Server
2017 or SQL Server 2019. - [Host] 2019 coming up now? - [Shreya] Yes. - [Host] That's very exciting. - [Shreya] Pretty soon. So. If you are a end of US customer, end of service customer. You can either upgrade to a new version or you can continue to
use your EOS Server, with the help of ESU. Upgrades you can purchase those on-prem. Or when you come to Azure and you decide to modernize to Azure, and you bring your
workload to VM, let's say. You get those ESU updates
for free on Azure VMs. Or you can decide to just upgrade and come to Managed
Instance or Azure SQL DB. And then you never have to worry about any upgrades in future. So looking well. Let's dive deep into all of these options. So let's assume that you have
decided to upgrade to Azure, and modernize to Azure. - [Host] Of course. - [Shreya] And once you have
decided to modernize to Azure. There are multiple options
that are available to you. And the first one is SQL
Server virtual machines. So you want to bring
your workload to Azure, but you want control over the OS, you want control over the SQL Server, and database server. Complete control. Then this is a good option for you. - [Host] Okay. - [Shreya] Another one
is SQL Managed Instances. Wherein you don't want
to manage the hardware, you don't want to manage the OS, you don't want to manage the database, you want Azure to manage all for you. But you want SQL Server level access and you want network access. Like, you want to make a v-net
with your on-prem network and then you want to control
access to that network. So Managed Instance is a good option. And the third one is SQL Databases, Azure SQL Databases. If you are trying to modernize. It's basically for modern
cloud applications, right? When you create a database, you can easily scale it up, scale it down. It's easy to provision and it's for the modern workloads, modern cloud applications typical. And SQL Database also provides you a way to scale all the way up to
100 terabytes and beyond. And it also lets you use
options like Serverless. Where you can save some costs
by not paying for compute, when you're not using it. - [Host] I see. You can pause in a way? - Yeah. You can pause in a way and
then save some cost that way. - [Host] That's awesome. - And there is another option. Elastic Pools. Where you can share the resources and save some cost that way also. All right. - Especially on these deployment options. Let's say it shows something. I want all the deployment options, can you please talk about those? And also if you have
some real world examples. You can talk about those, as well. - Yeah, sounds good. So like I mentioned there
are three different options available to you. But then when to choose what, right? That's often source of confusion
for a lot of customers. So let's say you want to
manage your SQL server. You want OS level control, you want SQL server level control, and you want to control everything. And so SQL Server Virtual Machine is, like I mentioned, is a good option. And SQL server virtual machine typically customers also use
it when they have features, they are using features
like DTC and polybase. Which are not available
in Azure SQL Database, so then it becomes a
natural choice for them. And also if you want to run SSIS, SSAS, SSRS type of applications. - [Host] Integration
services, analysis services or reporting services? - [Shreya] Exactly. Co-locate it with your SQL Server or you want to run a
third party application, and you want to co-locate
with SQL Server on Azure. Then SQL Server VMs are
a good option for you. And H&R Block is one of our customers, who recently migrated their
workload to SQL Server on VMs and SQL server 2017. And that was their
first step of migration. And now they are looking to migrate to SQL Server Managed Instances, as their next step of migration. So once you migrate to Azure, it opens up the different
ways of, you know, modernizing your application
and continuously evolving them. Now let's discuss SQL
Server Managed Instances. And Managed Instances is something that you would choose when
you want 100% surface area compatibility with SQL server. So you get full compatibility of features, and you also get some
control over network. So you are allowed to create, you are able to create a v-net, and then you are able to control access to your Managed Instance
through that v-net. Access, allow applications or
allow users that you want to. Komatsu is a customer
who recently migrated to SQL Server Managed Instance. They brought about 1.5 terabytes of data to Managed Instance. - [Host] I see, that's cool. - [Shreya] And they
observed 49% cost savings, by migrating to Managed Instance, and 25% performance benefits. - [Host] Fantastic. - [Shreya] When migrating to Cloud. So they are a great, great example of Managed
Instance migration. Now, you just want a database. You don't want to deal with
server or instance level, and you want database. You want it to be fully managed. So Managed Instance also
is fully managed by Azure. So you get actually all and everything, all those benefits by default, right. On SQL Database also you get
all these benefits by default. It's completely managed by Azure. You just have to create a database. Spin it up, dial it up or down, according to your workload requirements. It's very easy. Provisioning is easy,
very straight forward. And it has simple
deployment cycles, right. Thompson Reuters is one such customer who picked Azure SQL Database recently. Because for the e-billing application, and they picked it because
of fast provisioning, and easy scale up and scale
down of Azure SQL Database. - [Host] I see. - [Shreya] Now if you have a application, which is multi-tenant. When you want to host multiple databases, maybe you are selling a
product to your customers, and for each of the customer
you want to host a database, in Azure SQL DB. - [Host] Like a retail scenario? - Like a retail scenario. So you would. There is an option available for you, which is Elastic Pools. Azure SQL DB Elastic Pools, which where you can host a
multi-tenant application, and this lets you share
resources among the databases. So when you do that, you can also observe some
cost savings for you. So it's a good option
for those type of people, and Paychex is one such example. Who actually hosted their
payment and time management software on Azure SQL Database. And they are able to
scale to tens of thousands of hundreds of thousands of customers with the help of this Azure SQL Elastic Pool
migration that they did. - I see. So the next question now, is because what tier do I choose? If I let's say I wanna
go for this right here. - Yeah, that's helpful. Like people always ask that. So we have multiple
tiers available in Cloud for Azure SQL DB Managed Instance, general purposes, business
critical and Hyperscale. Hyperscale is available only for SQL DB. For SQL DB and Elastic
Pool we have both DTU and vCore models available. Which let you choose. vCore model is basically specially, it provides a flexibility
to choose between compute and storage. And with hyperscale in Azure SQL DB, you can scale very easily. You scale up and down very quickly. It's very fast. All the way up to 200 terabytes or more. And in general purpose here
for Single or Elastic Pools we also give you our
serverless option now. Which lets you save on your compute cost. Like I mentioned before,
if you're not using it. So I think Ajay is going
to discuss talk about this more in detail later. And with that I am going to
just quickly give you a demo of how these all different options are available to you on Azure, when you go to Azure. And how you can choose
between all of these. - [Host] All right. - So let's quickly switch
to my demo screen here, and here I just have my Azure portal open. And when I come here I
can go to my favorites, and now you have this new
experience available to you. A new resource type available to you, just called Azure SQL -- - [Host] So hold on. So when people go to portal.azure.com, How do they get to this screen? Let's start really from scratch then. - [Shreya] Yeah so this
is your portal.azure.com. You come here, you see this and you see all
these resource types here. Different resource types. So if you have not seen Azure SQL before, the only resource types that
you would see is probably SQL databases, SQL Managed Instances, if you have put them in favorites or virtual machines, right. And you can say create a resource here, and if you type Azure SQL you
will see a new resource type, Azure SQL, right. So I have put it in my favorites, so I see it here. - [Host] Okay, now I understand. - So if I click on Azure SQL, it actually shows me it
puts all the resource types together into one place now. So it actually shows me all
my databases, all my VMs, and all my Managed Instances at one place. So that way I know exactly
how many resources I am using. And what all resources I have. So now let's say if I have to, I want to add a new resource here, right? So if I click on add, it now tells me that there are these three different type of Azure SQL
resources available to me. The first one is SQL Databases. Where I can pick between single database, or elastic pool, or a hyperscale, or a serverless. You know, different options. And the other one is Managed Instance. Where I get network level control. So I can set up my own v-net, and the third one, of course,
is SQL Virtual Machines. Where I can bring my SQL server version from on-prem to Cloud, as is. And like I mentioned, the Eos
I can take benefit of the ESU. Updates for next three
years for free on Azure. So it's a great option
for customers looking to quickly migrate. So yeah these are three
different options available and customers can quickly get started with their migrations from
with the help of these options. - That's awesome. Thank you so much for all this
great information, Shreya. - Thank you, thank you for having me here. - All right folks, we'll be right back with
our next segment with Ajay . Please don't go away.