In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-662adac2c138d451920921/] 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-662adac2c1e6c451401382/] …
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 »How Many Redo Log Switches Per Hour
If Redo Log Switch count is too much, you can increase the redo log sizes if you need. However, the larger the Redo Log, …
Read More »What is Buffer Pool Extension
Buffer Pool Extension is a feature that was introduced in SQL Server 2014. With this feature, SQL Server uses the disk we specified for …
Read More »Foreign Data Wrapper Between PostgreSQL and MSSQL
In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …
Read More »