SQL Management Studio Find and Replace Generated Script Tag with Variable

Replace generated script tags for values with variable

e.g. ,[SURNAME] =

becomes
,[SURNAME] = @SURNAME

use find and replace with regular expression
find expression: \<{:w+},[^\>]+\>
replace expression: @\1

This is useful for sql studio generated insert and update script

Turn off File Readonly Attribute

alway turn it off
fi.Attributes &= ~FileAttributes.ReadOnly;

flip
fi.Attributes ^= FileAttributes.ReadOnly;

Regular Expression CSV Tokeniser Update

see this link for previous blog http://me7486.blogspot.com/2008/06/regular-expression-for-parsing-csv-file_729.html

in addition to previous blogs, if you have situation like "this ""is"" not working",",right". you will need to use the following expression
((?(?=\x22)(?:\x22{1})(?<column>.*?)(?:\x22{1})|(?<column>[^,\r\n]*))(?:[,\r\n]))

Remote Desktop Automatic Logon in Windows XP (User Password Not Required)

micrsoft support link http://support.microsoft.com/kb/281262

This article describes how to turn on Remote Desktop automatic logon. By default, this version of Windows XP is configured to prompt each user to enter a password when connecting through the Remote Desktop client. This behavior holds true even when a correct user name and password are entered in the Remote Desktop Connection box before logon. This article describes how to alter this behavior.


Back to the top
Enable Remote Desktop Logon
To allow automatic logon to a computer running this version of Windows XP through Remote Desktop, follow these steps while logged on as an Administrator:

   1. Click Start, click Run, type MMC, and then press ENTER.
   2. Click File, and then click Add/Remove Snap-in.
   3. Click Add, select Group Policy, click Add, and then click Finish.
   4. Click Close, and then click OK.
   5. Navigate to the following directory:
      Local Computer Policy/Computer Configuration/Administrative Templates/Windows Components/Terminal Services/Encryption and Security
   6. Double-click Always prompt client for password upon connection.
   7. Click the Disabled box, and then click OK. You may now quit the MMC snap-in. Remote Desktop clients should now be able to connect to this Windows XP computer using the automatic logon feature of the Remote Desktop client.

Auto Scrolling C# List Box

source from this article http://www.java2s.com/Code/CSharp/GUI-Windows-Form/SetTopIndextoautoscrollListBox.htm

the key code:

eventLogList.Items.Add(data);

int itemsPerPage = (int)(eventLogList.Height / eventLogList.ItemHeight);

eventLogList.TopIndex = eventLogList.Items.Count - itemsPerPage;

Windows XP Auto Logon

http://www.microsoft.com/windowsxp/using/setup/tips/advanced/autologon.mspx

1. Run (windows run...) "control userpasswords2" and click OK.
2. Clear the Users must enter a user name and password to use this computer check box. Click OK
3. Click the User name box, type the user name that was displayed on the Start menu in step 1. If you normally type a password to log on, type your password in both the Password and Confirm Password boxes. Otherwise, leave these boxes blank. Click OK.

This will allow windows to auto logon with out asking you for password

How to stop Windows restart after an update

Solution
Windows may need to be restarted after an update has occurred, in order to allow files that are in use to be replaced. If you would prefer to restart the computer at your convenience, and not be nagged to do so, try one of the following solutions:

Method 1
Click Start, Run and enter the command net stop wuauserv
This will stop the Windows Update service until the next restart of the computer, which will stop the reminders to restart your computer for this update.

Method 2
If you are running Windows XP Professional, the following steps will increase the period between restart reminders to the maximum possible.

Click Start, Run and enter the command gpedit.msc
Select Local Computer Policy, Computer Configuration, Administrative Templates, Windows Components, Windows Update
Double-click Re-prompt for restart with scheduled installations
Change the value to 1440
Close the Group Policy Editor
Click Start, Run and enter the command gpupdate /force
This will stop the repeated reminders for this and all future Windows updates.


Here's how to prevent Automatic Update from rebooting your machine:

Start -> Run
Type: gpedit.msc
Expand Local Computer Policy / Computer Configuration / Administrative Templates / Windows Components / Windows Update
Double-click "No auto-restart for scheduled Automatic Updates installations"
Select "Enabled", then OK. Close the Group Policy configuration program.

RUN .NET Windows Application (.exe) in OSX

Install Mono http://www.mono-project.com/Main_Page

To run .NET Application Assembly exe

browse the directory contain the application and type
   
     mono YourApplication.exe

Apple Script

do shell script "mono /Users/YOU/Downloads/YourApplication.exe"

Remote Desktop Switch Full Screen Keyboard Shortcut

To switch to full screen with remote desktop (remote desktop will capture special key stroke such as alt+tab in full screen mode)

control + alt + pause

Vodafone New Zealand Internet APN Setting

What are Vodafone’s Internet APN’s?

Vodafone provide a range of APN’s (Access Point Names) that can change your connection characteristics when using 3G broadband, 3G or GPRS. The default APN used by devices will cater to the majority of Internet-based applications, however the table below contains other APN’s that are available to cater to the more specific requirements of other applications.


APN name


IP Addressing


Optimisation


Security

www.vodafone.net.nz


Public


When connection initiated in GPRS coverage


Unsolicited inbound traffic is blocked

internet


Public


No


Unsolicited inbound traffic is permitted

direct.vodafone.net.nz


Private


No


Unsolicited inbound traffic is blocked

www.vodafone.net.nz
This is the default APN used to access the Internet from the Vodafone network. It assigns public IP addresses. It will provide users with an optimised experience when the connection is created in GPRS coverage areas. Sessions initiated in 3G / 3G broadband coverage will bypass the optimisers. The security policy utilised by this APN restricts inbound initiated traffic – reducing the threat of unsolicited traffic from the internet.

Internet
The Internet APN has been designed with a more flexible security policy. It allows inbound initiated traffic, which is a requirement for some services. It is important to note that you will be exposed to and charged for this any unsolicited traffic from the Internet. This APN assigns public IP addresses and is un-optimised for all networks.

direct.vodafone.net.nz
The ‘direct’ APN bypasses the optimisers for all radio access types. It assigns private NAT’d IP addresses and employs the same security policy as the ‘www’ APN.

opt.vodafone.net.nz
The ‘opt’ APN has been created to provide a fully optimised experience across all network types. It assigns private NAT’d IP addresses and employs the same security policy as the ‘www’ APN.

ASCII Character Table

The Control Characters

The first 32 values are non-printing control characters, such as Return and Line feed. You generate these characters on the keyboard by holding down the Control key while you strike another key. For example, Bell is value 7, Control plus G, often shown in documents as ^G. Notice that 7 is 64 less than the value of G (71); the Control key subtracts 64 from the value of the keys that it modifies.

Control Characters

Char	Oct	Dec	Hex	Control-Key	Control Action
NUL	0	0	0	^@	Null character
SOH	1	1	1	^A	Start of heading, = console interrupt
STX	2	2	2	^B	Start of text, maintenance mode on HP console
ETX	3	3	3	^C	End of text
EOT	4	4	4	^D	End of transmission, not the same as ETB
ENQ	5	5	5	^E	Enquiry, goes with ACK; old HP flow control
ACK	6	6	6	^F	Acknowledge, clears ENQ logon hand
BEL	7	7	7	^G	Bell, rings the bell...
BS	10	8	8	^H	Backspace, works on HP terminals/computers
HT	11	9	9	^I	Horizontal tab, move to next tab stop
LF	12	10	a	^J	Line Feed
VT	13	11	b	^K	Vertical tab
FF	14	12	c	^L	Form Feed, page eject
CR	15	13	d	^M	Carriage Return
SO	16	14	e	^N	Shift Out, alternate character set
SI	17	15	f	^O	Shift In, resume defaultn character set
DLE	20	16	10	^P	Data link escape
DC1	21	17	11	^Q	XON, with XOFF to pause listings; ":okay to send".
DC2	22	18	12	^R	Device control 2, block-mode flow control
DC3	23	19	13	^S	XOFF, with XON is TERM=18 flow control
DC4	24	20	14	^T	Device control 4
NAK	25	21	15	^U	Negative acknowledge
SYN	26	22	16	^V	Synchronous idle
ETB	27	23	17	^W	End transmission block, not the same as EOT
CAN	30	24	17	^X	Cancel line, MPE echoes !!!
EM	31	25	19	^Y	End of medium, Control-Y interrupt
SUB	32	26	1a	^Z	Substitute
ESC	33	27	1b	^[	Escape, next character is not echoed
FS	34	28	1c	^\	File separator
GS	35	29	1d	^]	Group separator
RS	36	30	1e	^^	Record separator, block-mode terminator
US	37	31	1f	^_	Unit separator

Printing Characters

Char	Octal	Dec	Hex	Description
SP	40	32	20	Space
!	41	33	21	Exclamation mark
"	42	34	22	Quotation mark (" in HTML)
#	43	35	23	Cross hatch (number sign)
$	44	36	24	Dollar sign
%	45	37	25	Percent sign
&	46	38	26	Ampersand
`	47	39	27	Closing single quote (apostrophe)
(	50	40	28	Opening parentheses
)	51	41	29	Closing parentheses
*	52	42	2a	Asterisk (star, multiply)
+	53	43	2b	Plus
,	54	44	2c	Comma
-	55	45	2d	Hyphen, dash, minus
.	56	46	2e	Period
/	57	47	2f	Slant (forward slash, divide)
0	60	48	30	Zero
1	61	49	31	One
2	62	50	32	Two
3	63	51	33	Three
4	64	52	34	Four
5	65	53	35	Five
6	66	54	36	Six
7	67	55	37	Seven
8	70	56	38	Eight
9	71	57	39	Nine
:	72	58	3a	Colon
;	73	59	3b	Semicolon
<	74	60	3c	Less than sign (< in HTML)
=	75	61	3d	Equals sign
>	76	62	3e	Greater than sign (> in HTML)
?	77	63	3f	Question mark
@	100	64	40	At-sign
A	101	65	41	Uppercase A
B	102	66	42	Uppercase B
C	103	67	43	Uppercase C
D	104	68	44	Uppercase D
E	105	69	45	Uppercase E
F	106	70	46	Uppercase F
G	107	71	47	Uppercase G
H	110	72	48	Uppercase H
I	111	73	49	Uppercase I
J	112	74	4a	Uppercase J
K	113	75	4b	Uppercase K
L	114	76	4c	Uppercase L
M	115	77	4d	Uppercase M
N	116	78	4e	Uppercase N
O	117	79	4f	Uppercase O
P	120	80	50	Uppercase P
Q	121	81	51	Uppercase Q
R	122	82	52	Uppercase R
S	123	83	53	Uppercase S
T	124	84	54	Uppercase T
U	125	85	55	Uppercase U
V	126	86	56	Uppercase V
W	127	87	57	Uppercase W
X	130	88	58	Uppercase X
Y	131	89	59	Uppercase Y
Z	132	90	5a	Uppercase Z
[	133	91	5b	Opening square bracket
\	134	92	5c	Reverse slant (Backslash)
]	135	93	5d	Closing square bracket
^	136	94	5e	Caret (Circumflex)
_	137	95	5f	Underscore
`	140	96	60	Opening single quote
a	141	97	61	Lowercase a
b	142	98	62	Lowercase b
c	143	99	63	Lowercase c
d	144	100	64	Lowercase d
e	145	101	65	Lowercase e
f	146	102	66	Lowercase f
g	147	103	67	Lowercase g
h	150	104	68	Lowercase h
i	151	105	69	Lowercase i
j	152	106	6a	Lowercase j
k	153	107	6b	Lowercase k
l	154	108	6c	Lowercase l
m	155	109	6d	Lowercase m
n	156	110	6e	Lowercase n
o	157	111	6f	Lowercase o
p	160	112	70	Lowercase p
q	161	113	71	Lowercase q
r	162	114	72	Lowercase r
s	163	115	73	Lowercase s
t	164	116	74	Lowercase t
u	165	117	75	Lowercase u
v	166	118	76	Lowercase v
w	167	119	77	Lowercase w
x	170	120	78	Lowercase x
y	171	121	79	Lowercase y
z	172	122	7a	Lowercase z
{	173	123	7b	Opening curly brace
|	174	124	7c	Vertical line
}	175	125	7d	Cloing curly brace
~	176	126	7e	Tilde (approximate)
DEL	177	127	7f	Delete (rubout), cross-hatch box

Programming code Source http://academic.evergreen.edu/projects/biophysics/technotes/program/ascii_ctrl.htm

Programming

ASCII Control Codes

Control			Code			To Enter With			Echo
Abbreviation	Full Name		Dec	Hex		Alt-Key	Ctrl-Key
NUL	Null	0	00		Ctrl-@	^@
SOH	Start of heading	1	01	Alt-1	Ctrl-A	^A
STX	Start of text	2	02	Alt-2	Ctrl-B	^B
ETX	End of text	3	03	Alt-3	Ctrl-C	^C
EOT	End of transmission	4	04	Alt-4	Ctrl-D	^D
ENQ	Enquiry	5	05	Alt-5	Ctrl-E	^E
ACK	Acknowledge	6	06	Alt-6	Ctrl-F	^F
BEL	Bell	7	07	Alt-7	Ctrl-G	^G
BS	Backspace	8	08	Alt-8	Ctrl-H	^H
HT	Horizontal tab	9	09	Alt-9	Ctrl-I	^I
LF	Line feed	10	0A	Alt-10	Ctrl-J	^J
VT	Vertical tab	11	0B	Alt-11	Ctrl-K	^K
FF	Form feed	12	0C	Alt-12	Ctrl-L	^L
CR	Carriage return	13	0D	Alt-13	Ctrl-M	^M
SO	Shift out	14	0E	Alt-14	Ctrl-N	^N
SI	Shift in	15	0F	Alt-15	Ctrl-O	^O
DLE	Data line escape	16	10	Alt-16	Ctrl-P	^P
DC1	Device control 1	17	11	Alt-17	Ctrl-Q	^Q
DC2	Device control 2	18	12	Alt-18	Ctrl-R	^R
DC3	Device control 3	19	13	Alt-19	Ctrl-S	^S
DC4	Device control 4	20	14	Alt-20	Ctrl-T	^T
NAK	Negative acknowledge	21	15	Alt-21	Ctrl-U	^U
SYN	Synchronous idle	22	16	Alt-22	Ctrl-V	^V
ETB	End transmission block	23	17	Alt-23	Ctrl-W	^W
CAN	Cancel	24	18	Alt-24	Ctrl-X	^X
EM	End of medium	25	19	Alt-25	Ctrl-Y	^Y
SUB	Substitute	26	1A	Alt-26	Ctrl-Z	^Z
ESC	Escape	27	1B	Alt-27	Ctrl-[	^[
FS	File separator	28	1C	Alt-28	Ctrl-\	^\
GS	Group separator	29	1D	Alt-29	Ctrl-]	^]
RS	Record separator	30	1E	Alt-30	Ctrl-^	^^
US	Unit separator	31	1F	Alt-31	Ctrl-_	^_

ASCII Standard Character Set

Char	Ctrl	Dec	Hex		Char	Dec	Hex		Char	Dec	Hex		Char	Dec	Hex
NUL	^@	0	00		32	20	@	64	40	`	96	60
SOH	^A	1	01	!	33	21	A	65	41	a	97	61
STX	^B	2	02	"	34	22	B	66	42	b	98	62
ETX	^C	3	03	#	35	23	C	67	43	c	99	63
EOT	^D	4	04	$	36	24	D	68	44	d	100	64
ENQ	^E	5	05	%	37	25	E	69	45	e	101	65
ACK	^F	6	06	&	38	26	F	70	46	f	102	66
BEL	^G	7	07	'	39	27	G	71	47	g	103	67
BS	^H	8	08	(	40	28	H	72	48	h	104	68
HT	^I	9	09	)	41	29	I	73	49	i	105	69
LF	^J	10	0A	*	42	2A	J	74	4A	j	106	6A
VT	^K	11	0B	+	43	2B	K	75	4B	k	107	6B
FF	^L	12	0C	,	44	2C	L	76	4C	l	108	6C
CR	^M	13	0D	-	45	2D	M	77	4D	m	109	6D
SO	^N	14	0E	.	46	2E	N	78	4E	n	110	6E
SI	^O	15	0F	/	47	2F	O	79	4F	o	111	6F
DLE	^P	16	10	0	48	30	P	80	50	p	112	70
DC1	^Q	17	11	1	49	31	Q	81	51	q	113	71
DC2	^R	18	12	2	50	32	R	82	52	r	114	72
DC3	^S	19	13	3	51	33	S	83	53	s	115	73
DC4	^T	20	14	4	52	34	T	84	54	t	116	74
NAK	^U	21	15	5	53	35	U	85	55	u	117	75
SYN	^V	22	16	6	54	36	V	86	56	v	118	76
ETB	^W	23	17	7	55	37	W	87	57	w	119	77
CAN	^X	24	18	8	56	38	X	88	58	x	120	78
EM	^Y	25	19	9	57	39	Y	89	59	y	121	79
SUB	^Z	26	1A	:	58	3A	Z	90	5A	z	122	7A
ESC	^[	27	1B	;	59	3B	[	91	5B	{	123	7B
FS	^\	28	1C	<	60	3C	\	92	5C	|	124	7C
GS	^]	29	1D	=	61	3D	]	93	5D	}	125	7D
RS	^^	30	1E	>	62	3E	^	94	5E	~	126	7E
US	^_	31	1F	?	63	3F	_	95	5F		127	7F

Notes

ASCII (American Standard Code for Information Interchange)

is
a 7-bit character code that was introduced by American National
Standards Institute (ANSI) and is used by most U.S. personal and
workstation computers.

 

Other Common Alphanumeric Codes

EBCDIC (Extended Binary Coded Decimal Interchange Code)

was developed by IBM for use on their mainframe computers.

Unicode

is
a character coding system designed to support the worldwide interchange
and display of written texts of diverse languages by providing a unique
number for every character.

Safari Shortcut LIst OS X

 using the following link file:///Applications/Safari.app/Contents/Resources/Shortcuts.html

or

browse the content of safari application package by right click on the safari application and show package content , it is under contents/Resource

How to install / uninstall activeX OCX Component Windows IE

HOW TO UNINSTALL ACTIVE X COMPONENT

http://support.microsoft.com/kb/154850

Internet Explorer 3.0, 3.01, and 3.02

1. Click Start, point to Settings, click Control Panel, double-click Add/Remove Programs, and then click the Install/Uninstall tab.
2. If the ActiveX control you want to remove appears in the list of installed programs, click the ActiveX control, click Add/Remove, and then follow the instructions on the screen. If the ActiveX control does not appear in the list of installed programs, continue with the next step.
3. Click Start, click Run, type the following line in the Open box, and then click OK:
   regsvr32 drive:\windows\occache\filename.ocx /u
   NOTE: drive is the drive letter on which the Windows folder is located, windows is the name of the folder in which Windows is installed, and filename.ocx is the ActiveX control you want to remove.
   
   NOTE: If you do not know the file name of the ActiveX control (.ocx) you want to remove, you may be able to determine the file name by viewing the Hypertext Markup Language (HTML) source of a Web page that installs or uses the ActiveX control. To view the HTML source of a Web page, right-click an empty area of the Web page, and then click View Source.
4. In Windows Explorer or Windows NT Explorer, click the .ocx file in the Windows\Occache folder, and then click Delete on the File menu.

Occache is the name of the folder where ActiveX controls are installed in all versions of Internet Explorer 3.x. The Regsvr32.exe file is installed by Internet Explorer and can be used to register and remove registry entries for ActiveX controls.

Internet Explorer 4.x or Later (All Platforms)

Internet Explorer 4.x or later, include the Occache.dll file, which is used to enumerate, update, and safely uninstall ActiveX controls using a "shell folder."

1. Click Start, point to Settings, click Control Panel, double-click Add/Remove Programs, and then click the Install/Uninstall tab.
2. If the ActiveX control you want to remove appears in the list of installed programs, click the ActiveX control, click Add/Remove, and then follow the instructions on the screen. If the ActiveX control does not appear in the list of installed programs, continue with the next step.
3. In Windows Explorer or Windows NT Explorer, double-click the Windows\Downloaded Program Files folder or the Winnt\Downloaded Program Files folder, right-click the ActiveX control you want to remove, and then click Remove.
4. When you are prompted to remove the ActiveX control, click Yes.

IMPORTANT: The following ActiveX controls should not be removed if you are running Internet Explorer 4.0:

• DirectAnimation Java Classes
• Internet Explorer Classes for Java
• Microsoft XML Parser for Java
• Win32 Classes

Internet Explorer 5.0 or later does not require these components in the Downloaded Program Files files.

Error Messages Removing ActiveX Controls

When you attempt to remove an ActiveX control using an Occache shell folder, you may receive one of the following messages:

• Share Violation These program files are currently being used by one or more programs. Please close some programs, and try again. You may need to restart Windows.
• Component Removal About to remove a Windows system DLL: (). Okay to delete?

Share Violation:

This message occurs if the ActiveX control you are trying to remove is currently loaded in memory by Internet Explorer or the Active Desktop component.

To resolve this error message, follow these steps:

1. Close all open Internet Explorer windows.
2. Disable the Active Desktop. To do so, right-click an empty area on the desktop, point to Active Desktop, and then click View As Web Page to clear the check mark.
3. Remove the ActiveX control by following the steps in the "Internet Explorer 4.0 or Later" section earlier in this article.
   
   NOTE: You may need to restart Windows before you remove the ActiveX Control.

Component Removal:

This message occurs only in versions of Internet Explorer 4 prior to 4.01 Service Pack 1 (SP1) when the ActiveX control you are removing installed files into a folder other than a registered Occache folder (for example, Windows\System or Winnt\System32). Occache cannot always determine if those files are shared by their programs.

If you are certain the file or files displayed in the message are not being used by Windows or another program, click Yes. Otherwise, click No.

NOTE: In Internet Explorer 4.01 SP1 and later, Occache does not remove (or prompt you to remove) dependent files outside of a registered Occache folder.

Support for Multiple Occache Folders

Internet Explorer 4.0 and later supports multiple Occache folders. The list of Occache folders is located in the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ActiveX Cache

By default, Internet Explorer 4.0 and later uses the Windows\Downloaded Program Files or Winnt\Downloaded Program Files folder. If you upgraded from Internet Explorer 3.x, both an Occache and Downloaded Program Files folder may exist. In this case, all new ActiveX controls are installed in the Downloaded Program Files folder, but previously installed ActiveX controls still work in the Occache folder. When you open the Occache or Downloaded Program Files folder in Windows Explorer, Windows NT Explorer, or My Computer, all ActiveX controls are displayed regardless of the folder in which the ActiveX control's files are located. In this case, the following string values appear in the registry key:

"0"="C:\\WINDOWS\\OCCACHE"
"1"="C:\\WINDOWS\\Downloaded Program Files"
   

For additional information about ActiveX controls, please see the following article in the Microsoft Knowledge Base:

154544 (http://support.microsoft.com/kb/154544/EN-US/ ) Description of ActiveX Technologies

For information about how Internet Explorer downloads ActiveX controls if a conflict occurs (for example, if the file already exists), please see the following article in the Microsoft Knowledge Base:

196150 (http://support.microsoft.com/kb/196150/EN-US/ ) INFO: Why CONFLICT Directories Are Created During Code Download

To Install a ActiveX Component

use registry service tool

RegSvr32.exe C:\TestControl.ocx