There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the database restarted automatically. So there …
Read More »Oracle – Recreate Central Inventory in Clustareware in Linux
In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …
Read More »MySQL Schema comparison between PROD and UAT/DEV Servers
Hello Folks, Today I’ll be writing an article on how to do schema comparison of MySQL database between 2 servers(For eg. : PROD and …
Read More »COLUMN ENCRYPTION WITH POSTGRESQL TRIGGER
In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-676ba354d2e6f054589128/] Then we …
Read More »How To Add MS DTC To The Cluster
In this article I will tell you how to add the MS DTC service to the windows cluster. First, we open Disk Management. You …
Read More »Numa Nodes, MAX/MIN Server Memory, Log Pages In Memory and MAXDOP
In this article, we will examine the settings that should be done on a Numa Node system. You must make these settings on systems …
Read More »HANA DB Replication Installation
Greetings, In this paper, I will describe the Replication structure and installation stages of the HANA Database, which is the HA (High Availability) feature. …
Read More »Installation of MySQL Enterprise Monitor
MySQL Enterprise Monitor is a tool that register several MySQL Instances and provide complete details i.e. performance graphs and other details for analysis, Costly …
Read More »MySQL Auditing
MySQL Community Edition: MySQL Community Edition having feature of auditing but I cannot having feature filter the users To activate audit log: [crayon-676ba354d3380500764141/] …
Read More »How To Change the Size of Redo Log Files
In order to change the size of the Redolog files, it is necessary to create redolog files of the desired size and drop the …
Read More »