Prevent Windows from Turning Off USB Devices Can cause problems with your peripherals 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 to shut down your USB controller, it sometimes won’t be able to properly power it back up again, which will prevent some USB devices (especially scanners, cameras and some phones like Blackberry) from working....

Export SQL Data to Excel with Column Headers Save yourself a huge headache later 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 about saving SQL query results into Excel format or CSV format is that it’s best to use the SQL Import and Export Wizard rather than trying to right-click on the results and saving them....

Fix “Unsupported wireless network device detected. System Halted” Error Not easy, but give it a shot If you have an older HP computer, you may sometimes get the following error when booting up your computer: This is one of those really technical errors and it’s unfortunately not easy to fix. However, it’s worth a shot before sending your computer back to HP or dishing out lots of money to the Geek Squad....

How to Generate an Alter Table Script in SQL It can be confusing at first 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 just right-click on the table in SQL Management Studio and chooseScript Table asand then the function you want to script....

Fix “File is too large for destination file system” Error Several different methods to choose from Yesterday, while copying some large files to an external hard drive, I was promptly issued this message by Windows: So I wondered to myself what could possibly cause this issue. My external hard drive had tons of free space, so why would I not be able to copy this file over? Well, the reason for this problem is because my file was 4....