Reinstall MDAC on Windows XP/2003

March 6th, 2009

I recently came across a Windows Server 2003 box that was missing the SQL Server driver from the ODBC Administrator.  After some research and trial & error I came across a really simple way to fully reinstall MDAC 2.8 SP1 on Windows.  You can’t simply download MDAC from the Microsoft Read more…

Justin articles , ,

Import an Excel Spreadsheet into SQL

March 2nd, 2009

When I started on this task, I thought it would a very simple thing to do.  I mean its a similar concept for both; rows and columns.  Well I spent two days banging my head on the desk before coming up with a solution.  
Read more…

Justin articles , ,

ProfDel - Delete All Profiles

February 19th, 2009

If you’ve got servers running Terminal Services and/or Citrix, you’ve probably realized how quickly the user profiles can build up.  I wrote a script that will allow you to remove all the profiles on the server except the ones you specify.   Read more…

Justin articles, scripting ,

IsInArray - Check for value in an array

February 18th, 2009

There have been many occassions where I’ve needed to check for a given value within an array in VBScript.  There’s no built-in function for this, so I crafted my own. Read more…

Justin articles, scripting ,

Goodbye Drupal… Hello WordPress

February 11th, 2009

I’ve made the move from Drupal to WordPress.  Its not that I hated Drupal.  Its that Drupal, with all the modules I used, caused some excessive load on the server.  Ever since version 6, things seemed to get slower and more memory intensive.  So I made the choice to use WordPress since it fits my needs and has a very good caching system.

You may notice somethings aren’t in the same spots.  Its all there.  If you can’t find it, shoot me an email and I’ll point you in the right direction.  The theme may change shortly too.

Justin news

How to uninstall SQL Server Embedded Edition (Windows Internal Database)

January 18th, 2009

Certain Windows services, such as SharePoint Services, install SQL Server Embedded Edition by default as their database.  This is the new name for the Windows Internal Database.  Unfortunately they don’t always uninstall it afterwards. Read more…

Justin articles, windows , ,

Apache error: Could not reliably determine the server’s fully qualified domain name

December 30th, 2008

When starting Apache for the first time or after a networking change you get the following error:

httpd: Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1 for ServerName Read more…

Justin articles, linux ,

Installing Munin on CentOS to monitor MySQL and Apache

December 22nd, 2008

I’ll make this guide quick and straight to the point.  Follow these steps and Munin will be up and collecting stats quickly.

Prerequisites: Apache and MySQL
Assumptions: You are monitoring the same server that munin is installed on, The server’s name is server1.example.com., /var/www = document root Read more…

Justin articles, linux , , ,

Site moved to … Linode

December 16th, 2008

Well I’ve moved this site (and about 10 others) to a new home. Everything is now hosted on Linode.

If you haven’t checked these guys out, you really need to. They offer some really unique VPS solutions for web, development, or anything else you could imagine. Here’s the list of features.

Justin news ,

DNS master and slave configuration with Virtualmin

September 4th, 2008

DNS configuration can be a daunting task.  Even seasoned server admins get tripped up over configurations.  Yep.  Myself included.

Quick Overview of DNS Master and Slave Servers
By default, Virtualmin will set you up with a master server.  Read more…

Justin articles, linux ,