Database Server

General information

A Database Server is a computer program that provides database services to other programs or computers, as opposed to just storing and retrieving data on a single computer. It can manage multiple databases and handle concurrent access from multiple users or clients. Examples of Database Servers include MySQL, SQL Server, and Oracle Database Server.

SQL Server

SQL Server is a relational database management system developed by Microsoft that does not only provide a Database Server but also comes with additional tools, such as SQL Server Integration Services (SSIS) for data management, SQL Server Data Tools for database development, SQL Server Management Studio (SSMS) for database management, SQL Server Analysis Services (SSAS) for data analysis and SQL Server Reporting Services (SSRS) for data visualization. It uses T-SQL as query language which is an extended version of the language SQL (Structured Query Language).

For more information: https://www.sqlservertutorial.net

SQL Management Studio

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.

Installation

1. Go to https://www.microsoft.com/en-in/sql-server/sql-server-downloads

2. Download the free "Express"*** version

3. Follow the installation wizard

4. After installation finished, click "Connect Now" to check if it worked

5. Then click "Install SSMS" to install SQL Server Management Studio

6. Follow the installation wizard

How to start

1. Ask admin to allow you access to the databases you need and provide connection to them

2. Make sure you are connected to the Employee wifi and the VPN (GlobalProtect)

3. Open SQL Server Management Studio

4. Select Server Type and type in the Server Name and select Windows Authentication

If you do not have direct access to the database, an alternative way to acces the data is to copy the database (.bak-file) to your device and use "localhost" as Server.

Following this route, you then need to restore the copied database in SQL Server by right-clicking "Database" and selecting "Restore Database...". This will open the following window:

Select device and then click the "..." Button. This will open the following window:

Here, clicking "Add" leads to a window where you can browse the files in your Explorer:

Select the .bak-file you want to restore and click "OK" in all of the windows that have been opened during this process.