Wednesday, June 28, 2023

.::: Backup Database Full & Transaction & Restore Database SQL Server Alternative Full Script :::.

›
  still corelation http://teguhth.blogspot.com/2023/05/backup-database-full-transaction.html 1. check database position select @@servername ...

.::: Move SQL Server MDF and LDF Files location :::.

›
Step 1: Original Location SELECT @@servername as ServerName,name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE d...
Saturday, June 24, 2023

.::: Trouble Shooting GTID Replication, slave not running :::.

›
 1. check slave status MariaDB [teguhth]> select @@hostname,@@version; +------------+---------------------+ | @@hostname | @@version     ...

.::: Enabling GTIDs Replication in MariaDB Server for Master - Slave or Mirroring :::.

›
 1. enable /etc/hosts <optional> [root@teguhth01 ~]# cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4....
Friday, June 23, 2023

.::: Upgrading from MariaDB 10.4 to MariaDB 10.6 :::.

›
1. check Repo for 10.4 [root@teguhth ~]# cat /etc/yum.repos.d/mariadb.repo [mariadb-main] name = MariaDB Server baseurl = https://dlm.mariad...
Thursday, June 22, 2023

.::: Enable Log MariaDB MySQL & limited Size Log :::.

›
1. Check directory mariadb [root@teguhth mysql]# pwd /var/lib/mysql [root@teguhth mysql]# [root@teguhth mysql]# ls aria_log.00000001  ib_buf...
Thursday, June 15, 2023

.::: Check Number Active User SQL Server connections :::.

›
sp_who2 'active' 1. Query 1 SELECT @@servername as ServerName,a.* FROM (SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConne...

.::: List sessions / active connections on MySQL, MariaDB :::.

›
show status where variable_name like 'threads%'; 1. open tab useing cli or mysql workbench or dbviewer  
Sunday, June 4, 2023

::: Test Result Backup from Database NonEncrypted & Restore Database Encrypted and otherwise :::.

›
A. Continue from h ttp://teguhth.blogspot.com/2023/06/test-result-backup-from-database.html backup restore nonencripted/ teguh02 and restore...
Saturday, June 3, 2023

.::: Test Result Backup from Database Encrypted & Restore Database Non Encrypted and otherwise MariaDB, MySQL :::.

›
A. Environment Encrypted<teguhth01> to Database Non Encrypted <teguhth02> SELECT  NAME, ENCRYPTION_SCHEME, CURRENT_KEY_ID,@@host...

.::: Enable Encryption Table & Database for MariaDB or MySQL or MarinaDB :::.

›
  A. Pre Configure 1. Create database create database secretdb; use secretdb; MariaDB [teguhth]> create database secretdb; Query OK, 1 ro...
Friday, May 26, 2023

.::: Change Server Name in Microsoft SQL Server MSSQL :::.

›
1. Check before select @@servername as ServerName, @@version as VersionSQL; exec sp_helpserver;    

.::: Set Limit Max Server Memory in SQL Server :::.

›
1. Check Memory server    2. Capture before SELECT @@servername as ServerName,[name],[value], [value_in_use], description FROM sys.configura...