Archives

When Upgrading your Video Card...

Always remember, when upgrading your video card to make sure your power supply can handle it! That is all.

Working with Large Lists

Photo by Stuart Miles
Bossman got you facepalming on your latest project? Working with large subscriber or customer information lists can be a headache. You may run into a project where you have to combine several types of lists with different column information and they don't match up with your new system. You might have to prune, merge, cut or otherwise make sure a huge list is clean/tidy. Microsoft Excel can handle csv files, but keep in mind that Excel does have its limitations:

Microsoft Excel has size limitations:

Here are some alternate tools and information I've run into to help maintain your larger lists:

CSVed
For managing large CSV files (think super-excel):
http://csved.sjfrancke.nl/

CSV Splitter
For splitting huge CSV files (can keep header and apply to split files):

Combine using Command Prompt
How to combine several CSV files into one file using cmd:

Move IIS Log Files in SBS2008

C:\ Drive on your server looking a little... Fat?
Here's a good tip to save you some C:\ drive space in SBS2008. You can move the location of your IIS log files, potentially freeing up some significant space on your system drive. The default location of those files is C:\inetpub\logs\LogFiles. In this example, I'll explain how I moved them to my "E" drive under E:\inetpub\logs\LogFiles instead.

First thing is to create a new folder where your IIS log files will be saved. I decided to use the same naming scheme as the default but just on a different drive. In this case, I went to my "E" drive and created a folder named "inetpub" with a subfolder named "logs" inside. Inside of "logs" I added a new subfolder named "LogFiles". The full path looks like this - E:\inetpub\logs\LogFiles

As with most things, you'll want to create a backup of your log files to be safe.

If you're running Windows Small Business Edition 2008, go to the Administrative Tools menu (located in the Control Panel or on your Start Menu) to open the "Internet Information Services (IIS) Manager". You want to select your top level item - it should look something like "SERVERNAME (DOMAIN\username)". On the right menu, you'll see an icon for "Logging" that you'll want to open.
See that Logging icon, double-click it

Once in your "Logging" menu, you'll want to change the Directory location to your new folder. You can either type/paste the new location or browse to the folder you want to use. When done, select the "Apply" action on the far right pane. 

Make sure to hit "Apply" when you're done!


Each of these areas have menus like the first where you can change the "Logging" directory from the default to one of your choosing. Rinse and repeat the above steps with each of these sections to make sure they're all redirected:
Each of these have Logging settings, check all that you have

You'll notice when this is done that your old Log files are still in your C:\inetpub\logs\LogFiles folder. I just cut and pasted those subfolders into the new directory. If it asked me to replace any of the files I told it to move but keep both files (rename).

I freed up a couple of gigabytes and still was able to keep my logging active. You never know when you'll have to reference them so it's always good to keep them around.