A few weeks ago a client called around 11:00 pm and said that they received an error in a very critical Microsoft SQL Server …
Read More »SQL Server AlwaysOn Availability Groups step by step
I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …
Read More »Upgrade Oracle Opatch Version
OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …
Read More »How To Fetch Explain Plan
Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …
Read More »How to Unlock an Expired Oracle User Whose Password is Unknown
In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …
Read More »Why is so much data being written into DBQL?
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …
Read More »Oracle Password Expired Error
In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …
Read More »Solution of Makefile54 Error On PostgreSQL
You may receive an error as follows when you try to install a different extension package that is not in Postgresql’s repo. To solve …
Read More »How To Execute a Script on Multiple Instance with Registered Server
Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …
Read More »How To Migrate MSSQL Server Logins To Another Instance
Step 1: Create SP sp_help_revlogin on master database of Source / Primary instance The following script create two stored-procedures. You will use the first one …
Read More »