Wednesday, January 31, 2024

.::: Create user limited to access only spesific table or specific view, store procedure,function in MariaDB MySQL :::.

›
corelation http://teguhth.blogspot.com/2022/08/create-user-admin-readonly-database.html A. create user only akses 1 table 1. create user on...
Monday, January 29, 2024

.::: Install PostgreSQL ODBC Driver on Linux & test DSN or odbcins.ini and odbc.ini Access PostgreSQL using ODBC :::.

›
1. install odbc postgres yum install unixODBC unixODBC-devel postgresql-odbc -y [root@teguhth data]# rpm -qa | grep -i odbc msodbcsql18-18.3...

.::: Change the file created date & Modified file in Linux :::.

›
  1. check size & time file [root@teguhth data]# ls -lh total 932K drwxr-xr-x 3 root root   19 Jan 17 18:01 backup -rw-r--r-- 1 root roo...
Tuesday, January 23, 2024

.::: Shell Script to Get CPU Memory Usage (%), Swap (%) & Local Check, all_check GTID Mirroring,IP & Hostname,uptime MariaDB in Centos 9 Redhat 9 Rocky Linux 9 :::.

›
 1. local check ##[root@teguhth data]# cat local_check.sh #  cat check_cpu_mem_usage.sh #!/bin/bash date #CPU=$(top -bn1 | grep load | awk ...
Saturday, January 20, 2024

.::: Create a dblink to a remote server MariaDB MySQL MarinaDB in Linux to MSSQL SQL Server 2022 in Windows Server 2022 using ha_connect,unixODBC,odbcinst.ini :::.

›
A. Install & Configuration DBLink 1. install haconnect in Linux Redhat before  http://teguhth.blogspot.com/2024/01/install-configure-odb...
Tuesday, January 16, 2024

.::: Install & Configure odbcinst.ini ODBC for MSSQL SQL Server, Oracle, MySQL MariaDB, PostgreSQL in Linux Centos 7, 8, 9 :::.

›
 A. ODBC Linux for MSSQL 1. prefer link https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-fo...
Sunday, January 14, 2024

.::: Create a link or dblink to a remote server MariaDD MySQL to MSSQL SQL Server using ha_connect :::.

›
 A. Configure dblink MariaDB 1. install plugin ha_connect INSTALL SONAME 'ha_connect'; 2. install driver Driver=SQL Server Native Cl...
Monday, January 8, 2024

.::: Create sample multiple dblink MariaDB MySQL to run multiple query Inner Join, Normal Join :::.

›
1. correlation dblink https://teguhth.blogspot.com/2024/01/create-link-or-dblink-to-remote-server.html 2. check normal query from remoteserv...

.::: Create a link or dblink to a remote server MariaDB MySQL using federated ha_federatedx.so plugin :::.

›
A. Sample other database to get database (source) create database teguhth_maria_dwh; use teguhth_maria_dwh; create table barang( KODE_BARANG...
Friday, January 5, 2024

.::: Script to check File backup Database MariaDB MySQL , SQL Server MSSQL success or not in NAS or FS :::.

›
  1. sample for linux backup mariadb & windows sql server db linux db_mariadb_teguh; db_mariadb_teguh_dmart; db windows db_mssql_teguh; ...

.::: Create Quary Daily Backup All Database MariaDB MySQL & retention and Crontab :::.

›
1. Create script all backup using custom ##[root@teguhth backup]# cat backuptest.sh echo "" Server=$(hostname) ip_address=$(ip a |...

.::: How to migrate a SQL Server database to a lower version or Downgrade MSSQL 2022 to 2019 or lower ::.

›
As of my last knowledge update in January 2022, SQL Server 2022 had not been released. However, if you're using a newer version of SQL S...
Tuesday, December 19, 2023

.::: Grouping if using filter Day,date & year in MariaDB MySQL :::.

›
1. correlation with archive table http://teguhth.blogspot.com/2023/12/grouping-sql-server-by-dateday-dan_18.html 2. sample query all selec...