Recently Updated Pages
MsSQL - Backups
Introduction This is to create auto backups on a SQL server and place them on a drive. Credits ...
MySQL - Cannot use select on user table
ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or ...
MySQL - Parameters Explained
performance_schema = ON tmpdir = /run/mariadb thread_cache_size = 4 table_open_cache = 16384 ...
Linux - Increase the size of a LVM Partition
This will cover how to increase the disk space for a VMware virtual machine running Linux that is...
SQL - Blocking Process
These scripts are using to help how to determine what is blocking process are occurring. SELECT ...
SQL - Try Catch Rollback
BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction ...
MsSQL - Restore Agent Jobs from Another MSDB database
This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID U...
MsSQL - Restore Master/Model/MSDB
Steps to Restore the master Database: Stop the SQL Server Instance: Open SQL Serv...
Kiwiplan - Server Load Monitor
This script is based on this initial loadmon script This is to monitor specific objects at a Adv...
Linux - Server Load Monitor Script
This is to monitor various objects on a given server and email notifications out when thresholds ...
Kiwiplan - KIDSENV Settings
MAXPROC=999 TERM=vt100 KIDSLOGDIR=$PLANT/tmpKIDSLOGMAX=1000000KIDSLOGLEVEL=-4 The KWSQL_LOG va...
Linux - Re-Mapping Drives or Combining Drives
The document is walk you through the re-mapping or combining of mapped drives on a Linux server. ...
RedHat - Install NFS Shares
NFS Server Configuration Install NFS Utilities. sudo dnf install nfs-utils Create the Shared D...
BAT - Script to Map Drives
SearchCtrl+K Chat Ctrl+J Voice Files Tasks Projects History Today This Week July A...
Linux - Install KVM
Prequisites Minimal Installed RHEL 9 with Desktop Environment Sudo user with admin righ...
ESP - Delete Agent Requests For Users
This removes failed jobs requests after 1 month that users are not cleaning up themselves. /* T...
Script - Deleting a KDE server from the Database
DECLARE @ServerID INT, @UPD INT SET @ServerID = 1 --Server ID To Delete SET @UPD = 0 --0 to ...
Apache - Server Multiple Site Setup
What you’ll need A server running Rocky 9 Linux Know the vi text editor, here's a handy...
Kiwiplan - Install Web Launcher
This requires Java to be installed first First program that must be installed in Kiwiplan_...
Kiwiplan - MySQL log is fill or filled the drive
This document is to explain the procedure on how to get the plant operational again. Couple of t...