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

  First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …

  In this article we will examine how to give permission to a user in PostgreSQL. You should click on the Postgres menu item for …

  First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …

  You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …

  In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …

  Account Lockout Policy is a security mechanism used by SQL Server. For example, consider someone who is trying to log in with a user …

  Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …

I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download and install the script that …

In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …

  With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …