Thursday
Dec022010

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.

Sunday
Nov212010

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.

Cheers

Saturday
Oct162010

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.

Cheers!

Saturday
Aug212010

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 (127.0.0.1:6522 - 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.

 

Cheers!

Saturday
Jul172010

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.

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