Resetting the SA password in Microsoft SQL Server

You cannot change the SA password in Microsoft SQL server like you do a users password.

To change the SA password you need to run the following command from a DOS prompt.
You will of course need to have some sort of SQL client installed.

C:> OSQL -E -S -dmaster -n -iC:\temp\sa.sql

where sa.sql contains

sp_password @new = 'will_never_forget_again', @loginame = 'sa'

> From http://vyaskn.tripod.com/administration_faq.htm#q9

Freeze rows in excel

I often use Microsoft Excel at work to collate data. One feature I’ve always had trouble with is the freeze funtion.
I could never seem to get it to freeze the columns/rows i wanted to. So the other day i sat down and tried to work it out.

  • To lock rows,  select the row below where you want the split to appear.
  • To lock columns, select the column to the right of where you want the split to appear.
  • To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

Resetting your Windows Photo Gallery Library

I kind of like using Window Photo Gallery in Windows Vista. Its a nice way to display and browse my photos.
But recently I moved my photo collection and Photo Gallery “lost” most the photos.
There didn’t appear to a way to delete a photo from the gallery without deleting it from the disk as well.

After some searching I found that what you have to do is delete or rename the file

C:\Users\[username]\AppData\Local\Microsoft Windows Photo Gallery\Pictures.pd4

via deleting photos in windows photo gallery – Vista Forums.

How to change hostname in Linux

I’m trying to build an Oracle RAC system at work to understand how it works better. As part of this I had to build three Linux systems. I built one, then cloned it (it was a virtual machine in VMware).

But having done that, it of course kept the hostname of the first machine. So I had to work out how to change that.
It turns out that is quite easy.

  • Edit file /etc/sysconfig/network using your favourite editor. In my case is nano.
  • Look for HOSTNAME=xxxxxx
  • Change the xxxx to the name you wish to set for your computer.
  • Save the file and restart the xinetd service. (eg. type service xinetd restart in your shell)
    Or simply reboot.

via How to change hostname in Linux – Techie Corner.

Resetting the root password on a Solaris server

I had to use the following step to reset a the root password on a Solaris system the other day. You will need physical access to the system to use these steps.

  1. Press Stop-A on the console or Ctrl-] and send brk from a remote console connection to access the Open Boot PROM (OBP).
    NOTE : If you are using TeraTerm-Pro, you send a break from the menu.
  2. Insert a bootable Solaris CD/DVD and boot into single-user mode with boot cdrom -s
    If a JumpStart boot server is located on the system’s subnet, and the system was properly configured for JumpStart, you may instead boot over the network into single-user mode with boot net -s
  3. Make a mount point within the /tmp file system by typing mkdir /tmp/mnt
  4. Mount the root partition of your boot disk in /tmp/mnt
    e.g. #> mount /dev/dsk/c0t0d0s0 /tmp/mnt

    NOTE : To check the device name use the format command.

  5. Edit /etc/shadow with TERM=vt100 vi /tmp/mnt/etc/shadow
  6. Remove the encrypted part of the root password (the second field; fields are separated by colons), save, and exit.
  7. Unmount the file system with umount /tmp/mnt
  8. Reboot the system and assign a new password at a shell prompt with the passwd command.

If you are unable to run vi above, you can edit /etc/shadow using the ed editor.

# ed /tmp/mnt/etc/shadow
1p
s/:………….:/::/ (Note: there are 13 dots in the second field)
1p
w
q