This video series shows how to quickly create a Microsoft SQL Server Relational Database. In Part 1, we will demonstrate how to create a new database.
The Microsoft SQL Server (MS-SQL) database is a comprehensive and integrated data management and analysis software application that enables the reliable management of mission-critical information. With a Relational DB, you can create, modify, and delete tables, as well as select, insert, and delete data from existing tables.
Creating a Relational DB
There are two ways to create a relational database from the DBaaS dashboard. You can click Create in the left-hand menu, then select Relational DB, or you can select Services and then Relational DB. This method will take you to a list of your existing databases, where you can create a new one by clicking on the green button at the top of the page.
On the Create Database page, there are multiple sections. The Cost Estimator and the Bill Time estimator also show you the amount of CPU, Memory and Storage you have allocated. Other sections show Resources and Options.
To create a database, go to the top dropdown and choose MSSQL, then select the version and edition.
Next, choose a CenturyLink data center location, then a network from your local network, and a unique identifier.
Finally, create and confirm a password for your database. Make sure it is stored safely.
The default settings in the Resources section are the minimums required for acceptable performance. You can set the figures in the CPU, Memory and Storage dropdowns higher to meet your requirements. Note that this will automatically increase the figures in the cost estimator.
In the Options section, you can set Replication to create a replica of the primary database, and choose its location and network. You can also enable Notifications, customize the backup schedule, and select the number of days backups will be kept. Some of these options will also incur additional costs that will be reflected in the Estimator.
The final step is to select the Create Database button at the bottom of the page to complete the process. This sends you to a Details page where you can review your selections.