My career has encompassed years of experience involving software development, database management, and project management. Software development includes scripting, Java and C programming languages. Database management includes design, change management and database recovery. Project management of software development includes start up, execution, monitoring and closure of projects. Here are some software and database posts of interest to me.
Mike
Michael E Kelley 
I have started looking into Hadoop database management classes because of all the hoopla with cloud computing. Can you say “Hadoop hoopla” fast three times? Anyways a week of classes is $2000. A four day class is $1400. But online classes appear to be free. But that is probably just the first class.
LikeLike
Just read this article in USAToday regarding Needle.com an online customer service company that answers questions for various products.
http://www.usatoday.com/tech/columnist/talkingtech/story/2012-05-30/needle-talking-tech/55287900/1
I wonder if I should join the company and answer questions regarding SQL, Sybase, and database management. But the pay looks to be rather low.
LikeLike
Challenge – SQL Question – Conditional Join on Columns based on value of one column. Here is my answer.
Try a union
select * from tbla ta, tblb tb
where ta.column_1 = 1
and ta.column_2 = tb.column_2
union
select * from tbla ta, tblb tb
where ta.column_1 = 2
and ta.column_2 = tb.column_2
and ta.column_3 = tb.column_3
union
select * from tbla ta, tblb tb
where ta.column_1 = 3
and ta.column_2 = tb.column_2
and ta.column_3 = tb.column_3
and ta.column_4 = tb.column_4
the end
Here is the website to see other answers
http://stackoverflow.com/questions/10846936/sybase-conditional-join-on-columns-based-on-value-of-one-column/10866671#10866671
LikeLike
SQL Challenge: How to remove percent signs (%) from column in table.
Solution:
If your DBMS does NOT have a “replace” function, you will have to use character substitution using several string functions.
Here is an example in Sybase and SQL Server.
UPDATE YourTable
SET YourColumn = stuff(YourColumn, patindex(YourColumn, ‘%’), 1, NULL)
This says find the pattern of ‘%’ in YourColumn. Now use that position number and replace aka stuff the character with NULL instead.
Good SQL, good night.
LikeLike