How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For...
How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways
This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a...
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool...
ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)
This article focuses on the step-by-step processes of installing and configuring the ODBC driver...
Microsoft SQL Server Express Edition Limitations and Versions
What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft provides it for educational purposes as...
Connecting to SQL Azure from SQL Server Management Studio (SSMS)
Microsoft Azure is a cloud computing service for building, testing, deploying, and managing applications through the Microsoft data...
Basics of SQL Server Management Studio (SSMS). Part 2
This article further explains the basics of SQL Server Management Studio (SSMS) – one of the most...
Create a Database in SQL Server Using SQL Server Management Studio (SSMS)
This article briefly explains creating a new database with the New Database wizard of SQL Server Management Studio (SSMS). The SQL Server...
Five Different Methods To Start, Stop, And Restart SQL Server Services
When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in...
Install and Configure SQL Server 2019 on Windows Server 2016
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
