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

  Sometimes developers need a permission for change their login’s password. if you do not give them to necessary permission they can not change their …

  With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …

  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 …