Leon Welicki: Hello there and thank you very much for joining
us in this new Azure Portal How To video. A few weeks ago,
we did the video on how to quickly create a SQL Azure
Database in the cloud. Today, we learn how to create a
SQL Azure Database in the cloud providing all the available
options. And for that, we have Ninar Nuemah that is going to show
us how to do it. So, thank you very much for joining us today.
Ninar Nuemah: Thanks, Leon. Thanks for having me. So,
like Leon said, we’re going to go through all of the settings
available for creating a SQL Database in the Azure portal.
If you want to have more of a quick go through of the create
to quickly get started and test it, we have another video
for that.
So, I’m going to get started going to the Azure portal, click
create a resource and go to SQL Database. Like the other
resources that I can create in the Azure portal, we have our
inputs and settings organized into tabs. We have the basics
tab that has the minimum set of requirements you need to
enter to create the database. And for SQL Database, we have
one additional settings tab with all the extra useful settings
that you may want to configure depending on your needs.
So to get started, I’m going to select the right subscription
for me in my resource group. If I wanted to quickly get
started, I would just need to enter the name of the database
and I could immediately go click create.
But I’m going to look through my other settings. I’m going
to pick the right server for me and pick the - - I can search
for the server name and the region that I want, but right
now, I’m going to create a new server for my needs. So,
I’m going to give it a name, enter my credentials, and
I’m not going to change the region. I’m happy with that,
but I am going to select allow Azure Services to access this
server so that I can use features like query editor or later
connect my web app to this server. Oh, it’s validating.
Here we go. My server name is unique, so I can continue.
Alright. And then I can look at additional things like if I want
to put this database in an elastic pool, I could use that if I
have a large number of databases and I want to manage
them and monitor their performance of them together.
And then I could go and I could select the pools that I want,
this database and other databases, to be managed within.
I’m going to configure this database solo. So, I’m going to
go to configure the compute and storage resources for this
database. In here, I have the vCore based service tiers
and I have the DTU based service tiers. In the vCore based
service tiers, I have configurable compute and storage
settings. I can configure exactly based on my workload needs
versus in the DTU tier, I would have preconfigured bundles
that I can select from. The DTU model would be ideal if I
just want something simple and easy, something preconfigured.
In the vCore model, it would be ideal if I really care about
transparency and flexibility and have very specific workload
needs.
So, the tiers available in the vCore based model, we have
general purpose, which is best for most business workloads.
We have business critical, which is great for business
workloads with high IO requirements. And it offers high
resiliency to failures because it has multiple isolated replicas.
And then we have our newest hyperscale tier, which offers
highly scalable storage, up to 100 terabytes, and you pay
for the storage you use as opposed to preconfiguring it.
Then going back to general purpose, similar to hyperscale
with pay for usage storage, we have the serverless compute
tier, which is pay for usage of compute. So, instead of
preconfiguring and paying a fixed amount for compute, you
would pay for the compute that you’re using.
So, as I go through and configure all the settings that I care
about, I can look at the cost summary and review based on
the selections that I’ve made in this page, I can view how
much is the estimated monthly cost or the usage based
costs that I’d expect to pay and get an estimate of my
monthly cost so that I can predict and plan for that. So, I’m
happy with the settings that I have. I’m going to go ahead
and continue. And at this point, I’ve configured everything
and basics I could go ahead and create at this point. But
I’m going to go to the additional settings tab to look at what
extra I have.
So in here, the first thing I have is data source. By default,
I’ll get a blank database, but I can select, I can populate
data into this database from a backup or from a sample.
Say I have a database that I was using that became
inaccessible, I could restore it to a new database from a
backup, which is why I would want to use this. If I’m just
testing things out in SQL Database, I may want to just put
sample data in there, so I can get started quickly.
And I have other settings that potentially I care about
depending on my language database collation. And if I care
a lot about security, we have this advanced data security
feature that gives me a bundle of security features that
will check for vulnerabilities and threats and give me
recommendations and give me an assessment based on
what is potentially wrong. And this applies to the entire
servers, not just this database. So, every database on the
same server as this database I would get these security
features and this assessment running. And I can start with
a free trial.
And then the last thing available for all resources that I’m
creating in Azure are tags. This could help me categorize
my resources. Maybe later I want to configure Azure policies
or I want to identify and organize my resources, say my
environment is dev. My customer is Contoso. I can organize
and categorize that way.
So, I’m going to go ahead and go to review and create
right before I create the resource and take one last look
at my estimated cost. View maybe the cost summary if I
want to look one more time and see the settings that I’ve
configured for this database. It ran one last validation to
make sure there aren’t any issues. And then I can go ahead
and create.
So then, yep, once I hit create, it takes me to this great
deployment status page. For every resource in Azure, it
gives me status, how long is the deployment taking? What
are the different things being done? I’m creating a database
and a server, so I’ll see the status of each as they succeed
or fail.
Leon: That’s great. Thank you very much, Ninar. And this,
by the way, this deployment page is the same one that we
have for all the other services, right?
Ninar: Yep.
Leon: Perfect. So, thank you very much, Ninar.
Ninar: Thank you.
Leon: And thanks every one of you for watching. Please try
yourself, leave us a comment in the comments section, follow
us on Twitter, and look forward to seeing you in the next video.
Thank you very for watching.
Ninar: Bye.