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

  You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …

  When you see an error, such as in the following screenshot, you may consider why your database is trying to access a hidden system …

  When you run the make command when installing Oracle_fdw, you may encounter the error as follows. The reason for this error is that the …

  In this article, I will show you how to move a table to another tablespace. Actually it is very simple to move table with …

  You need the utl_mail package to send e-mail from the database. To use this package, the smtp_out_server parameter must be set. Also, “network acl” …

  If you are not using any backup software, you may not be able to back up large databases to a single disk. In such …

  For the database, the use of bind variables in queries is quite important. The hard parsing process in the database will increase when bind …

  You can backup all databases on an Instance with the help of the following script (except tempdb) You should write the path you want …

  This is probably one of the trickiest question that as DBA I get, and trust me, it happens very often and the funny thing …

  When you set the resource_limit parameter to true in the database and set the idle_time parameter in the profiles to a value other than …