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-684cfdafeca0f750988383/] 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 »role “x” cannot be dropped because some objects depend on it
If you want to delete the PostgreSQL user, we can get the error “role x can not be dropped because some objects depend on …
Read More »FORCE LOGGING On Oracle
Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …
Read More »SQL Server Best Practices and Configurations that need to be made After Installation
In this article, we will examine the configurations that need to be made after SQL Server Installation. You can find the details of the …
Read More »