IsInArray - Check for value in an array

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.

 

Function IsInArray(strIn, arrCheck)

    'IsInArray: Checks for a value inside an array

    'Author: Justin Doles - www.DigitalDeviation.com

    Dim bFlag bFlag = False

    If IsArray(arrCheck) AND Not IsNull(strIn) Then

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

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.

To remove the 32-bit (x86) version:
msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

To remove the 64-bit (x64) version:
msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe

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

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

This message is more of a warning than an error. If you check your running processes you will see the httpd process running. Basically Apache is telling you that it doesn't know the host name of your server. This is a simple fix.

Installing Munin on CentOS to monitor MySQL and Apache

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

Site moved to ... Linode

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.

DNS master and slave configuration with Virtualmin

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

How to export Google Maps markers

So you've used Google's cool My Maps feature and laid out your map. What if you want to then export the data to KML or GeoRSS format for editing? As of now, there's no easy one click way to do it. But alas, it can be done and its really easy. Open up your map. Across the top right of your map you will see a few options; View in Google Earth, Print, Send, and Link to this page.

COM+ and DCOM Troubleshooting

DCOM. I'm sure it sounded like a good idea at the time, but in the real world it generates a lot of headaches. Here's some common DCOM, COM+ and WMI errors along with some fixes. There's also some scripts and registry keys at the end of article to help automate the fixes.

CoCreateInstance Errors

MySQL Database Export and Import

Here's a couple quick tips to help you export and import a MySQL database. This is great when you're looking to move servers or just make backups of the data. I know lots of people use phpMyAdmin to manage their MySQL servers (as do I). But sometimes you need to get at large amounts of data. Web based apps won't cut it. You'll need shell access (ssh).

PHP header redirect

PHP header redirect Redirect users to another page or site using header: Location

At times, you may find yourself moving pages around or even changing domain names. Using the header function of PHP we can direct visitors (and search engines for that matter) to the new location with 3 lines of code.

<?php
header ('HTTP/1.1 301 Moved Permanently');
header ('Location: http://www.example.com/newpage.php');
exit;
?>

Syndicate content