Thursday, September 26, 2024

.::: Backup All User, Specify User , Permission, Roles, Server Roles in SQL Server :::.

›
  Untuk melakukan backup user dan privilege di SQL Server, Anda bisa menggunakan perintah Transact-SQL (T-SQL) untuk mengekstrak informasi t...
Friday, August 23, 2024

.::: Enable collect MariaDB User login Connect & Disconnect include prviledge using MariaDB Audit :::.

›
1. enable MariaDB Audit http://teguhth.blogspot.com/2022/08/enable-server-audit-in-mariadb-mysql.html 2. convert to table http://teguhth.blo...
Tuesday, August 20, 2024

.::: Script Broadcast Query in EDB / PostgreSQL to Multple Database in Linux :::.

›
1. create database sample create database db_klt_teguh; create database db_klt_teguh_dmart; create database db_klt_teguh_archive; create dat...

.::: Script Broadcast Query in MariaDB MySQL to Multple Database in Linux :::.

›
1 . create database sample create database db_klt_teguh; create database db_klt_teguh_dmart; create database db_klt_teguh_archive; create da...
Tuesday, July 30, 2024

.::: How to enable the MySQL/MariaDB general query logs :::.

›
1. enable general log temporary SET GLOBAL general_log_file='/var/lib/mysql/general.log'; SET GLOBAL log_output = 'FILE,TABLE...
Sunday, July 14, 2024

.::: Create User Access MariaDB MySQL using PAM example OS Linux Login :::.

›
  1. install pam plugin INSTALL PLUGIN pam SONAME 'auth_pam'; MariaDB [(none)]> INSTALL PLUGIN pam SONAME 'auth_pam'; ERR...
Saturday, July 6, 2024

.::: Script Backup Full + Differential + Transaction Log in MariaDB MySQL & Scheduler just like SQL Server for SingleDB & MultipleDB include Restore in One File Script :::.

›
  A. SingleDB 1. run script one time to full backup sh /data/script/scriptbackup/backup_full_log_single_db.sh   2. run script two time to lo...
Thursday, June 20, 2024

.::: How to configure Transparent Data Encryption (TDE), Monitoring & Remove TDE in SQL Server :::.

›
  A. Create TDE 1. Create Master Key USE Master; GO CREATE MASTER KEY ENCRYPTION BY PASSWORD='TDEpassword!'; GO     2. Create Certif...
Sunday, May 19, 2024

.::: Additional Environment PostgreSQL EDB example pg_ctl: command not found :::.

›
 1. Run pg_ctl pg_ctl [root@teguhth ~]# su - postgres Last login: Sun May 12 08:18:13 WIB 2024 on pts/1 -bash-4.2$ pg_ctl -D /var/lib/pgsql/...
Tuesday, April 23, 2024

.::: Enable userstat USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS, and the TABLE_STATISTICS MariaDB MySQL :::.

›
A. Enable Statistic Plugin 1. Check configuration statistic From query show variables like '%userstat%'; From mariadb configuration ...
Tuesday, April 16, 2024

.::: Backup & Restore Database MongoDB Using Mongodump & mongorestore :::.

›
Step 1: Create Direct Backups Using Mongodump mongodump   [root@teguhth ~]# mongodump 2024-04-15T14:59:40.783+0700    writing admin.system.u...
Tuesday, April 9, 2024

.::: How to enable CDC (Change Data Capture) in PostgreSQL, EDB :::.

›
1. Enable WAL (Write-Ahead Logging): PostgreSQL uses Write-Ahead Logging for durability. Ensure that your PostgreSQL server is configured to...
Saturday, April 6, 2024

.::: Convert pgaudit & pgauditlogtofile log insert into table in PostgreSQL EDB :::.

›
 continue from http://teguhth.blogspot.com/2024/02/enable-pgaudit-pgauditlogtofile-in.html 1. Create table pgaudit_log CREATE TABLE pgaudit...