Deploy database offerings on selected platforms
We’re going to have a look at planning and implementing data platform
resources, and we're going to start using manual methods.
So, we've already got our first SQL database. So, what happened?
I went to Azure SQL. And I can go to Create.
So here we can create single databases, elastic pools, managed instances,
and SQL virtual machines. So, we could have SQL Server sitting on a Windows Server.
So, if I was to go to any of these, then I would just click Create.
www.linkedin.com/in/ragasudha-m
So, if we have a look at these two, which we've not had a look at yet,
So, SQL managed instances,
You’ll need your subscription, and your resource group.
You need a managed instance name.
So, a managed instance is like having a fuller version of SQL Server on a cloud
with an SQL Server that you can manipulate, though you can't manipulate the
Windows machine behind it.
So, you'd need to put in your managed instance name, a region, and an admin
login and password. And you'd also be able to put in the appropriate amount of
compute and storage.
We'll be looking at creating an SQL database Managed Instance much later in
this course.
Now, we can also get SQL virtual machines, and you can see lots of different
images.
www.linkedin.com/in/ragasudha-m
So, with an SQL virtual machine, you'll be paying for the operating system,
as well as for the SQL Server.
Now, you don't have to pay for Developer but then you also can't use Developer
for commercial reasons, you can only use it, for instance, for a testing bed or for
learning how to use SQL Server.
So, it's likely you'll be using both Windows Server and a full SQL Server. There is
also a bring your own license version as well.
Now, this isn't the only place where you can deploy it from. If I go back to
Home, and I look for the Marketplace, then here is another place where I can go and
find lots of images.
www.linkedin.com/in/ragasudha-m
So, if I go on the left-hand side, you can see all these different images that I can
use, and I can just type in SQL Server here, and have a big search for what's available.
www.linkedin.com/in/ragasudha-m
So here, you can see SQL Server on Windows, SQL Server on Linux, for instance.
And there is this Create button at the bottom.
So, if I were to go back to Azure SQL, and create a new virtual machine, then
you'll see there are a lot more things that are needed.
www.linkedin.com/in/ragasudha-m
A virtual machine name, a region,
availability options, availability sets,
availability zones, scale sets, that sort of thing.
The spot license is a discounted rate, which may have infrastructure loss
because they can recall it when they need it.
You'll also need to have virtual networks in place. So, IP addresses. So, there's a
lot more options that are needed here.
So don't forget, this is a full-blown computer.
It's just one that's not on your machine. It's a virtual environment on a really big
server that you've then got access to.
www.linkedin.com/in/ragasudha-m
So, these are some ways of deploying database offerings using the portal. You
could also go for things like SQL database or SQL managed instances, or virtual
machines and deploy them from there.
www.linkedin.com/in/ragasudha-m
