How-To

Prevent Windows from Turning Off USB Devices

by File in: How-To

To save power, Windows automatically shuts down the power to USB ports.  It surely saves power, but what if it is causing you problems with your auxiliary devices or if you simply need a USB device that is always powered? Power management is also a common cause of USB-connected device issues; if Windows is able […]

How to Use DiskPart Utility in Windows

by File in: How-To

DiskPart is essentially the command-line equivalent to the Disk Management tool and can be useful in certain situations (such as when Windows won’t start). Be warned though, Diskpart is a powerful tool and unlike the Disk Management tool, it enables explicit control of partitions and volumes. You’ll need to run DiskPart in administrator mode; one […]

Export All Email from Gmail

by File in: How-To

  Even though I’m pretty trusting of the cloud in general, I still like to have my own local backups just in case something terrible happens to the Internet. If you’ve been using a service like Gmail for years and years, you probably have tens of thousands of emails in your account. One of the […]

Export SQL Data to Excel with Column Headers

by File in: How-To

How many times have you had to write up a quick query in SQL Management Studio for someone and then export the data out to Excel? Exporting data from SQL Server is a fairly long process and involves several steps, but once you do it a few times, it’s not bad. One thing I learned […]

How to Generate an Alter Table Script in SQL

by File in: How-To

In SQL 2005, you may come across a situation where you need to generate a ALTER TABLE script, such as when adding a new column to a database or changing the field type, etc. If you want to generate a script for a particular SQL function, such as CREATE, SELECT, UPDATE, etc, you would normally […]

Download Google Chrome Redistributable Package (Standalone Installer)

by File in: How-To

By default, the Google Chrome browser can currently only be downloaded and installed while connected to the Internet. The small file you download will start the installer, which will then go to the Internet to download the rest of the Google Chrome files. However, for IT administrators who want to install Chrome on computers not […]

How to Turn Off IE Enhanced Security Configuration

by File in: How-To

By default, Windows Server 2003 and 2008 ship with Internet Explorer in Enhanced Security configuration, which is basically a locked down version that adds a bit of extra security to your servers. However, if you know what you are doing, you might want to disable IE enhanced security configuration to get rid of the annoying […]

How to Schedule a Batch File to Run in XP

by File in: How-To

Previously, I wrote an article on how to create your own batch files using regular DOS commands and today I will talk about how you can schedule that batch file to run in XP. This is very useful for servers or specific computers that require the same tasks to be performed on a routine basis, […]

How to Configure Interrupt Request (IRQ) Priorities in Windows

by File in: How-To

Most components directly attached to your motherboard—including PCI slots, IDE controllers, serial ports, the keyboard port, and even your motherboard’s CMOS—have individual interrupt requests (IRQs) assigned to them. An interrupt request line, or IRQ, is a numbered hardware line over which a device can interrupt the normal flow of data to the processor, allowing the […]

How to Convert Hard Drive from FAT to NTFS

by File in: How-To

The filesystem is the invisible mechanism on your hard disk that is responsible for keeping track of all the data stored on the drive. Think of it as a massive table of contents, matching up each filename with its corresponding data stored somewhere on the disk surface. Windows supports several file system types, the top […]