Time
14 hours 28 minutes
Difficulty
Intermediate
CEU/CPE
15

Video Transcription

00:02
Hello, Siberians. Welcome to lesson 3.1. Off monetary off, this car stated, is that treats everyone Microsoft Azure, Actiq design.
00:12
So he had learning objectives for this video.
00:16
We'll start by covering sequel options in Hangzhou so that we're familiar with a range of options that are available for migrating or implementing secret workloads. In Hasher,
00:28
we'll cover some considerations that will help us to choose the right option for our use case.
00:35
We'll go over. I just seek war deployment models off single database on elastic pole.
00:42
We'll cover the logical construct referred to as azure sea course ever, and what it does
00:49
we'll cover. I just recall petition models and service years, which determines who were painful and I would pay for the service.
00:57
And finally, we make a mention off. Other as revelation out database options.
01:03
Let's get into this.
01:03
Let's talk about sequel options in Asia.
01:07
If you look into the place equal in hasher there, two men categories that are available to us.
01:11
The first category is infrastructure as a service. Second category is platform as a service,
01:19
no
01:19
Hajnal infrastructure, the service category. That's something that many of us already used to
01:25
it's sick, well installed on a virtual machine.
01:29
That means we have operating system level access on. We have full application control.
01:37
The good feeling Hajer is that we did not need to do the deployment from scratch by ourselves, their templates that are available in hasher or images that I've really been hasher tohave sequel preinstalled on them so we could simply deployed those images on will hand up with the virtual machine.
01:56
The has sequel in Stopped,
01:59
then honor the platform of the service category. We have two options. We have the I Just sequel database option on as just a quote database. It shares a common court based with the latest tabled vision Off Sequel seven and actually most of the standard sickle language. The query processing
02:16
database management features identical
02:21
in just a quote database. Now I want you to notice I said most. I didn't say ho so not all of the features I've labeled, but most of them are available,
02:30
but with that loss of features, we against certain capabilities also. So, for example, we do not have to manage the operating system. We don't have to manage the application itself. Physical application in terms of patching and actually a lot off the other operational components, like backup. Also taking care off to an extent.
02:51
The other option. That we have something called as just sequel managed instances, which is something that actually very similar to the functionalities. Our capabilities off sick well on a virtual machine or secret on the physical machine. The only exception there. The audio on the differences. We have
03:09
those platform as a service benefit, so it's sort of like the best of both. What
03:14
we get the benefit off platform of the service in terms off managed service database of service.
03:20
But we also gets the benefits that, in terms of feature said it very close to sequel. Sever on a virtual machine.
03:29
Now, when it comes to choosing the right option for you or for your application, it really depends on where you're looking to do so. For example, secret on the veteran mission. You have full control of the sick or seven engine,
03:42
so that is great. So if you're deploying an application that where you need for control of the course of the engine, you probably want to go for that option because you do not have full control.
03:51
In the other scenarios, you have different degrees off control but not full control. When it comes to sickle manage instance. If you're gonna be involved in a lift and shift scenario, you're gonna be left in Annapolis if sickos ever that existed on premises on the veteran machine
04:09
and you're looking to transition into that platform. Other service
04:12
did a bit of a service model to get some of those benefits off. Butin backups and beauty and passion and recovery
04:19
I just called Managed instance is a good one for you, cause the feature said, as I mentioned, is very, very close
04:27
to normal sickos ever. That's under your control. It also running the letter stable database engine off sick. Whoa, it got private I P address within a Najar virtual network. So it's great. It's the best of both worlds. One of the things I really want to call out is that
04:44
they're seven features that I've really been a Jessica managed instance that are not available in as your sequel database.
04:50
So, for example, support for common language one time Cielo and changed it to capture those capabilities and novel. When I just sequel. But if you need those capabilities, they have a Libyan. I just sicko database plot. It's a plot from other service. When it comes to adjust sequel database,
05:08
the most commonly used sicko set of features are available in it.
05:13
So it's got those platform of the severance benefits, like building backups, patching and recovery. It's running the letter staple vision off sequel, and it's got, like all those other advantages that that's already beauty into that
05:27
in terms of limitations.
05:30
So we also have to pay attention to today's pay attention. Today's so when it comes to secrets have on the veteran machine, what you're saying is you're gonna be taken on the operation A walk it off, managing your own backup and your patches, and you're gonna be taking on
05:43
Ah yeah, that that responsibility off implementing I Havel ability by yourself, and you have to manage old all those downtime and fell over
05:50
with whatever technology or whatever process that you want to use to manage that. But that's on you to manage that when it comes to adjust sequel managed instance,
06:00
even though it's very close to the feature sets that you have in six or seven and virtual missionary physical machine. There still some features that are not available, so be aware of yet. So also, compatibility with circus ever vision can be achieved
06:18
only by using data base level database compatibility. So you have to update that using anti sequel sensually, or you have to manage that
06:29
we get to adjust to quote database migration from sickos ever might be very difficult. So they're setting functionalities off features that if you're using them on your on your sickle, sever on premises at the moment, that may be difficult to move over towards your sequel if those features are not available.
06:46
So, for example, I mentioned
06:48
CLR earlier. Riken Common language. One time that's no supported without your sequel database. So no guaranteed exact maintenance time. So it's It's nearly transparent. Private I P addresses cannot be assigned. You can lock it down in terms of firewalls and making it available to only a virtual network.
07:08
But it doesn't have that.
07:10
That's private feud to his weights, its living within a virtual network that's isolated from everything else.
07:16
Let's talk about I just sequel deployment models. Now they're two men deployment models for just recorded a base. There's the single instance deployment model
07:28
on what this means is it's database with its own set off isolated recesses. In other words, the computer results destroyed yourselves. It's isolated. Tow this instance,
07:41
and then we have the elastic pool
07:43
deployment model where a group of databases share the same set of resources. So in this case, I can say there's like four virtual costs on the amount of vitamin D and that all pulled together and shared by this disciple of databases so that
08:01
if one of them is not consuming and that's that resources,
08:05
the others can take advantage and use. That's
08:07
when we go to the Microsoft as your platform
08:11
to deploy on. I just record database one of the things that would need to create something called a logical sever. Now I want to take some time to explain this, because they can be a bit of confusion here. So where we talk about logical sever in hasher, I want you to think about it as an administrative container.
08:31
Do not think about just ecological sever
08:35
the same way you think of a several Witter resources with compute and starve age and memory That's no what we're referring to here. It's just a logical construct for administration, right? This is no way you specify or defined computer and any of those other stuff. This is not a place that you do that
08:52
now after you have your logical several, which is this administrative container,
08:58
which is where your name space comes, comes from. Brighton Network connectivity. That's where that comes from. Then you can deploy your sequel databases or your elastic pools within that logical administrative construct. Now you can mix and magic, and the place is called databases.
09:15
An elastic political actually Deploy C. Quote that the warehouses
09:18
we didn't know just ecological. Seven. Andi. It contains all of that.
09:24
So some more information about their Jessica Logical sever. It's the parent, resourceful databases. It hacks as a central administrative point for multiple, single or pulled data basis. So that's where you configure your log in too far war rules
09:39
your tread protection policies. You fell of a group to configure this on that logical
09:43
seven on that also where the name space comes from. So you address the name space that comes from the logical sever, and then you specify your in the video database or your elastic pool. That's that reciting in that.
09:58
Let's talk about purchasing models and service years also.
10:03
So when it comes to purchasing as you're sick, well, they're different options that we have. There's the DT you option, which sort of like the legacy option did he use to refer to as a database transaction unit. Software like this blend off CPU and memory and stoppage you.
10:20
This is not the model that you typically use going forward. You see one of the reasons for that.
10:26
The new approaches and model that we have is something called the V Corps Pictures in Model on. This is something that's very much similar to what we're familiar with, right? So you're defining virtual cause. The men differences between ditty years and because is that with ditty you
10:41
your skill computes, which is your higher and memory and stoppage together,
10:46
which is not something that's always great, right? The reason why that's no greatest. For example, let's say you're running out of computer sources in Utah had more compute what that, Mrs, that you're gonna in cure extra storage costs, whether you need it or not, But with vehicle. You have more control as to how you skill. You have more flexibility. You can decide to scale compute
11:05
different from scale in storage.
11:09
When it comes to this deployment models, they have different service tears, and the service stairs essentially defines the amount of resources are the specifications of the resources that will be available to you for detail. It has to be serviced. Yet the basic the standard on the premium
11:26
for V cause industry service tears, the general purples, the business critical and the iPod skill on dis provide varying levels off resources Thio Data basis.
11:37
One other thing that I want to highlight is that when it comes to virtual call model, it supports something called hybrid benefit. I breed. Benefit is where you can take your existence, sir. Course of our licenses on. Then you can get a discount for them in half so you can reuse your existing licenses because at the end of the day, it's just protocol, which is what sick or licenses are based on anyway.
11:58
On then. Also, we have this model called several s, which is going to be in preview, which is beauty per second on virtual cause you, so think about you're going to be paying per second if you're not using the database. If it's nine years, it can post database and then if request coming, it's gonna loads digital base. And then you're gonna carry on being Butte.
12:18
That's going to improve you in case you want to test that out.
12:22
Finally, let's talk about Let's make mention off the other volitional database options that are available in hasher. So we have a plot from a Service Progress sequel. We have plenty more to service my sequel. I'm platform as a service, Marry a D B
12:37
that's available on the other platform. So if you're bent, Marta watched using open source database engines.
12:43
Those options are also available. False. So that's where our hand this. Listen, I'll see you in the very next lesson. We're car carry on a conversation on Azure sequel on We'll talk about my great and data into as your secret

Up Next

AZ-301 Microsoft Azure Architect Design

This AZ-301 training covers the skills that are measured in the Microsoft Azure Architect Design certification exam. Learn strategies to plan for the exam, target your areas of study, and gain hands-on experience to prepare for the real world.

Instructed By

Instructor Profile Image
David Okeyode
Cloud Security Architect
Instructor