Select certificate from store by friendly name

Insert list of strings into temp table

create table #tempListOfThings ( thing varchar(50) )

INSERT INTO #tempListOfThings (thing) VALUES ('val1'), ('val2'), ...

Sql where datetime = today

Decompress a compressed db field

Deleting a windows service

There seems to be more than one way to do this, but is a nice easy one:

sc delete "My Service"

Comparing file versions

Here's a good way of comparing file versions. I had to use this in a recent service installer.