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

  You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from …

  If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of …

  With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates …

One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-684c9e2133025539438646/]

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on …

  First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. …

  Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the …

  You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create …

Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test …