Monday, July 27, 2009

Language codes for different countries

http://babelwiki.babelzilla.org/index.php?title=Language_codes

10 skills developers will need in the next five years

http://blogs.techrepublic.com.com/10things/?p=643

A few measures that speed up your visual studio

http://labs.episerver.com/en/Blogs/Steve-Celius/Dates/112266/6/Speed-up-Visual-Studio/
http://blog.miniasp.com/post/2008/04/speed-up-visual-studio-performance-and-increase-work-efficiency.aspx
http://weblogs.asp.net/scottgu/archive/2006/09/22/Tip_2F00_Trick_3A00_-Optimizing-ASP.NET-2.0-Web-Project-Build-Performance-with-VS-2005.aspx
http://dan9298.blogspot.com/2009/01/visual-studio-and-auto-toolbox-populate.html

Tuesday, July 21, 2009

TSQL Union and Union ALL

Union will select distinct values where Union ALL will not

Thursday, July 16, 2009

The Open Source Opportunity

http://webworkerdaily.com/2009/07/15/the-open-source-opportunity/

Monday, July 6, 2009

Materials for Comet

http://stackoverflow.com/questions/1086380/how-does-facebook-gmail-send-the-real-time-notification/1086448#1086448
http://stackoverflow.com/questions/136012/comet-and-jquery
http://ajaxpatterns.org/HTTP_Streaming
http://plugins.jquery.com/project/Comet
http://www.nabble.com/jQuery-Doing-Comet-td18120554s27240.html
http://www.pathf.com/blogs/2007/04/roundup_comet_t/

Sunday, July 5, 2009

jQuery modal plugin

I have tried to use different jQuery modal plugin to finish my job these days.
What I want is add a half-transparent overlay to the background and popup a dialog box to ask some questions.
Some plugins are too complex, hard to use or buggy:
Thickbox - cannot retain the radiobutton or checkbox answer in IE6,7 after closing the dialog.
BlockUI - hard to make the position right

And I finally use the jqmodal plugin (very easy to use):
http://dev.iceburg.net/jquery/jqModal/

Materials for MySQL Database

A Technical Tour of MySQL
http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/

MyISAM vs InnoDB
http://stackoverflow.com/questions/20148/myisam-versus-innodb

MySQL performance blog
http://www.mysqlperformanceblog.com/?s=MyISAM+InnoDB

How do you choose a MySQL database engine
http://serverfault.com/questions/219/how-do-you-choose-a-mysql-database-engine

Transaction and autocommit
http://www.oreillynet.com/databases/blog/2007/02/mysql_transactions_and_autocom.html

log file in MySQL DB

MySQL server log

http://dev.mysql.com/doc/refman/5.0/en/server-logs.html

The error log
Problems encountered starting, running, or stopping mysqld
log_error = [filename]

The general query log (recommended!)
Established client connections and statements received from clients
log = [filename]

The binary log
All statements that change data (also used for replication)
log_bin = [filename]

The slow query log
All queries that took more than long_query_time seconds to execute or didn't use indexes
log_slow_queries = [filename]
long_query_time = 2 (Time you think that the query takes too long)

Transaction in Zend Framework

http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.transactions

The MyISAM engine doesn't support transaction.
You may need to use InnoDB instead.
Read the following post for my question:
http://stackoverflow.com/questions/1083857/cannot-rollback-transaction-in-zend-framework


Thursday, July 2, 2009

jQuery issue

I have to do a survey that will dim the bg and popup a box to ask questions.

I use thickbox to do the effect, but to match the ui, I have to edit the js and css to remove the padding.

Problem:
"nested form element" which occurs in dynamic page so that I cannot append item and serialize the form correctly.

Solution:
Use a temp. form to solve the problem:
$("<form></form>").append($("#form_inside")).serialize()

Wednesday, July 1, 2009

Expected Salary?

http://discuss.joelonsoftware.com/default.asp?joel.3.603939.20

What is your expected salary? Dodging that awkward interview question...

http://www.careerslave.com/interview-advice/what-is-your-expected-salary-dodging-that-awkard-interview-question/


“What are your salary expectations?”

Not an easy question to answer at your interview - as I’ve looked at other tough interview situations over the past few weeks (such as “reasons for leaving your job“), I thought it was worth covering how to deal with being asked what salary you expect to get.

First of all, you need to know that you don’t have to disclose your current or past salaries and you don’t need to respond to this question. But given you are interviewing for a new job, the manner in which you deal with the question can affect the outcome of the interview, so it is worth being prepared.

In a lot of cases, especially early on in your career, you will be expecting an increase in salary when you move to a new job - usually because the new job may be a step up for you and as such has more responsibilities.

You also need to remember that your new employer really has no way of finding out your previous salary, so if you want to exaggerate a little to help justify an increased expected salary, then feel free to do so - it’s not a big deal, but please do be conscious that you shouldn’t go to far with this. Adding a couple more £k to your current salary isn’t a big deal.

How to respond when asked what your salary expectations are

Let’s assume you want more money than you are getting just now. If the salary hasn’t been disclosed for the job, then you need to carefully discuss the potential with your new employer.

You can start off by saying something along the lines of, “Well, obviously I would expect a salary that is in line with the level and responsibilities of the job and my experience - what starting salary do you offer for this job role?” - this is a great counter to the question. It doesn’t commit you to a specific figure, and moves the discussion back to them. They will always have a figure in mind from the start of the interview - most employers just want to see if they can hire you for less money! :)

There are several responses they can give to this:

  • A figure that is way less than you want (in which case you need to think about if the job is really suitable for you)
  • A figure that is a little lower than you want (then you need to put an argument forward for a higher starting salary)
  • A figure that is suitable or higher than expected (take it - or haggle some more if you’re feeling cheeky!).

How to haggle for more money

It isn’t easy and you could quite easily mess up the entire interview if you go to far with this - all the same, it is worth it in many cases - you should take whatever chances you can to improve your own person situation.

There are several arguments you can give:

  • I would have expected a higher starting salary for this position
  • My current salary is higher than that
  • That salary is a little lower than I think I need right now
  • I think my experience would warrant a higher salary than that

Regardless of the approach you take, you should always end it with a question. You do not want to put forward a staunch argument with no scope of discussion - you need to keep the discussion moving in your favour by always giving your interview a tight breadth to respond (rather than leaving the conversation wide open which could result in them changing the subject).

Your goal should be to maintain control of the discussion until it is resolved in your favour - the danger is that you can come across as to stubborn / greedy / etc so it is worth preplanning your approach.

Good luck!



Job Offer Salary Negotiation
http://www.cvtips.com/job_offer_salary_negotiation.html