Saturday, August 25, 2007

Customize startup applications

Updated 2008-01-29

Use MSConfig.exe (from start\run) to disable their start up. Also look in "C:\Documents and Settings\All Users\Start Menu\Programs\Startup" and remove any programs that should start up. Use google to find out what each process does and why you need it.

MSConfig for Rich
InetCntrl - "Bsafe Online"
SHSTAT - Network Associates, virus scan
stsystra - comes with Dell PC, runs pc audio, need to function correctly
TBMon - Network Associates, virus scan
UdaterUI - Network Associates, virus scan

MsConfig I Unchecked
ctfmon - " Some times my Windows XP is very slow and this file is the responsable"
hpcmpmgr - HP for my printer. I will update you if I need you. Don't steal my memory!
HPWuSchd - HP for my printer.
hpztsb09 - HP for my printer.
isuspm - Install shield update service. I will update you if I need you. Don't steal my memory!
issch - Install shield update service.
jusched - Java Runtime engine updater
MvMcTray - " runs in system tray, and gives you quick access to display settings."
NvCpl - NVIDIA Display Driver Service, "an unecessary service and have had mine disabled for
years"
nwiz - "the executable for the NVidia options and control panel. You don't need it on startup,uncheck it in msconfig"

Put the following shortcuts in each user's "C:\Documents and Settings\--username--\Start Menu\Programs\Startup"

Startup for Rich
Shortcut pointing to ("C:\Program Files\Mozilla Firefox\firefox.exe" http://mail.google.com/mail/)
"C:\Program Files\Google\Google Desktop Search\GoogleDesktop.exe" /startup
Shortcut to dsclock "C:\Program Files\DS Clock\dsclock.exe"
"C:\Program Files\OpenOffice.org 2.0\program\quickstart.exe"
"C:\Program Files\Juice\Juice.exe"

For Steph only
"C:\Program Files\MSN Messenger\msnmsgr.exe" /background

For kids
"C:\Program Files\Mozilla Firefox\firefox.exe" http://www.starfall.com/

Maybe
"C:\Program Files\ClearPlay\ClearPlay Easy Updates\ClearPlayEasyUpdates.exe"
"C:\Program Files\google\GoogleToolbarNotifier\GoogleToolbarNotifier.exe"

This way, my login does not start up Windows Live Messenger. And we only have one copy of the utilities running.

Monday, August 06, 2007

RegEx trick for sql field names

A new guy at work has shown me how powerful regular expressions are. Following is a trick for formatting the columns names of a SQL table.

Do a query in SQL Query Analyzer on your table like:
SELECT * FROM table WHERE 1=0

Results in

Column1 Column2 Column3 Column4

It will return 0 rows. Be sure to return the results as text (ctrl + T), so you can just copy the header row that will have all the field names, separated by a ton of spaces. Paste the results in Notepad++. Open up the replace dialog. Check the "Regular expressions".

Find \s+

"\s" means find any white space. "+" means repeat the previous character until you don't find it anymore.

Replace with \n,

That is a new line and a comma.

The final result is

Column1
,Column2
,Column3
,Column4

Notepad++ uses the POSIX regular expression language. I look forward to using it more.