Tuesday, October 30, 2007

Recursive Database Query

Hi, it is quite a long time I am not writing any technical blog. One important reason is I am out of technical stuffs for long time. And another one is I am not learning any new things. I repeat some boring works regularly.

Whatever, I encounter very interesting thing. At least I found it interesting to me. Recursive Database query. Things are like; say you have a content table in database called ItemContent. And your content is hierarchical. That means some content have parent child relationship among them. And you got a separate table called ItemHierarchy. The relationship is defined in this table. Now you need all the descendant of any item those meets your requirement or May you need descendant required until a specific level. Here I show an interesting recursive query for these sorts of phenomena. This is highly Microsoft SQL specific implementation; you may try it on other database system.

WITH RecursiveTable(ID,Depth) AS

(

SELECT ID,1 FROM [ItemContent] as IC WHERE [Name] = 'root' UNION ALL

SELECT childID,RT.Depth+1 from ItemHierarchy HT inner join RecursiveTable RT ON RT.ID = HT.parentID AND T.Depth <5

)

SELECT ID FROM RecursiveTable;

The query is pretty simple, only interesting thing inside it, it is recursive. The first part sort out the specific parent and the rest will recursively find their descendents. That’s it.

Monday, October 29, 2007

Blog born from Loneliness

This is well known philosophy that people those are lonely maintain dairy. At least some people believe on that way. Blog is a kind of diary. With the blessing of modern technology we are now maintain our diary in website so that people can read it and know about us. They can communicate with us through blog to relief from our loneliness for little bit of moment.

Now days, I am writing blog more frequently than before. Does it mean I am becoming lonelier day by day? May be, this is true. I am becoming lonelier day by day. May be this loneliness insist me to write blogs. Because, I don’t find anyone in my surrounding to whom I share my feelings and that’s why I write them to my blog with the intension of share them with thousands of people. Sometime time I feel I am so lonely that loneliness itself leaves me alone.

Friday, October 26, 2007

Twenty-five Years of Solitude

This is my twenty fifth birthday. Adnan and Apu manage a cake from kings, probably at 11:30 pm. I have leaded almost one third of my life. I am ashamed of quality of the image. In fact we don’t have any digital camera tonight :-(. The photo is taken by my mobile camera. Whatever here it is…

Life is beautiful...

Tuesday, October 23, 2007

Am I becoming a pimp?

Sometimes, I feel I am becoming a pimp day by day. As like as pimp advertise for their prostitutes, I do it for myself. May be, worse than them. Something like I am prostitute come and fucks me. And you will get yourself satisfied. Or maybe I am male whore; I can fuck you better than anybody else. You know marketing for yourself is kind of weird thing. But, fucking life, I have to do that, do that for myself.

Sunday, October 21, 2007

Road to be a man

Tentatively it was before my final exam in last semester. It was the most important time I have ever encountered in my life. Prior to start of my professional career it presents me almost factual essence of real life. The influence of that time reflects in my life so much that some time I think I became a one new after that.

I learn how to fight, fight against evil, the art of thinking; I tune my philosophy and so one. Almost everything I learn, I have to learn that from edge. And that is the reason they have strong influence in my later life. Rest of my life I just tried not to do same mistake again.

The most important things, I learn is nothing would wait for you, how important you would is not an issue. If you got a real opportunity you have to have used it right that time, at your own. No one will leave that for you for infinite time or no one will prepare that one for you. You may get several opportunities in rest of your life, but by the time you will lose few of your costly times. Choose the right things at right times is the most vital challenge.

Consequently, a very small mistake from you is becomes an advantage for your rival. And the very foolish one will definitely use that one against you, as because he is your rival. If he don’t have that much intelligence to use that against you, surely they never ever cannot be your rival.

Well, these are the things probably you have heard so much time that you become bore of that. But they are the fact, and from life what I have learned is all of those are repercussion of pretty simple thing. Never do something emotionally in real life, because almost every time it creates a problem for you.

I still don’t know why I always listen to my heart than brain. Every time it creates lot of difficulties for me. In Contrast, It gave me a sound mental peace that I never encounter in other ways. May be this is the only advantages of this. You have to trade of between these two, and I think this is not so easy. Almost every time I fail to do that.

Friday, October 19, 2007

Too Much Love Will Kill You

I'm just the pieces of the man I used to be
Too many bitter tears are raining down on me
I'm far away from home
And I've been facing this alone
For much too long
I feel like no-one ever told the truth to me
About growing up and what a struggle it would be
In my tangled state of mind
I've been looking back to find
Where I went wrong
Too much love will kill you
If you can't make up your mind
Torn between the lover
And the love you leave behind
You're headed for disaster
'cos you never read the signs
Too much love will kill you
Every time
I'm just the shadow of the man I used to be
And it seems like there's no way out of this for me
I used to bring you sunshine
Now all I ever do is bring you down
How would it be if you were standing in my shoes
Can't you see that it's impossible to choose
No there's no making sense of it
Every way I go I'm bound to lose
Too much love will kill you
Just as sure as none at all
It'll drain the power that's in you
Make you plead and scream and crawl
And the pain will make you crazy
You're the victim of your crime
Too much love will kill you
Every time
Too much love will kill you
It'll make your life a lie
Yes, too much love will kill you
And you won't understand why
You'd give your life, you'd sell your soul
But here it comes again
Too much love will kill you
In the end...
In the end.

Queens

Version 1.1, Beta 1

Though I am not very buoyant about the new version, I released it. This is passed by QA test. QA does not certify it as very stable version but I must release it. Hope for the best may be I can manage some patron for the new version; Beta 2 will be released soon. I already start promotion for the new version. Hope for the best…

Thursday, October 18, 2007

The nine satanic statements

1. Satan represents indulgence, instead of abstinence!

2. Satan represents vital existence, instead of spiritual pipe dreams!

3. Satan represents unfiled wisdom, instead of hypocritical self deceit!

4. Satan represents kindness to those who deserve it, instead of love wasted on ingrates!

5. Satan represents vengeance, instead of turning the other cheek!

6. Satan represents responsibility to the responsible, instead of the concern of the psychic vampire!

7. Satan represents man as just another animal, sometimes better, more often worse than those that walk on all-fours, who, because of his “divine spiritual and intellectual development,” has become the most vicious animal of all!

8. Satan represents all of the so called sins, as they all lead to physical, mental, or emotional gratification!

9. Satan has been the best friend the church has ever had, as he has kept it in business all these years!

The Satanic Bible - Anton Szandor LaVey

Wednesday, October 10, 2007

Pursue of Judgment

If birth and dead both control by God then why such a birth discrimination take place? This is very interesting when I found people born with such inequality, persuade himself rest of his life not to do any kind of blasphemies, just because he expect justice from same arbitrator at day of reckoning. Sometime I think this is the only proof of God. He persuades us about his fairness without showing any illustration of that.

(For sure, I am not atheist...)

The Final Countdown

Were leaving together,
But still its farewell
And maybe well come back,
To earth, who can tell?
I guess there is no one to blame
Were leaving ground
Will things ever be the same again?

Its the final countdown...

Were heading for venus and still we stand tall
Cause maybe theyve seen us and welcome us all
With so many light years to go and things to be found
Im sure that well all miss her so.

Europe

Agains All Odds

How can i just let you walk away, just let you leave without a trace
When i stand here taking every breath with you, ooh
You're the only one who really knew me at all

How can you just walk away from me,
When all i can do is watch you leave
Cos we've shared the laughter and the pain and even shared the tears
You're the only one who really knew me at all

So take a look at me now, oh there's just an empty space
And there's nothing left here to remind me,
Just the memory of your face
Ooh take a look at me now, well there's just an empty space
And you coming back to me is against all odds and that's what i've got to face

I wish i could just make you turn around,
Turn around and see me cry
There's so much i need to say to you,
So many reasons why
You're the only one who really knew me at all

So take a look at me now, well there's just an empty space
And there's nothing left here to remind me, just the memory of your face
Now take a look at me now, cos there's just an empty space

But to wait for you, is all i can do and that's what i've got to face
Take a good look at me now, cos i'll still be standing here
And you coming back to me is against all odds
It's the chance i've gotta take

Phil Collins' 1984

Babu is Back

Babu is one of my cousin resides in London back to home today. He is not only my cousin but more than that. He was my childhood fantasy. He taught me the way of thinking, diversity of life, how to be bad and how to be good too. Sometime I think he is my mentor, sometime best companion and sometime more than that.

We share lots of common interest like books, music etc. Most notify able common interest among us may be diversified, obsessed, freak and sick booklover. We like versatile type of writings. Both of us have a unique collection of book.

We spend lots of time together. Last time when he was in Bangladesh, we spend most of the time jointly. Sometime we wish if we were Gay then we could marry each other. Sad! We are not. I spend most of my noteworthy time with him.

He is my philosophical teacher. Almost always when are together we tune our philosophical thinking. Both of us are worthless philosopher too. There are very little things in haven and earth that we don’t bring out together. So, within very few days you will see us together in boulevard doing either authorized or illicit thinks. Oooooooooooops! My GRE, 15 Oct, FUCK UP!!!