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...
How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench
This article describes the step-by-step deployment process of the Azure Database for MySQL Server....
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 for MySQL. In particular, it will cover...
MySQL Create View, Replace View and Drop View Statements with Examples
An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a...
Connecting to SQL Azure from SQL Server Management Studio (SSMS)
Microsoft Azure is a cloud computing service for building, testing, deploying, and managing...
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
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...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this...
