Staring MongoDB 3.x, the configuration file is YAML-based. Please note YAML does not support tab characters for indention: use spaces…
How to install MongoDB 3.x on Linux RHEL/ CentOS 7 From yum
Here I talk about installing MongoDB on RHEL/CentOS 7 by using the YUM Repository. I will be installing MongoDB 3.2…
SSL Connections in MySQL 5.7
Starting MySQL 5.7.5, MySQL server introduced SSL communication between Client & Server. Two parameters are related to SSL and RSA…
MySQL User Account Locking in MySQL 5.7
Starting MySQL 5.7.6, Now DBAs have choice to lock the account via ALTER USER or CRATE USER statements. A new…
Password Expiration Policy in MySQL 5.7
Starting MySQL 5.7, DBAs can establish the policy for automatic password expiration. Two extra columns have been added in MySQL…
No more non-empty Plugin Column Values allowed in MySQL 5.7
The MySQL 5.7 server now requires account rows in the mysql.user table to have a nonempty plugin column value. MySQL…
Have You Upgraded MySQL 5.7 Yet ?
Long Running DML transactions in SQL Server 2005
* To find out how long a transaction has been running without commiting * Any UPDATE/DELETE/INSERT T-SQL statement that is…
How to find STANDBY Recovery GAP
We have a 5-Node RAC along with one STANDBY Database for Reporting purposes. Although we a schedule job that will…
Top SQL queries taking over 2 minutes to execute
Here is the query that will show me top 5 SQL that take more than 2 minutes to execute. SELECT…