Useful tips for everyday
What is a database mirroring endpoint? Database mirroring endpoints use Transmission Control Protocol (TCP) to send and receive messages between the server instances participating database…
How to use where..in clause multiple columns? IN clause multiple columns But the WHERE..IN clause allows only 1 column. How can I compare 2 or…
What is MariaDB replication? Replication is a feature allowing the contents of one or more primary servers to be mirrored on one or more replica…
How to install MariaDB version 10.3 on Debian 10? Step 1 — Installing MariaDB. On Debian 10, MariaDB version 10.3 is included in the APT…
How do you create a relationship between collections in MongoDB? Relationships in MongoDB represent how various documents are logically related to each other. Relationships can…
How do you find which my CNF is being used? If you run mysql –verbose –help | less it will tell you about line 11…
Does full database backup include transaction log? A full database backup backs up the whole database. This includes part of the transaction log so that…
Is there an issue with SQL Server 2017 CU 20? Under certain circumstances, there is a known uninstallation issue that affects SQL Server 2017 CU…
How do I list all schemas? How to list all available schemas in PostgreSQL? Using SQL Query. You can get the list of all schemas…
How to select value of JSONB column in PostgreSQL-stack overflow? The jsonb_array_elements () function unnests the JSONB array into a set of rows with a…