Archive for February, 2009

Microsoft SQL – Rebuild Indexes

You can use the following command to simply rebuild all the indexes on a table.

DBCC DBREINDEX(tablename, “”,0)

MacOS – Obtain hardware information from command line

The command “system_profiler” will return all the hardware information.

Other useful commands include sw_vers, hostinfo, and uname -a.

WordPress 2.7 automatic updates.

To utilize the automatic update facility in WordPress 2.7 and greater, the files need to be owned by the same user as the user the web server runs as. For example, a linux installation would need to have the files owned by the apache user and group. I did this by using the following command:

chown -R apache.apache /usr/local/wordpress

From here, the update worked fine. The google analytics plugin worked fine as well.

Tversity in Vista Ultimate Joined to Domain/Directory

To get Tversity to install/run on a Vista Ultimate installation that is joined to a domain, I had to disable “User Access Control.” I did it via the msconfig utility executed from a “Command Prompt.” Go to Tools/Disable UAC.

Note: If Vista is not joined to a domain, you can disable “User Access Control” via Control Panel/User Accounts/User Accounts.” From there, you can click “Turn User Account control on or off.”

You have to reboot after changing the setting.

Forcing VMware session to boot in the BIOS.

Add the following to the .vmx configuration file for the guest.

bios.forceSetupOnce = “TRUE”

To check and SRV Domain Controller record in Windows 2k.

From a command prompt:
set q=srv

Adding a Windows 2008 server Domain Controller to a Windows 2003 Domain.

I used this method in a very simple configuration. I had one Windows 2003 server/forest/domain controller with a few XP/Vista clients.

From the Windows 2003 Domain Controller:

Bring up “Active Directory Domains and Trusts”, from Administrative Tools.
Right mouse click on the domain name (usually a “.local” name), and click on “Raise Domain Functional Level”.
Change the level “Windows 2003”. Note: This is not reversible and you are warned in the application as well.
Next, right mouse click on “Active Directory Domains and Trusts,” and click on “Raise Forest Functional Level.”
Change the forest level to “Windows 2003” as well. Note: This is also not reversible.
Next, copy the source/adprep directory off the “Windows 2008 Server” CD to a your Windows 2003 domain controller.
From the copied adprep directory, execute adprep /forestprep.
Then, execute adprep /domainprep.

At this point, you can run dcpromo from your Windows 2008 server. However, you need to make sure you have the “Active Directory Domain Services.” role installed.

I have run a DNS issue, and have not been able to get dcpromo to complete. Will update when I get it to work.

How rebuild Windows XP boot.ini

Boot from the installation source CD/image.

Enter the Recovery Console by pressing R when prompted.

Enter the number for the appropriate installation.

Enter “bootcfg /list” to list the current configuration.

Enter “boot /rebuild” to rebuild configuration.

At “Enter Load Identifier”, enter the name of the installation (i.e. “Windows XP”.

If prompted for “OS Load Options”, enter “/fastdetect”.

Enter “EXIT” to reboot

How To Join Two Avi files in linux.

I used this method on CentOS5 and used the rpmforge repository to install mencoder (yum install mencoder).

mencoder -forceidx -ovc copy -oac copy -o combinedfilename.avi firstfilename.avi secondfilename.avi

Return top