How are they getting access?

I had to chase down a SQL Server permissions issue the other day.  In the mess of Windows Integrated Security its sometimes difficult to unwind the tangle of permissions threads to see who actually has rights to the database.

Check out the post under SQL > Security for common queries to determine who has access to what.



Reducing SQL transaction logs - revisited

My previous post was incomplete.  I've updated the post to accommodate shrinking of those large .ldf files - all without taking the databases down.


Part two: E-mail Oracle query results

This time in a spreadsheet attachment which end users can conceivably manipulate using Excel.  Not as elegant as it could be, but still quite useful.

Check out the posts under the Oracle heading.



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.



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