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

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 …

  You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important configurations in sp_configure. First we …

In this article I will share a few scripts in postgres databases that I think will help you manage your users. The easiest way to …

  In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script. [crayon-67d3ddaaa94cf425769196/]   …

  Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …

  I have described to create linked server to connect to oracle from sql server in my article titled “How To Create a Linked Server …

We find the bin directory of PostgreSQL using the command below. [crayon-67d3ddaaa9ad6187144255/]   You can see this directory in the white box in the screen …

  In some cases, a database that resides on SQL Server may require the data to be retrieved from the Oracle database.   Requirements First, …