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

  Pre-requites: Must have MySQL Enterprise Edition installed Download media file :  meb-4.1.0-el6.x86_64.rpm (For Linux Platform)   Installation of MySQL Enterprise Backup Command to install …

  Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …

  If the connection breaks  and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …

  A few weeks ago a client called around 11:00 pm and said that they received an error in a very critical Microsoft SQL Server …

I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …

  OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …

  Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …

  In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …

  There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …