While Loop in MySQL
The article contains information about the while loop in MySQL and its usage. While Loop in MySQL The while loop,
PERFORMANCE TUNING TIPS AND TECHNIQUES
Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance
How To Install SQL Server 2019 on Ubuntu 18.04
We will install SQL Server 2019 on Ubuntu 18.04 in this article. Our Server Resource Information: CPU : 4 RAM
How To Convert Physical Standby Database to Logical Standby Database
Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before
Case When Statement in MySQL
The article contains information about CASE WHEN Statement in MySQL as an alternative to the if condition. With the CASE
How To Run Single Command on Multiple Linux Servers
If you have more than one server you manage and if you connect to multiple servers with ssh and run
How To Create Ssh Key and Connect Another Machine by Copying SSH Key
If you are using Linux and want to securely connect to servers without using a username password, you can create
How To Grant root Privileges to a User in Centos
In this article, we will see how to create a user in Centos and how to grant root privileges to
MySQL IF Statement and MySQL IF() Function
The article contains information about MYSQL IF Statement, ELSEIF Statement and ELSE STATEMENT used to direct the command flow by
Logical Standby Database in Oracle
What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database.