Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …
Read More »How To Improve Database Performance on MongoDB Part 1
This little guide is medium in scope, it is not exhaustive. It just gives you an idea to focus 1 Choose the right storage …
Read More »RDS to RDS Database Refresh-Oracle
This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases Prerequisites: RDS Instances …
Read More »How To Move Logins To Another Instance(sp_help_revlogin)
If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …
Read More »Rack Awareness by Sohel Teli
Rack Awareness: Rack awareness is having the knowledge of Cluster topology or more specifically how the different data nodes are distributed across the racks of …
Read More »Bash Script for Mysql General Log Rotation
Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing …
Read More »Creating an ODBC Connection to Teradata for Excel
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows …
Read More »ARCn:Switch failed , ARC1:Switch failed
This error is taken when the archive log target directory is filled in databases that are in archive log mode. SOLUTION: As a solution, …
Read More »How To Create a Login On SQL Server(Manage Logins)
From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …
Read More »Bash Script for Mysql Error Log Rotation
Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-662a4f46cf4c3264049667/] Hope this …
Read More »