.::: Cannot Remote Desktop Connection : An Authentication error has Occured. Due to CredSSP Encryption Oracle Remedian :::.

 

1. Open Registry

2. Open Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\CredSSP\Parameters

3. Double-click the AllowEncryptionOracle DWORD to open its Edit DWORD window.

Enter the value ‘2‘ in the Value data text box, and press the OK button.

.::: Create & Test Maintenance Cleanup Task in SQL Server MSSQL :::.

1. Create Maintenance Plan

.::: Install Database Oracle 19C in Linux Centos 7 :::.

 .::: Install Database Oracle 19C in Linux Centos 7 :::.

1. Disable firewalld

[root@teguhth ~]# systemctl stop firewalld

[root@teguhth ~]# systemctl disable firewalld

Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@teguhth ~]# 

2. add /etc/hosts

[root@teguhth ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.10.50 teguhth

[root@teguhth ~]# 

.::: Latihan SSIS convert csv file to SQL / MSSQL :::.

1. Create database on SQL Server 

create database LatSSIS;

use LatSSIS;

go

.::: Configure log shipping SQL Server :::.

 to monitor log shipping

http://teguhth.blogspot.com/2023/09/monitor-transaction-log-shipping-using.html

1. Enable Log Shipping on Database 1

.::: How to Install Replica SQl Server (MSSQL) include distributor, publisher, subscriber :::.

1. Enable SQL replication setup

2. configure a SQL replication distributor

.::: Testing Failover Always On SQL Server (MSSQL) and collect Log after Failover :::.

 

A. Failover using GUI / SQL Management Studio

1. Capture always on before Failover

.::: SQL Server: how to simulate and catch deadlock :::.

1. Create database 

create database dead_lock_lab

go 

2. create table & row data 

USE dead_lock_lab;

 

CREATE TABLE dbo.invoices (

   id int NOT NULL,

   num nvarchar(20) NOT NULL,

   customer nvarchar(100) NOT NULL,

   created_at datetime NOT NULL,

   updated_at datetime NOT NULL,

   CONSTRAINT PK_invoices PRIMARY KEY (id)

);

 

.::: How to Sample Simulation Blocking SQL Server & Trouble shoot :::.

 

1. Login to database and create database

create database blocking;

go 

2. Open 1 Session to New Quary Windows

Begin Tran ;

select 'query 1'

CREATE TABLE ##Employees (

    EmpId INT IDENTITY,

    EmpName VARCHAR(16),

    Phone VARCHAR(16)

)

GO

INSERT INTO ##Employees (EmpName, Phone)

VALUES ('Martha', '800-555-1212'), ('Jimmy', '619-555-8080')

GO

CREATE TABLE ##Suppliers(

    SupplierId INT IDENTITY,

    SupplierName VARCHAR(64),

    Fax VARCHAR(16)

)

GO

INSERT INTO ##Suppliers (SupplierName, Fax)

VALUES ('Acme', '877-555-6060'), ('Rockwell', '800-257-1234')

GO

 

.::: Install PAF (PostgreSQL Automatic Failover ) on centos7 ( base on pacemaker, pcs, corosys ):::.

 

A. Install PAF 

1. Prepare Node 

Node01 

10.10.10.241

Node02

10.10.10.242

Ip Virtual 

10.10.10.243

2. Install pacemaker, corosys, pacemaker & configuration 

insttal pcsd

https://teguhth.blogspot.com/2018/08/how-to-install-and-configuration-pcs.html

.::: How To Set Up Redis as a Cache for MariaDB / MySQL with PHP :::.

1. Install Redish

https://teguhth.blogspot.com/2021/08/how-to-install-database-redis-on-centos.html

2. Install lamp

[root@teguhth /]# yum -y install php libapache2-mod-php php-pdo php-json php-cli

3. Install MariaDB

https://teguhth.blogspot.com/2017/10/install-mariadb-101-on-centosrhel-using.html

.::: How To Install Database Redis on Centos 7 :::.

1. Enable repository

[root@teguhth data]# yum -y install epel-release yum-utils

[root@teguhth data]# yum -y install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

[root@teguhth data]# yum-config-manager --enable remi

[root@teguhth data]# 

.:: How To Replicate Set (Redundant /Mirroring) MongoDB 5.0 on Centos 7 :::.

A. Configuring the Replica Set

1. Setting up the environment Add /etc/host to nodeA nodeB 

[root@teguhth01 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.10.21 teguhth01 NodeA

10.10.10.22 teguhth02 NodeB

[root@teguhth01 ~]# 

[root@teguhth02 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.10.21 teguhth01 NodeA

10.10.10.22 teguhth02 NodeB

[root@teguhth02 ~]#