Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 …
Read More »How to List PostgreSQL Users and Permission
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 …
Read More »How To Change PostgreSQL User Password
In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script. [crayon-6741afae270b7163444492/] …
Read More »What is FLASBACK DATABASE And How To FLASHBACK
Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …
Read More »How To Create a Linked Server To Connect To SQL Server From SQL Server
I have described to create linked server to connect to oracle from sql server in my article titled “How To Create a Linked Server …
Read More »How To Find PostgreSQL lib and bin Directories
We find the bin directory of PostgreSQL using the command below. [crayon-6741afae275fc772769238/] You can see this directory in the white box in the screen …
Read More »How To Create a Linked Server To Connect To Oracle
In some cases, a database that resides on SQL Server may require the data to be retrieved from the Oracle database. Requirements First, …
Read More »How To Define a New Login To The Linked Server
Previously, I have described the definition of a linked server to connect to Oracle in my article titled “How To Create a Linked Server To …
Read More »How To Give Permission To Developers For Change Their Passwords On SQL Server(Grant Alter)
Sometimes developers need a permission for change their login’s password. if you do not give them to necessary permission they can not change their …
Read More »What is logging_clause On Oracle(LOGGING or NOLOGGING)
With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …
Read More »