Gallery2 Random Highlight Mod
There's a SQL technical limitation where one may not update a table based on its…
0 Comments
MySQL Update Statement
UPDATE _vldmembers_data_membersSET data_gender2=3WHERE data_gender1=1;UPDATE _vldmembers_data_membersSET data_state=469WHERE data_city LIKE 'Kansas%';UPDATE _vldmembers_data_membersSET data_state=457WHERE data_city LIKE 'colorado%';UPDATE _vldmembers_data_membersSET…
0 Comments
Bandwidth Calculator
Convert Kbps to GB/month Formula =A2*60*60*24*30/8/1000/1000 (use Excel) ------------------------------------------------ 20000 Kbps = 6480 Gb/month 950…
0 Comments
MySQL: update with Join Tables
Let's say for example you have a product table which stores information about products and…
0 Comments
SQL replace character in string
update g2_Item set g_title = replace(g_title, '_', ' '); update g2_Item set g_title = replace(g_title,…
0 Comments
Exchange 2007 Installation Notes
- Installing as co-existence with Exchange 2003 - Must install these services in order: Client…
0 Comments
How to check to see if your email domain is blacklisted
Find your IP address: https://www.whatismyip.com/ Test the real-time spam list matching your IP: Check…
0 Comments
Some Windows Tools
Change Office Product Key 2003 2007http://support.microsoft.com/kb/895456 How to enable Remote desktop remotely (another article on…
0 Comments
CCIE Exam Day Overview
1. Network Principles 2. Layer 2 Technologies: LAN switching & WAN Circuits, layer 2 multicast…
0 Comments
Fix 4GB Limitation on a Windows 32BIT OS
PatchPae (v2) by wj32. Tested on: Windows Vista SP2, Windows 7 SP0, Windows 7 SP1,…
0 Comments
Quick 1-liner: Secured File Transfer using PSCP
pscp.exe c:\origin\ root@serverIP:/path_to_destination
0 Comments
Fix: Error”The security log on this system is full”
This may be followed by "The terminal server has exceeded the maximum number of allowed…
0 Comments
How to find MacOS Version
From the Apple menu, choose About This Mac. The version number of OS X you're…
0 Comments
Great GPL Windows Admin Tools
1. Wireshark 2. amanda.org (backup server) 3. mailarchiva.com (mail backup) 4. http://rbac.codeplex.com (remote admin for Exchange servers) 5. Core Configurator, ,…
0 Comments
Disable / Enable Admin Shares
Restore Administrative Shares To restore administrative shares so that they are automatically created in Windows:…
0 Comments
FreeNAS
Features: OpenVNP plugin https://joepaetzel.com/2013/09/22/openvpn-on-freenas-9-1/ FTP server Web server SAMBA etc. How to install: -…
0 Comments
How to Repair Windows Using CD or USB flash drive
Scenario 1: after PAEPATCH 32Bit Windows to use more than 3.5 GB or RAM, sometimes…
0 Comments
Strategies to Free Up Disk Space C:\ Drive
1. Move pagefile away from system drive (optional) 2. Turn off System Restore (warning; this…
0 Comments