Bala Singam

Let me tell you something you already know. The world ain’t all sunshine and rainbows. It is a very mean and nasty place and it will beat you to your knees and keep you there permanently if you let it. You, me, or nobody is gonna hit as hard as life. But it ain’t about how hard you hit; it’s about how hard you can get hit, and keep moving forward. How much you can take, and keep moving forward. That’s how winning is done. Now, if you know what you’re worth, then go out and get what you’re worth. But you gotta be willing to take the hit, and not pointing fingers saying you ain’t where you are because of him, or her, or anybody. Cowards do that and that ain’t you. You’re better than that!

Rocky Balboa

This is the question I hate to hear in interview sessions But dude this is reality they will ask it and most of time i had though time to answer it. The interviewer keep asking what’s special about you? What makes your different from others?

I found a articles on MSN Careers today, help you how to tackle this question.

The writer say

Why is the employer asking why he or she should hire you? Because there are only five areas of interest he or she is concerned with:

1. Your skills
2. Your knowledge about the company
3. Your manageability
4. Your affordability
5. Whether you can go above and beyond your job description.

Click here the read the full article.

In my previous post I have suggested to increase the timeout value to prevent the
” Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding ” error. But after set the timeout value to 600 seconds I still get errors but this time “Thread was being aborted” error in my ASP.Net application.

This is because the ASP.Net web application itself have a timeout property which is by default is 180 seconds or 3 minutes which means its expect a response from the web server within the timeout or else it will abort the thread. So before the DB call timeout expired (which we set 600 sec) the ASP.NET hosting process aborts this thread after its timeout expired (default 180 sec).

So in order to avoid this we need to increase the httpRuntime executionTimeout to higher value than timeout for Data Access( Command Object or DataAdapter) .

How to set the http Runtime execution Timeout ?
Its easy to do this , open to web.config file of your web application. Under the system.web tag add this line

<httpRuntime executionTimeout="600" />

Its should be something similiar like this

<system.web>
    <httpRuntime executionTimeout="600" />
</system.web>

I’m been facing this timeout problem in my report query especially for rdlc report where the application need to provide the datasource for the report. The error prompt more frequently when the number of records increased in table, so most of time you won’t have this timeout error during your development or early stage of production. But when when production data increasing you will facing timeout error.

There is 2 thing i can suggest here to avoid this problem. First keep your query or view simple and fast enough. What i mean here is make sure you use the correct joins in query if you ever need one and only put the fields that you need in query. Number of column if too many in your query or view will also make the execution time longer. But sometimes we can’t avoid creating a query or view that take so much memory and execution time so when you arrive on this situation its a must to set the timeout property to longer time.

There are two main Timeout property in ADO.NET.

1. Connection Timeout for Connection
2. Timeout for Data Access( Command Object or DataAdapter)

How to set Connection Timeout property for sql connnection object ?

You can’t set timeout property in connection object because its a read only property

// you cannot do this
SqlConnection conn = new SqlConnection("server=Server;uid=sa;pwd=123456;database=myDB;Connection");
conn.ConnectionTimeout = 100;

The correct way to do this is set the timeout value in connection string like the example below.

// the correct way to set connection timeout
SqlConnection conn = new SqlConnection("server=Server;uid=sa;pwd=123456;database=myDB;Connection Timeout=90");

Next , How to set timeout property in DataAdapter or Command Object ?

Its pretty simple as shown below.

SqlDataAdapter sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = new SqlCommand(sqlQuery, conn);
sqlAdapter.SelectCommand.CommandTimeout = 0;

Setting the timeout value to 0 will makes adapter or command to wait for indefinite time before terminating the attempt to execute a command and generating an error.

The default timeout value for connection object is 15 seconds.
The default timeout value for DataAdapter or Command Object is 30 seconds

If you have better ways to overcome this timeout problem please leave your comments. It will be very helpful

I received a forwarded mail from my friend. Its about one of the latest tamil movie , Kuruvi !

Inthe padam pethi nan solle thevei ille unggeleke nalle terinjikum inthe padam evele ‘super’ na padam ne. This forwarded mail contain some jokes about Kuruvi and Vijay. I’m gonna share some of the jokes here, ithe jokes mathum than , nothing else. Vijay fans ellam upset o ille kovam pedathingge ..its just for humor.

Joke 1

Man1: Yenna Sir, Antha Theaterla Avalavu Kootam.
Man 2: ‘ KURUVI ‘ Padam Paarka Yavano Ticket Reservation Panni Irukan, Avana Paarka Thaan Ivalavu Kootam..!

Joke 2

Last one week around
12crores of msgs had been sent in tamilnadu.

Gud mor,gud nite msgs- 1cr
Frndship nd love msgs-1.5 cr
Sardar Jokes msgs – 1 crore.
News nd fwd msgs- 0.5 cr

Msgs teasing VIJAY nd KURUVI- nearly 8 crs
All mobile service providers are thanking vijay and kuruvi ‘ s team for the profit..

Jokes 3

Police: inaiku unaku thooku.kadaisi asai ethavathu iruka?
Kaithi: BILLA padam pakanum
Police: kootama irukum,kuruvi pakuriya?
Kaithi: Athuku thokulaye podunga..

There is more jokes sent in the mail but most of them bias towards Vijay.

Vijay fans , anna marupadiyum solleren ithe jokes ke than…tension avathingge!