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
Download the free "Express"*** version
Follow the installation wizard
After installation finished, click "Connect Now" to check if it worked
Then click "Install SSMS" to install SQL Server Management Studio
Follow the installation wizard
How to start
Ask admin to allow you access to the databases you need and provide connection to them
Make sure you are connected to the Employee wifi and the VPN (GlobalProtect)
Open SQL Server Management Studio
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.
Last updated
