Daqing Chu At WordPress

February 28, 2009

Using EXEC() AT with Oracle DB

Filed under: Programming Notes — David Chu @ 11:53 pm

My previous blog was about using OPENQUERY() method with an Oracle DB. The advantage of using this method call is to pass through a query to a linked server such as Oracle server and to leverage the Oracle server to do the job. The great benefit of this strategy is to obtain much fast performance compared using T-SQL query directly against an Oracle database object in local SQL server.

Read full blog »


February 25, 2009

Using OPENQUERY for Oracle DB

Filed under: Programming Notes — David Chu @ 9:43 pm

Today I googled an alternative solution to run an Oracle PL/SQL query or stored procedure from Microsoft SQL server 2005. I am very impressed by the result of this alternative way.

Read full blog ».

February 22, 2009

T-SQL Tip: Combine Column Names as a String

Filed under: Programming Notes — David Chu @ 9:55 pm

I found the following T-SQL query to build a string of selected column names together separated by command for a table. This string can be used then for another SQL query as a column list.

Read full blog »

February 18, 2009

jQuery Tutorial Videos

Filed under: Programming Notes — David Chu @ 6:16 am

Today Ajaxian posted a group of tutorial videos on jQuery. I just finished the first one by John Resig, the designer and developer of jQuery. I saw a number of his training videos. The first one by Ajaxian’s blog is for entry level.

Read full blog »

February 13, 2009

Vimperator Tip of the Day: xall

Filed under: Programming Notes — David Chu @ 3:51 am

Tip of the DayIn my Firefox Preference, I have set up my tab settings to save all the tab as a session when it is closed and reopen the session when it starts…

Read full blog »

Mac Software Update

Filed under: Life with Mac — David Chu @ 2:53 am

New update from Mac. I noticed the update when I read a blog on this security update from MacRumors.com. The following are the detail information about this update:…

Read full blog »

February 11, 2009

Command Line Tool: curl

Filed under: Programming Notes — David Chu @ 5:19 am
Tags: ,

toolsToday I watched a video on Atom Publishing Protocol at YouTube.com GoogleDevelopers. Further reading on this topic, I found an article on this by IBM: Getting to know the Atom Publishing Protocol Part 1.

Read full blog ».

February 9, 2009

Rename Files Tool: NameChanger

Filed under: Life with Mac — David Chu @ 4:38 am

toolsI posted a blog on some greate Mac software tools in Nov 2008. One of them is NameChanger.

Very often, I need to change names of picture or video files from camera or camcorder to my Mac. This tool is a great one to rename files. Here is the interface of NameChanger.

Read full blog ».

February 7, 2009

Mpeg Decoding and Sony HD Camcorder

Filed under: Life with Mac — David Chu @ 11:03 pm
Tags: ,

Just updated my previous blog on this topic when I decoded my Sony HD camcorder mpg files again today. I added more pictures about the steps:

One of my biggest concern before I purchased the iMac is if I can use iLife to edit my Sony HD Camcorer’s mpeg file. I tried it before I got this iMac in a Mac dealer, but the sales people cannot open it. That was before OS 10 Leopard. Then I decided to get iMac to give it a try. However, I was not be able to open my mpeg files until recently.

Read full blog.

Caching Data and IFactory

Filed under: Programming Notes — David Chu @ 8:43 pm

hands onRecently I have been working a project to extract data from a huge database server for a daily reporting service. The process generates data in a required format based a complicated business logic.

Read full blog

Next Page »

Create a free website or blog at WordPress.com.