Skip to main content

Recently Updated Pages

Linux Server - Install RedHat 8.6

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 3 months ago by Steve Ling

Linux Server - Install Rocky 9.4

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 3 months ago by Steve Ling

Linux Server - Install RedHat 9.4

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 3 months ago by Steve Ling

Script - Data Dump Script for Internal Customer Servers

Kiwiplan

This script is to get a backup of all databases to either send them to a test server, just a back...

Updated 3 months ago by Steve Ling

Script - Import Data Script for Internal Customer Servers

Kiwiplan

This is a script to import databases, logs and preference bundles from a backup file generated fr...

Updated 3 months ago by Steve Ling

MsSQL - Backups

Database Toolset

Introduction This is to create auto backups on a SQL server and place them on a drive. Credits ...

Updated 4 months ago by Steve Ling

MySQL - Cannot use select on user table

Database Toolset

ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or ...

Updated 4 months ago by Steve Ling

MySQL - Parameters Explained

Kiwiplan

performance_schema = ON tmpdir = /run/mariadb thread_cache_size = 4 table_open_cache = 16384 ...

Updated 4 months ago by Steve Ling

Linux - Increase the size of a LVM Partition

Linux

This will cover how to increase the disk space for a VMware virtual machine running Linux that is...

Updated 5 months ago by Steve Ling

SQL - Blocking Process

Database Toolset

These scripts are using to help how to determine what is blocking process are occurring. SELECT ...

Updated 5 months ago by Steve Ling

SQL - Try Catch Rollback

Database Toolset

BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction ...

Updated 5 months ago by Steve Ling

MsSQL - Restore Agent Jobs from Another MSDB database

Database Toolset

This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID U...

Updated 6 months ago by Steve Ling

MsSQL - Restore Master/Model/MSDB

Database Toolset

Steps to Restore the master Database: Stop the SQL Server Instance: Open SQL Serv...

Updated 6 months ago by Steve Ling

Kiwiplan - Server Load Monitor

Kiwiplan

This script is based on this initial loadmon script This is to monitor specific objects at a Adv...

Updated 7 months ago by Steve Ling

Linux - Server Load Monitor Script

Linux

This is to monitor various objects on a given server and email notifications out when thresholds ...

Updated 7 months ago by Steve Ling

Kiwiplan - KIDSENV Settings

Kiwiplan

MAXPROC=999 TERM=vt100 KIDSLOGDIR=$PLANT/tmpKIDSLOGMAX=1000000KIDSLOGLEVEL=-4 The KWSQL_LOG va...

Updated 7 months ago by Steve Ling

Linux - Re-Mapping Drives or Combining Drives

Linux

The document is walk you through the re-mapping or combining of mapped drives on a Linux server. ...

Updated 7 months ago by Steve Ling

RedHat - Install NFS Shares

Linux

NFS Server Configuration Install NFS Utilities. sudo dnf install nfs-utils Create the Shared D...

Updated 7 months ago by Steve Ling

BAT - Script to Map Drives

Microsoft

SearchCtrl+K Chat Ctrl+J Voice Files Tasks Projects History Today This Week July A...

Updated 7 months ago by Steve Ling

Linux - Install KVM

Linux

Prequisites Minimal Installed RHEL 9 with Desktop Environment Sudo user with admin righ...

Updated 8 months ago by Steve Ling