How to Copy Your Backup Database to Another Server With a SQL Job
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...
Some Notable Differences in Windows 2003 and 2008
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 to Kill an Application Remotely
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...
How to Restart a Crashed Program Automatically
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...
How to Query Multiple MySQL Databases With PHP Based on the Week Day
While building a new website tonight, I decided that I wanted to present a different message to my visitors, based on the day of the week. Easy enough… using the PHP switch function, which is typically...
How to Execute a Batch File Based on a SQL Condition
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...
How to Query a Database With a Batch File
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...
Performance Issues With Intel 82574L Gigabit Network Card
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...
How to Clear Server Event Logs using Task Scheduler
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...
Deliver and Install Applications Remotely With Only a Batch File
As a Remote Administrator for a software vendor, there’s a popular challenge I often have to overcome; I need to deliver a software package to a lot of computers without using the more popular technologies...
