Unconfigured Named MSSQL Instance

If your installation errors out half way through, you may wind up with an unconfigured named instance. Short of uninstalling all of Microsoft SQL, you'll have to manually remove the instance in order to re-use the name.

Use regedit to find the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server


Under Instance Names\SQL, delete the value corresponding to your unconfigured instance. Now look for the corresponding MSSQLxx_xx.InstanceName key and delete it.

You will also want to delete the corresponding instance folder, the default path would be C:\Program Files\Microsoft SQL Server\MSSQLxx_xx.InstanceName.

Rooting the Coby Kyros

This was tested with the MID7022. This newer version of the Kyros comes with Android 2.3 and APK Installer pre-installed. If you have a different MID version, stop at step 7 and refer to CyanogenMod site for correct ClockworkMod image file. I'm using Windows 7 for the following:

1. Install Android SDK per CyanogenMod instructions.
2. Replace the contents of C:\android-sdk-windows\extras\google\usb_driver with the Telechips, Inc adb driver.
3. Connect your phone to your computer via USB, put your phone in USB debugging mode and do not mount SD card to your computer.
4. Install SuperOneClick and click Root.
5. Once complete, remount Nand and then SD card in Settings.
6. Make a backup of your current recovery image:
1. Download dump-recovery-signed.zip and save as update.zip on your SD card.
2. Turn off USB storage and go to Settings-About device-System Updates-Install system update. Choose from SD card.
3. The stock recovery will automatically be dumped as dumped_recovery.img and /proc/mtd will be copied as dumped_proc_mtd.txt on root of SD card. Keep them in safe place.
7. Install ROM Manager (ClockworkMod) from AppsLib. "Flash ClockworkMod Recovery" option does not yet work for Telechips, so we'll flash it manually:
1. Download KYROS7022-8K-recovery-signed.zip and save as update.zip on your SD card. Do the same thing as you did in step 6 to install.
2. Open ROM Manager and choose Reboot into Recovery. Allow the superuser request. To navigate the recovery screen:  MENU- = next(down), HOME/POWER = select, BACK = back
3. Go to Backup and Restore - Backup. This will create a backup of your entire system image onto your SD card. When it's complete choose Reboot system now.
8. Because CyanogenMod doesn't yet support a bunch of features (including the Kyros' strange software-based volume up/down control), I'm keeping the (rooted) stock image but I'd rather have Google Market. Here's how to install it:
1. Download Market.rar. Extract the contents of the Market folder to your SD card.
2. Remount your SD card to your tablet, open APK Installer and install in the following order:
1. OneTimeInitializer.apk (the one with the blank name)
2. SetupWizard.apk
3. GoogleServicesFramework.apk
4. Vending.apk (name shows as Market)
3. Turn your tablet off and turn it on again.
4. Next time you press the home button, a window saying “Complete action using” will appear, mark “Use by default” and choose the “Launcher”. Also, the camera shortcut on your home screen will stop working, all you have to do is delete it and re-add it.

Once you have Market on there, you'll find some things still missing. Here's a link to the latest Netflix app (1.5.2 as of 12/25/2011), Adobe Flash (10.3.186.3  as of 12/25/2011) and Pandora.

Renaming the root volume group in RHEL6

renamevg vg_oldname vg_newname

edit /etc/fstab to reflect the change
edit kernel command(s) in grub (/boot/grub/menu.lst) to reflect the change

How to Remove Carrier IQ from your HTC Phone

Carrier IQ is all the rage these days. Here are the simple steps to remove it from your HTC phone.

1. Root your phone. Google for "how to root xyz" where xyz is your phone make and model. For more HTC phones you'll use unrevoked or revolution.
2. Install Titanium Backup.
3. Go to the Backup/Restore tab.
4. Scroll to HTC IQAgent and tap it.
5. Press "Un-install !" button and confirm.
6. Do the same for IQRD.

If you really want all traces of it gone, additionally you should do the following:

• from /system/bin, remove 'iqd' and 'iqfd'
• from /system/lib, remove libhtciqagent.so, libciq_htc.so, libciq_client.so
• from /system/etc, remove iqprofile.pro
• from /data/data, remove com.htc.android.iqrd and com.htc.android.iqagent.

You should probably then clear the dalvik cache by booting into clockwork mod.

Export Users, Passwords, Server Roles from MSSQL 2005 to MSSQL 2008

Microsoft provides a useful script to export users and passwords between the two versions: http://support.microsoft.com/kb/918992

But it does not transfer the server roles. To do that, you'll need to use the following script:

DECLARE @cmd varchar(max)
DECLARE @SERVERROLE VARCHAR(100)
DECLARE @MEMBERNAME VARCHAR(100)  

CREATE TABLE ##SRV_Roles
 (
  SERVERROLE VARCHAR(100),
  MEMBERNAME VARCHAR(100),
  MEMBERSID VARBINARY (85)
 )

/*GET SERVER ROLES INTO TEMPORARY TABLE*/
 SET @CMD = '[MASTER].[DBO].[SP_HELPSRVROLEMEMBER]'
 INSERT INTO ##SRV_Roles EXEC (@CMD)

 DECLARE SERVER_ROLES CURSOR FOR
   Select SERVERROLE ,
     MEMBERNAME
   FROM ##SRV_Roles

 OPEN SERVER_ROLES
 FETCH NEXT FROM SERVER_ROLES into @SERVERROLE,@MEMBERNAME

 WHILE (@@fetch_status =0)
  BEGIN
   Set @CMD = ''
   Select @CMD = @CMD + 'EXEC MASTER.DBO.sp_addsrvrolemember @loginame = ' + char(39) + @MEMBERNAME + char(39) + ', @rolename = ' + char(39) + @SERVERROLE + char(39) + char(10) + 'GO' + char(10)
   --from ##SRV_Roles --where MemberName = @DatabaseUserName
   Print '--Login:' + @MEMBERNAME
   Print @CMD
  FETCH NEXT FROM SERVER_ROLES into @SERVERROLE,@MEMBERNAME
 END

 CLOSE SERVER_ROLES
 DEALLOCATE SERVER_ROLES

 Drop table ##SRV_Roles

Be sure to comment out the very first login for 'sa' as you cannot modify its roles.

Source