Configuring an MSSQL Server Relational Database



This video series shows how to quickly create a Microsoft SQL Server Relational Database. In Part 2, we will demonstrate configuring a database and reviewing logs.

Introduction

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.

Configuring Your Database

After the database is built and the replication is running, you can review information about your database and the hosts involved in your replication.

RDBS Configure Database

You can also download your SSL certificate, configure your backups, and view your logs and metrics.

RDBS Configure Database

Under the Hosts section, the green background denotes the active database that you are connected to. The host name and IP address are included here for clarification, but the connection will always be made through the Connection string in the Info section above.

RDBS Configure Database

That connection string goes to a DNS server and allows it to switch seamlessly on failovers.

RDBS Configure Database

Logs stream in near real-time. There are two dropdowns that allow you to view logs from either the primary or replicant database.

RDBS Configure Database

You can also select the Metrics tab here to view data for Memory, CPU and Storage over 1-hour, 1-day and 31-day periods.

Part 3: Logging Into an MSSQL Server Relational Database