Sysadmin: View stored logon information for network locations and web sites

rundll32.exe keymgr.dll, KRShowKeyMgr

Batch Scripting: Makecert.exe

Problem: Special options must be specified with makecert.exe, to create a self-signed certificate that can be used with IIS (Microsoft Internet Information Server).

Note: Microsoft recommends to install and use the "Certificate Server" to generate an SSL test certificate (Q216907), instead of using makecert.exe. But using makecert is simpler.

Solution:

The following command can be used to create and import a self-signed SSL test certificate:

makecert -r -pe -n "CN=www.yourserver.com" -b 01/01/2000 -e 01/01/2036 -eku 1.3.6.1.5.5.7.3.1 -ss my -sr localMachine -sky exchange -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12

To install this certificate in IIS 5.0, open the IIS "Web Site Properties", "Directory Security", "Server Certificate...", "Assign an existing certificate" and select the new certificate from the list.

Note: Older versions of makecert.exe do not support the "-pe" option, which makes the private key exportable. If you have an old version of makecert.exe, you can omit the "-pe" option, but then the certificate cannot be exported including the private key.

(The October 2002 version of the Platform SDK (build 3718.1) contains a new version of makecert.exe (5.131) that supports the "-pe" option. The .NET Framework SDK 1.0 of 2002-03-19 contains an old version of makecert.exe that does not support the "-pe" option).

If the private key is exportable, you can export the certificate together with the private key into a PFX (PKCS #12) file as described in Q232136.

Note: SSL server certificates for IIS are stored in the "Personal" ("My") certificate store of the "computer account" ("localMachine"). The "Certificates" snap-in of the Microsoft Management Console (mmc.exe) must be used to manage these certificates. The normal certificate management window (accessible via "Internet Properties" / "Content" / "Certificates" or via "Control Panel" / "Users and Passwords" / "Advanced" / "Certificates") cannot be used.

Note: To create a key with more than 512 bits, use the "-len" parameter of makecert.exe.

Ref: www.inventec.ch/chdh/notes/14.htm

Ref: msdn.microsoft.com/en-us/library/bfsktky3(VS.80).aspx

HTML Email: Problems with uniformity across desktop and web based clients

There seems to be a lot of quirks when rendering HTML/CSS content in email clients whether they be desktop or web based clients.

This article is useful when comparing tags that are supported by various clients.

www.campaignmonitor.com/css/

And here's a code validator from mailchimp:

www.mailchimp.com/add-ons/inboxinspector/ (too bad its not free)

Before gmail became popular, alot of developers where putting the style tag inside the body tag, however since gmail now strips this out, unfortunately, the only sure way to handle CSS in your email is to do them in-line.

TSQL: Comma Delimited List from column values

-- SQL 2000, Retrieve desired data

-- With SQL 2000, we will create a User Defined Function to do the concatenation.

-- While this solution can also be used with SQL Server 2005/SQL Server 2008,

-- the previous suggestion is more efficient.

CREATE FUNCTION dbo.fnMakeCommaDelimitedList

( @TempID int )

RETURNS varchar(1000)

AS

BEGIN

DECLARE @TempTable table

( TempValue varchar(20) )

DECLARE @TempList varchar(1000)

SET @TempList = ''

INSERT INTO @TempTable

SELECT DocumentId

FROM TechnicalDocSubscriberDoc

WHERE SubscriberId = @TempID

IF @@ROWCOUNT > 0

UPDATE @TempTable

SET @TempList = ( @TempList + TempValue + ', ' )

RETURN substring( @TempList, 1, ( len( @TempList ) - 1 ))

END

-- Usage

SELECT

ID, contactname, companyname, email, email, companyadd, suburb, state, postcode, contactphoneno,

SubscriberList = dbo.fnMakeCommaDelimitedList( ID )

FROM technicaldocsubscriber

GROUP BY ID, contactname, companyname, email, email, companyadd, suburb, state, postcode, contactphoneno

-- Clean up

DROP FUNCTION dbo.fnMakeCommaDelimitedList

Chrome: Proxy Pac

Our company utilise a proxy pac file for internal users to access the outside world.

For chrome you'll need to add the following extensions:

"drive:\chrome install location\chrome.exe" --proxy-pac-url="http://proxypacurl/proxy.pac"

OTHER proxy example settings:

You will have to use command-line flags to override.

These are the ones available:

--no-proxy-server

--proxy-auto-detect

--proxy-bypass-list=XXX

--proxy-pac-url=XXX

--proxy-server=XXX

See the source code for documentation.

For example:

Send all traffic through the SOCKS 5 server "foobar:1080"

chrome --proxy-server="socks5://foobar:1080"

Send all traffic through the HTTP proxy server "foo:6233"

chrome --proxy-server="foo:6233"

Use the custom PAC script to resolve proxy servers:

chrome --proxy-pac-url="file:///home/foobar/tmp/myscript.js"

ASP: HTTP Headers for CSV filetypes

// these headers avoid IE problems when using https:
// see http://support.microsoft.com/kb/812935

header("Cache-Control: must-revalidate");
header("Pragma: must-revalidate");

header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=$filename.csv");

WCF: svclog viewer SvcTraceViewer.exe

Fire up SvcTraceViewer.exe located under:

C:\Program Files\Microsoft SDKs\Windows\v6.0\Bin

OR just run via your VS console window and type in "svctraceviewer"

VS2008: The breakpoint will not currently be hit. No symbols have been loaded for this document.

My VS instance crashed while I was trying to add a WCF service. Had to terminate the process. But when I restarted, I noticed strange behaviours with the IDE. I could no longer debug my project and would receive an error stating that "The breakpoint will not currently be hit. No symbols have been loaded for this document."

A bit of googling found this article.

The solution for me was to:

1. start debug

2. ctrl+alt+u.

3. Look for project in list and note path.

4. Close VS.

5. In explorer navigate to cache location in step 3, delete location of the cache usually under C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\xxx

I just deleted everything in root.

6. Deleted both bin and obj folder of each project.

6. Restart VS

7. Rebuild

TSQL: Order by Null OR zero first

The snippet below will order your values with any values as NULL or Zero first.

SELECT event_ID, event_title, event_date
FROM table_events
ORDER BY case when event_date is null or event_date = 0 then 1 else 2 end, event_date DESC

If you use union, you'll need to wrap your union statement within another SELECT before you can use the ORDER BY CASE statement above.

For example:

SELECT *
FROM
(
SELECT A, B, C
FROM Table1
UNION
SELECT X, Y, Z
FROM Table2
) X
ORDER BY A, B, C

Markdown: Simplifying HTML

This is an interesting concept, simplifying HTML so you can markup a document as easily as typing up a word document.

http://daringfireball.net/projects/markdown/basics