18 hours 58 minutes
Welcome back. In this episode, we're going to take a look at an actor sequel. Database demo.
Our objectives include just going out and creating an azure sequel, service instance and taking a look at some of the options we have when we create it and also configurable. Afterwards. Let's jump out to the azure portal
back in our azure portal. Let's go ahead and click on. Create a Resource.
We'll search for a sequel
and choose Azure sequel.
First, we need to select our deployment option. First, we have sequel databases and our resource type. We can choose a single database on elastic pool or a database server.
If we go down and select show details, we can see some of the characteristics of each type.
Next, we have sequel managed instances,
and if we look at its details,
it's a full sequel server that is managed for us.
And it's a good option for migrating sequel servers for Mon premises into azure.
Finally, we have sequel Virtual Machine.
This is where a virtual machine is provisioned with sequel on top of it, and this is useful if you need to manage the underlying operating system for the sequel server
and inside of our images, we have quite a few options we can go back to. Sequel Server 2008 are two on Windows Server 2008 are, too,
all the way up to Windows Server 2016 and sequel Server 2016.
Don't forget, we even have sequel server on Lenox flavors like a boon to or Red Hat
for our demo here. We're just gonna do sequel databases
and we're gonna provisions on elastic pool.
First, we need to select a resource group.
We'll choose our existing database. RG
I'm going to give our elastic pool and name,
and we need to select a server to Host is on
right now. We currently don't have any, so let's click on Create New
We'll give these server name and notice. It has dot database that windows dot net so this needs to be a globally unique name.
We need to enter a server admin log in user name and password,
and we need to select a location for the server.
And finally, we need to select our computer and storage options. Let's configure our elastic pool
right now. We have general purpose selected
where you can see, we have an option of gin forage and five, where we have a range of cores and memory we can assign to it.
Down here, we can select the number of virtual cores and data max size. For our instance.
We can also configure per database settings where we can select the number of virtual cores per database. This is also the similar options we have under business critical.
However, if you don't want to use a V Corps option, we could go back to Basic Standard and Premium,
where we can configure DT you settings, such as how many d to use. We want to reserve out of the pool for this instance.
Well, stick was basic for right now, and go ahead and apply this
and let's review and create.
Now with our sequel, Resource is deployed back here on the home screen. Let's select sequel servers,
and here is the sequel server we created when we were configuring our database service is Let's go and select it,
and here you can see some of the properties of the server when we created it, such as the resource group it is provisioned in as well as the admin user name that we configured.
And from here we have a couple of different options. Let's go ahead and go and configure a new database.
We'll create a database name. Students.
We have the option of selecting a blank database. But we could choose a backup if we had an existing one already created.
We're gonna provisioned this on our d B 01 sequel server. And if we want to use elastic, cool or not, right now, I'm going to select out now. Go and leave our price interior, general purpose
and go and select. Okay,
well, that's creating. Let's go ahead and check out fail over groups.
And here we can create a group to manage our replication and fail over of any of the databases that we have
under settings. Let's go check out manage backups.
And here we have our students database that we just created with a point in time recovery backup of within the last seven days, we can select this database and configure retention,
and we can select additional options like a weekly monthly or even a yearly backup were similar to what we had with our virtual machines
under settings and sequel databases.
We'll just have a list of the database is currently available, as well as the pricing tier that they're associated with.
We could also take a look at our elastic pool that we have configured
as well as taking a look at our usage of R D T you quotas.
One other thing to mention when we created thesis Equal server, we created our own user name and password for it
by default. Authentication to the sequel server is not integrated with as your active directory, but we can't set an admin from our azure a d. Let's go ahead and do that,
and this does need to be an azure A D account.
So I'm gonna search for my Jeff admin account,
and go ahead and confirm that selection.
So now I should be able to use this Asher Active Directory admin account to access the Azure sequel server.
Once we've set the admin, let's go ahead and save this
and let's go back and check out our elastic pool
here. After selecting the pool,
we go in and have a couple of other different options where we can manage how our pool is configured
One thing we do is under settings, and configure
is we can change what tear we're on. We can stick with CTU based with basic standard and Premium.
Or we can switch over to a V Corps option if we decide that we need Maur options with configuring the CPU and storage for our databases.
So this does allow configuring after the fact. If the usage of your databases happens to change in the future,
that does it for Azure sequel database demo. Let's jump back to the slides and wrap this up.
That does it for this modules. Another short one coming up Next. We're gonna dive into the last module of this course with the discussion on Azure Power Show and CLI
see in the next episode.