Archive for July 2011

Courion Tip – T-SQL string parsing

Here’s the scenario… I have to generate SNC user names from the user profile table. I was told that it starts with a p:, and that the domain part of the email address HAS to be upper case. So, for instance

dummy.user@example.com would have an SNC name of p:dummy.user@EXAMPLE.COM

Here’s the custom macro I came up with:

select 'p:'+
LEFT(EMAIL_ADDRESS,CHARINDEX('@',EMAIL_ADDRESS))+
UPPER(RIGHT(EMAIL_ADDRESS,LEN(EMAIL_ADDRESS)-CHARINDEX('@',EMAIL_ADDRESS)))
from PROFILE
where EMP_ID =

Posted July 28, 2011 by mmdmurphy in Courion Tip, SQL, tips

Tagged with

Courion Tip – Handling large files

const DEF_REQRESP_TIMEOUT = 300

in “D:\Program Files\www\utils\ConfigMigration\utils.asp”

Try setting this to larger values

Posted July 13, 2011 by mmdmurphy in Courion Tip

Windows user profile

Netsetman

http://lifehacker.com/5819871/a-hassle+free-approach-to-making-your-windows-pc-adapt-to-your-environment

http://www.netsetman.com/

Posted July 12, 2011 by mmdmurphy in freeware, windows

Forensic ISO images

CAINE… www.caine-live.net

Posted July 11, 2011 by mmdmurphy in freeware, Linux, security

Tagged with

Courion Tip – HTML, Javascript and Whitespace

The issue was that the screens had a lot of extra spaces in them after a number of javascripts were implemented. When you went to the page, there was text at the top, then a number of blank lines, then more text. If you did a view source in Internet Explorer, you would see a number of paragraph marks and line breaks, but I could not determine where they were coming from.

Here’s what the Form Instructions (under Change, Unique Resource data) looked like (I deleted the text part as it wasn’t needed to illustrate my point):

Here’s the visually – UN – appealing version, but it doesn’t generate the unwanted whitespace – just to be completely clear, it’s ALL strung together into one line….

Posted July 11, 2011 by mmdmurphy in Courion Tip

Tagged with

Key tweak

Note to self … Check out key tweak for windows 7

Posted July 6, 2011 by mmdmurphy in Uncategorized