Then check the Include column headers when copying or saving the results checkbox and click on OK.

That’s it. The next time you run a query, copy the query result, paste in Excel and voila, the column names are pasted together with the data.

Which Photo Gallery software should I use? (Part 1)

Posted on May 31, 2010
Filed Under Software, blogging, open source | Leave a Comment

These days most of us own at least one digital camera, whether it is a point and click or a more sophisticated Digital SLR. If you own a digital camera, the next most obvious thing to do after taking wonderful photos is to upload them somewhere. But where? How should you decide? Should you just follow everyone else and create an account with Flickr, Picasa or other less popular photo sharing sites? Some of us will just upload the photos onto Facebook. After all sharing your holiday photos, creative photos, etc. is a social activity we humans do.

There are some of us who may decide that we want to be more geeky and install a copy of an open source photo gallery software on our self-hosted account and have full control of administering and designing the layout. Whether you’re the former or the latter, you will have to make a decision.
Continue reading Which Photo Gallery software should I use? (Part 1)

Quick guide on how to take screenshots on a Mac

Posted on January 6, 2010
Filed Under Apple | 1 Comment

  
I have been using a PC for so many years that I sometimes forget the command keys to use to take a screenshot when I use my Mac. Since I need to remind myself, I thought it might be a better idea to blog a quick guide so that my readers can refer to it when needed.

The main keys to use on your Mac keyboard is the Command & Shift key. There are three keys to remember when taking a screenshot. The Command, Shift & 3,4 (numeric keys).

Continue reading Quick guide on how to take screenshots on a Mac

SQL xp_findnextmsg and xp_readmail

Posted on November 15, 2009
Filed Under Database | Leave a Comment

If you use SQL mail, you can read the messages in the SQL inbox stack and do stuff with them. Recently I had to use SQL scripting to find messages in the SQL inbox, read the message, determine if it is a text or html email, then add the message to a table in the database.

This can be easily achieved using the xp_findnextmsg and xp_readmail procedures. To strip the html tags from the email, I used a UDF (User Defined Function) written by the SQL guru of http://blog.sqlauthority.com. Kudos to him for sharing the function.
Continue reading SQL xp_findnextmsg and xp_readmail