I needed to run a cron job that would allow me to split up my database queries and lessen the load on my host’s processor. My MySQL queries were taking 2 – 3 minutes to run. Step 1: Make...

The time has come to enter the world of VPS Hosting.  I recently launched my 100th website and I have pretty much maxed out my shared hosting plan.  I run a Python script to watch memory and my memory...

I had a client call and inform me that their TSM (Tivoli Storage Manager) backup agent wouldn’t work on their database server.  This essentially defeats the purpose of TSM but they asked if I could...

If you’re just now migrating to a Windows 2008 Server, there’s a few subtle nuances that you might want to be aware of.  These are just some FYIs to make your System Administration life a...

How do you kill an application that’s running on a remote computer if RDP (mstsc) isn’t available?  Yesterday, I talked about a great little program that would restart your hanged applications...

Ever have an server application that you absolutely need to keep running but it continues to give you problems? Well over a year ago, I was getting to the point of swearing at a particular program that...

As a Network Administrator, you might have a situation where you need to execute a batch file, based on a SQL condition. In short, here’s the logic I needed to work out: - Check for SQL condition...

No doubt there are times when you need to query MSSQL but Query Analyzer isn’t at your disposal. The answer? Use a simple batch file! OSQL is a powerful utility that should already exist on your...

If you’re running an Intel 82574L Gigabit Network card and seeing performance issues, you might try the following: Under Performance Options —> Interrupt Moderation Rate —> changed...

I sometimes run into a problem with the event logs filling up.  There are options to overwrite but I find a quicker and neater method to just blow them all away by putting this in a .vbs file and schedule...