- Posted by redglue
- On February 15, 2017
- 0 Comments
- 101, cloud, sql database, sql server
The cloud is more and more part of our lives and as a data professional, we have the need to follow this new wave. It doesn’t matter if you are a SQL Server developer or a database administrator, the cloud is the way to go…as projects on this area are popping up from everywhere. There are two ways to move your SQL Server database into the cloud:
- Using Infrastructure-as-a-Service (IaaS), which are nothing more than VMs with SQL Server installed in the cloud;
- Using Platform-as-a-Service (PaaS), that categorizes the Database-as-a-Service (DaaS);
In this quick and direct guide, we will explain the basic steps to create a DaaS, of course, using the best option available, not only in Azure, but among all the cloud providers: Azure SQL Database.
In order to create a new database, follow the steps bellow:
- If you don’t have a “SQL Server” logical instance created, you will need to create a new one. One of the way to do this, is creating the “SQL Server” by accessing the option “SQL Server” on the left-side menu.
- A new blade will be opened, on the top-left corner, click on “+ Add”:
- Another blade will appear, with some empty fields to be set. Fill the server name, user name (used to administer the logical instance) and its password. After that you will need to choose a subscription to create the “SQL Server” (in case you have more than one) the Resource Group (you can either create a new one or select an existing) and, finally, the desired location. Once all is set, you just need to click on “Create” and wait for the success information.
- Now that you already have you SQL Server logical instance created, you can go ahead and create the database. For that, you will need to access the menu option “SQL databases”.
- A new blade will be opened. Click on “+ Add” button on the top-left corner.
- Now you will need to define the new database characteristics. The most important here are:
The server where the database will be allocated (the one created in the beginning).
The source, where you have 3 different options:
The “sample database” option is useful for training/testing purposes, when you don’t have an available database model. On other hands, when you already have some SQL Databases in Azure, you can use one of the backups and create a new database based on this.
The pricing tier is an important (and complex) option, as it will influence in the database performance and backup retention. You can get more information about that here.
- Click on “Create” and wait for the success notification. After that your database will be ready to be used.