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

  If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on …

Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …

  In this article, we will examine the configurations that need to be made after SQL Server Installation. You can find the details of the …

  For restart operation, we must stop and start the Oracle database. In this article we will show the below scenarios; stop an instance of …

We use the operators to identify the contact list to send mail to. Right click on Operator under SQL Server Agents and call New Operator. …

  You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …

  Under Management on SSMS, right click on Database Mail and select Configure Database Mail. Click “Skip this page in the future” and next. On …

There are a few important things to check for SQL Server Always On Availability Group. Did the failover occur on any AG? Does the transfer …

If you increase the value of the MAX_Connections parameter in the postgresql.conf file, you can get this error while starting the PostgreSQL service. You should …

  In this article, I will show you how to get a user’s create script in Oracle12c, with the hash of the password. We may …