Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Due to the principle of “minimum authority for maximum security”, we should regularly check which user is authorized on the sql server, and revoke the …

To send mail through the SQL Server, you must first configure Database Mail. You can find details in the article “How To Configure Database Mail …

When trying to open the console via ilom, the screen does not turn on due to the incompatibility in the java security settings. You can …

In the event that the Exadata servers cannot be turned on from the operating system, we can turn on the systems from the rescue disk …

SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the …

Sometimes we need to list table sizes in SQL Server. For example, we need to find large tables before we start making Compression or before …

To learn the Automatic Shared Memory Management, read the article titled “Oracle Memory Components(SGA and PGA)“. For databases that do not use Automatic Shared Memory …

Here is my favorite handy query to get the list of tables in MySQL without Primary Key : [crayon-6740160c1427c407292550/] This my shortest article ever, hope …

We can compress some tables to reduce the size of the table. I / O performance increases as data size decreases. It also increases CPU …

In some cases, you may need to change the Column Master Key that was previously created for a table that you encrypt with Always Encrypted. …