Monday, August 30, 2010

Recommended settings for Processor Scheduling and Memory Usage

If it is a Citrix only server (as in doesn't provide other services such as Web Interface etc) - then certainly go with the "Programs" performance setting. "Programs" as you could imagine is intended for when interactive users are running programs on the system (which is exactly what TS users do), whereas "Background Services" is tuned more for running services such as SQL, AD, IIS etc.

When you select Background Services, higher priority is given to the operating system.
When you select Applications, higher priority is given to user mode programs.

(www.brianmadden.com/forums/t/11518.aspx)

Monday, August 23, 2010

Automatically insert one-time timestamp

Automatically insert timestamps in excel sheet using formulas
http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/

Section: Back to Generating Time Stamps

Capture video frame on Media Player Classic

http://easy-tricks.blogspot.com/2010/02/take-snapshot-window-media-player.html

Note:
After changing Output option, reopen the video

Saturday, August 21, 2010

Error "Table xxx does not exist" when restoring NAV backup

- a table with data common to all companies is missing. When the NAV backup
is created, only one company was selected, and the "data common to all
companies" option was unchecked. The table object is part of the database,
but the underlying physical table is not included.
- a view that a linked table is linked to is missing. When you have a NAV
table object that is linked to a view or table on SQL Server, you will need
to create that view and/or table directly on SQL Server, before restoring
the NAV backup.

Source:
TableData does not exist
www.eggheadcafe.com/software/aspnet/34033226/tabledata-does-not-exist.aspx

Tuesday, August 17, 2010

Find duplicate rows

Locate duplicates by using conditional formatting
http://office.microsoft.com/en-us/excel-help/locate-duplicates-by-using-conditional-formatting-HA001136616.aspx
Section: Sorting the data

Saturday, August 14, 2010

Shadow the Console session of Windows 2003

How to Connect to and Shadow the Console Session with Windows Server 2003 Terminal Services
http://support.microsoft.com/kb/278845

Tuesday, August 10, 2010

Portable software(s)

portable web server: Server2Go

http://xjoss.net/forumdisplay.php/210-X-Tech-Software

www.4shared.com/dir/a9PjWRo8/sharing.html

Tuesday, August 3, 2010

Word 2007: Label Mail Merge with Watermark

How to Add Graphics to Labels in Word 2007
www.dummies.com/how-to/content/how-to-add-graphics-to-labels-in-word-2007.seriesId-77183.html

How to select image that has been sent behind the text?
To select objects that are hidden, stacked, or behind text, do the following:
On the Home tab, in the Editing group, click Select, click Select Objects, and then draw a box over the objects.
Source:
Align or arrange a picture, shape, text box, SmartArt graphic, or WordArt
http://office.microsoft.com/en-au/word-help/align-or-arrange-a-picture-shape-text-box-smartart-graphic-or-wordart-HA010192216.aspx

Note to self:
How to make image transparent:
Increase its brightness

Monday, August 2, 2010

Excel: Removing duplicate rows based on values on a column

DeleteDuplicateRows
www.cpearson.com/excel/deleting.htm