E-mail Oracle Query Results

Had an occasion to e-mail Oracle query results to internal customers.  Check out my "Oracle" section on the right for an easy way to send query results in the body of an e-mail message.



Clean a virus off your PC

Had another friend ask me for help getting some insidious virus off his PC the other day, so figured I'd fire off a quick post to help anyone else out there. 

The viruses these days are a lot more sophisticated than the ones I used to remove.  Nowadays they paint some pretty official looking windows on the screen (almost identical to the ones from Microsoft).  They're also preventing users from entering into Task Manager. 

Perhaps worst of all they're going into the Internet Explorer settings and changing the proxy server setting to the localhost ( - where "6522" is some random port that the virus is configured to listen on once it's taken over the machine.

Pretty effective, but it looks like the procedures and tools that we've been using to remove them are still pretty good at getting them off your computers.

If you need help getting a virus off your computer I suggest you check out my post "Virus Removal" under the security heading.  It's a pretty cut-and-dry method for beginners to get rid of today's nasty viruses.




SQL Sprawl

Had a chance to outline a strategy to deploy new SQL servers this week and figured I'd turn it into a blog post.

There seems to be a high demand for databases as of late and we were previously struggling with expectations as to where to put 'em all.

Check out the new post under the SQL heading.


Script to generate Active Directory passwords

Use vbscript to generate unique, complex passwords - without being an expert in vbscript!  Ain't life grand?

Check out the post under the "Active Directory" heading. 


Quick fix for corrupted .pst

Went to open my .pst in Outlook the other day and was greeted with An unknown error occurred, error code:  0x80040116.

Spent a good 10 minutes googling around for a fix.  Came across several ads for .pst scanners, advice for clearing the index, nothing helpful.

Ended up closing Outlook, making sure no other sessions were accessing the file, then copied and pasted it.  I then pointed my Outlook settings to use the new file.

Works like a charm and haven't noticed any missing data.  Hopefully this helps someone else out there.



Page 1 ... 3 4 5 6 7 ... 8 Next 5 Entries ยป