We will install SQL Server 2019 on Ubuntu 18.04 in this article. Our Server Resource Information: CPU : 4 RAM : 16 Disk : 80 …
Read More »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 converting a Physical Standby database …
Read More »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 statement used in MySQL as …
Read More »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 single command on multiple linux …
Read More »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 a ssh key and connect …
Read More »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 a user in Centos. How …
Read More »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 condition in the MySQL VTY …
Read More »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. It is an active database …
Read More »Neo4j Backup and Restore(Dump and Load)
In this article, we will talk about Neo4j backup and restore operations. Neo4j Offline Backup Let’s take Offline backup of Neo4j Graph Database. It is …
Read More »MySQL Stored Procedures
The article provides information about MySQL stored procedures. Creating a stored procedure and stored procedure types are explained with examples. What is MySQL Stored Procedures? …
Read More »