Archive for November, 2009

Re-invention of Email – Google Wave – Top 10 Features

Posted on November 11 2009 by Sachin Jain

Google has introduced its new product GOOGLE WAVE! It is an online tool provides communication and collaboration in real time. Google wave has been build on the concept of cloud computing.
It just a next generation emailing or communication tool. It has merged social networking, instant messaging, emails, wiki all together at one platform. You can [...]

Do’s and Don’t for Interview

Posted on November 5 2009 by Sachin Jain

Do’s
1) Early arrival – There is no excuse for late candidates. Always arrive 15 min early.
2) Giving your qualifications – Stress your accomplishments that are most related to the job.
3) Conduct yourself professionaly – Be aware what your body language is saying. For example – Smile, make eye contact.
4) Anticipate tough questions – Prepare yourself [...]

Unique constraints for LARGE TEXT columns – SQL

Posted on November 5 2009 by Sachin Jain

Suppose you are storing URL in your table and you want to apply UNIQUE contraint but as SQL allows only 900 byte limit. how can you put unique constraint for larger text ??
For this you can create a computed CHECKSUM column which is an integer vale and put constraint on it.
Example as follows
CREATE TABLE messages [...]

preventing select * from the query in SQL

Posted on November 5 2009 by Sachin Jain

For Team Leads, Developer don’t listen what you say still using * in their select queries. You can restrict them using * by using deny select on object.
This all you can do by create a dummy column in table and deny it for selection. Now user can select the rest of the [...]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes

Powered by Sachin Jain

Powered by Olark