In my last post I brought to your attention the free Azure
cloud offer from Microsoft. As I said,
when Microsoft comes out with something new that they want people to adopt,
they are very generous! They usually
start by giving the public the tools
needed to learn the new product.
Now that we have access and a free learning environment, let’s
start to take advantage of it. Let’s
dive into my favorite tool: SQL Server.
To access your newly set up portal, go to https://portal.azure.com.
We begin with setting up a basic SQL server. In the portal choose <NEW> this will
give you the market place options to choose what to set up. For this blog we will explore <Data +
Storage> where the featured App <SQL Database> is. From this point, we get a few features that
would be more familiar to setting up a physical server instance of SQL
Server. As with a physical server we
give it a name, and then can start to configure it. With Azure some of the terminology is
different, however the concepts are not new. When you are selecting a source
you are selecting the location of a server.
When you choose pricing you are choosing the server resources, speed,
ram, etc. The resource group and subscription are just organization pieces to
group all your items together.
I have no servers at the moment so my only option is to
create a new one. Follow the
requirements to create a server. The key
items to note are the password and the location. The password must contain both upper and
lower case English letters, a number and a special character. These are typical
industry standards but should be noted, and you cannot continue until you meet
this minimum.
When choosing a location, choose the location closest to
where you will access it access from. I
chose “US West” as I am in Western Canada and physically, that is closer than
an Eastern Canada location. It does not
matter that it isn’t in the same country.
This general rule should be followed when setting up servers for
client. I have clients in the Ecuador,
and so would choose a location that is closest to them. Once all your options for your server are
chosen and you click ok, the menu options disappear and you are back to main
screen. You are now ready to configure
the next requirement.
I am using this set up for a demo database so I will choose
the blank database as my source. My
options being a backup of a database, a sample or a blank database. The pricing tier is an option for another
post as there are many options. For this
example, I chose the basic option.
Choosing a collation option is also configurable, but the default is the
standard SQL_Latin1_General_P1_CI_AS. Resource groups will be followed up with
another post. To get started you only
need a name for the resource group and you can move on.
Remember to check the pin to dashboard option so that your
SQL Database is easy to find.
Once you choose create, Azure does a lot of work behind the
scenes and creates everything need .
Once created, click the SQL databases from the main menu and
a right click on the database. This will
allow you pin it to your dashboard for easy access every time you login.
You now have a basic database created and ready to use.
In my next post, I will cover resource groups in greater
detail.
No comments:
Post a Comment