Skip to main content

Recently Updated Pages

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 6 months ago by Steve Ling

MySQL - Parameters Explained

Kiwiplan

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

Updated 6 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 7 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 7 months ago by Steve Ling

SQL - Try Catch Rollback

Database Toolset

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

Updated 7 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 8 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 8 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 9 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 9 months ago by Steve Ling

Kiwiplan - KIDSENV Settings

Kiwiplan

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

Updated 9 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 9 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 9 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 10 months ago by Steve Ling

Linux - Install KVM

Linux

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

Updated 10 months ago by Steve Ling

ESP - Delete Agent Requests For Users

Database Toolset

This removes failed jobs requests after 1 month that users are not cleaning up themselves. /* T...

Updated 10 months ago by Steve Ling

Script - Deleting a KDE server from the Database

Kiwiplan

DECLARE @ServerID INT, @UPD INT SET @ServerID = 1 --Server ID To Delete SET @UPD = 0 --0 to ...

Updated 10 months ago by Steve Ling

Apache - Server Multiple Site Setup

Apache

What you’ll need A server running Rocky 9 Linux Know the vi text editor, here's a handy...

Updated 10 months ago by Steve Ling

Kiwiplan - Install Web Launcher

Kiwiplan

This requires Java to be installed first First program that must be installed in Kiwiplan_...

Updated 10 months ago by Steve Ling

Kiwiplan - MySQL log is fill or filled the drive

Kiwiplan

This document is to explain the procedure on how to get the plant operational again. Couple of t...

Updated 11 months ago by Steve Ling

Linux - Commands to Know

Linux

This is a quick version of commands to be aware of. System information  uname -a : Displays all...

Updated 11 months ago by Steve Ling