Last week I was shuffling through the channels in my TV. I had just come up from office and was terribly tired. I just thought to refresh my mind but to my disappointment I could not get a single program which I can watch through. Suddenly I got stuck at National. Some program called “Smile Pinky” was coming and instantly it drew my attention. The concept was very simple and presentation was par average but something was there which didn’t allow me to change the channel. Perhaps the heart they have put in had made it really attractive.
I just smirked over our self how we have changed in due course of time. How our taste have changed from “Chhota Jaadugar” and “Karamati Coat” to “Raakhi ka swayamvar” and “Big Boss”. People call these reality shows. Often I feel strange about it, Are they real by any means? When I look back to our DoorDarshan days, I remember programs like “Malgudi days”,”Neem ka Ped”,”Vyomkesh Bakshi”,”Dekh Bhai Dekh”,”Vividh”,”Tamas”,”Bharat ek Khoj”,”Idhar Udhar”,”Mitti ke rang”,”School Days”..etc etc…and the list goes on.
These serials were so attached to our daily lives that even today I can feel their impact in my living. All these serials had a soul which directly communicates with the viewer but now that soul is missing in today’s programs but strangely they are more popular. New channels are playing dual roles, they have become infotainment channels. They don’t show the truth but sell it. It is clear that they are not serving to the people but making business.
A great transformation has occurred in the society in past years. A great transformation has come in me as well. The thinking process changes in due course and it should. In fact it should not change but develop. When I was a kid of 3-4 years, my mom used to say “Eat Beta, else police will come”. My impression for Police was that they are the most powerful creatures.
When I grew up a little bit, I saw Shaktimaan on National TV. I had this feeling for almost a year that he is the strongest fellow and can save the world in any danger.
When I moved to primary school, one of my senior told me about Bruce Lee. He also emphasized that Shaktimaan is fictitious but Bruce Lee is real. From that day I started believing that Bruce Lee is the real Macho man. In coming years I saw Heman, Rambo and many others each changing my conception for the strongest fellow. In secondary school days WWF wrestlers were on the top. For few days I treated them as real heroes. In 2001, Osama rocked the world by destroying twin towers. After that incident I regarded him as the strongest person who can do anything at his will. But US Army destroyed them all over and made me realize that a person cannot be strongest but it should be an organization or nation. When I was in college I read about Bill Gates, the richest person in the world.
I considered him to be the most powerful personality since he controls the world economy.
When I graduated from the college and joined MICROSOFT, I realized that people like me and you are working in these organizations and they make Bill Gates stronger. So the strongest people are us. I derived that Knowledge is the strongest weapon and the person who has it in abundance is the most powerful person.
So I realized that transformation is the key here. Transformation is for good but it should be in a progressive way.
Wednesday, December 9, 2009
Monday, September 7, 2009
APRIL FOOL
Few incidences remain for lifetime. Few incidences make us feel witty and bring a smile on our face whenever we think of it. Such an incident happened with me when I was in college. I never knew; a small kink will turn out into such a whirlpool.
After a short vacation of Holi, I was returning back to Pune from Ahmedabad. To my disappointment, the train was even late by an hour. I had to spend more than an hour at the platform. I went to the Waiting Hall but it was full more than its capacity. I came out of it and went to the stairs of the flyover made to cross the platform. I sat comfortably and took a glance all over the station. Beggars were begging and the hawkers were selling their stuff. Suddenly a noise broke and I looked towards it. A beautiful girl of around 19 or 20 had lost her grip on the suitcase she was holding. Generally what happens, it happened here also. Lot of guys came forward to help her. They lift her suitcase, asked if she is alright and made her sit at a sophisticated place. I looked at her from a distance and somehow she seemed to me very pretty and attractive. When alone, every second girl seems to be attractive. Moreover I was feeling dizzy at the very idea of spending an hour at the platform.
Suddenly they announced”Sarathi Express coming from Bhuj to Pune is delayed by 3 hours. Your Inconvenience regretted.” This wrecked me from the core. I went to the girl and sat just in front of her. I was trying to take a glance at her but I observed she was continuously gazing at me as if I was insane. Suddenly I realized I am sitting on someone else’s luggage that was lying nearby. I got up in a flash but in hurry I tumbled down but somehow managed to hold myself. It was an utter embarrassment. I took out my novel and started reading it. Every when and then my eyes were looking for her. I was scanning all her activities. She was all sport, all alone but still so enthusiastic. She has put earplugs into her ears and was listening to some music; it was hard rock I suppose. Getting enthralled at times she was shaking her body too. She took her magazine out but kept it inside soon. Then took some stuff from her hand bag and started playing with it. It was small toy car I noticed. Even this was not pleasing her anymore; she threw it off in the bag and started singing some song loudly. She had almost forgotten that she is at public place and she was not supposed to do this. An Old man beckoned her to stop it. She started talking to him. I was wondering if what they must be talking; Father –daughter kind of stuff!!! Or some social topic or what! I thought for a minute to take part in the conversation but I saw that old man left in between and I stopped myself halfway. She saw me coming towards her but showed if she has never seen me before. I came back to my place and again looked back at her. For some time nothing happened between us except few eye contacts. Again I saw her playing with a kid. I was feeling jealous of the boy who was playing in her lap. He was playing with her hairs and she was pampering him.
All of a sudden, the announcement came for the arrival of the train. Already it was 10:00 PM; I looked into my watch. Soon the train came; I rushed into Sleeper coach and found my seat. All the ideas of that girl vanished in moment. I slept tightly like a baby.
When I wake up early in the morning, I asked the pantry person who was selling tea”Bhaiya!!! How long it will take to reach Pune??” He smirked “Sir!!! The train is 8 hours late. It will take three more hours to reach Mumbai. Then after that three more for Pune.” I got aghast at this but nothing was in my control.
Suddenly a female voice pinched me from behind” mumbai paachhad toh nai rahi gayu??”. It was she, the same girl. At first I didn’t understand what to say. So I just nodded. The gentleman who was sitting below replied instantly in Gujrati “train moodi che 6 kallak thi ! mumbai jaava 3 kalaak lagse.”. Nobody leaves a chance to show off. He continued “Hi I am Hiren! Are you coming from Bhuj??” She replied negatively “I am coming from Ahmedabad. I have to attend a seminar today in my college but I will be late I suppose.” He nodded in sympathy” Oh that’s bad!!! By the way I am an engineering student infact E&TC one. I stay in Kalyan. ” She replied” I study in Sardar patel College in Andheri.” It was quite evident that she was enjoying his company and I was feeling jealous at it.
“Hey what a coincidence! I am also an E&TC engineering student” I dropped myself in between their conversation from nowhere. They were astonished but smiled. I looked at her and apologized “Sorry!!! I don’t understand Guajarati…That’s why I stood like dumb” Everyone laughed. I started”I am coming from a Project Exhibition in Ahmedabad. I started talking about the companies which visited the college campus to patronize the program. I was giving all my best to impress her.” I saw she was no more interested in all this technical stuff. So I invited them to play cards. They agreed. But I made a mistake here. He was a champ in playing cards.
He very soon swept three four games in a row. I will never suggest any of my friends to give challenge any Gujarati at least for playing cards. She was enjoying every moment of it. I felt him taking an edge over me. But I was consoling myself within that this guy has to get down before both of us. So still I had a chance. They stopped playing card and started playing jokes. I also got involved in that and showed my skills. Both of them praised my sense of humor.
At the next stop he was about to get down. “I will get down at next stop. Hey Sorry I didn’t even ask your name” He giggled at me. “I am Viki and she is…” I beckoned towards her deliberately so that at least now she will reveal her name. She continued”I am prakruti”. I knew that prakruti means nature but still to carry on the conversation I exclaimed “Enviroment. Right ??”. Hiren tried to shine in between “No yaar , It means Earth”. Prakruti screamed “ STOP IT!!! Boys…it means nature”. Oh..such a sweet meaning I complimented her. Hiren shook hands with both of us and got down. I thanked God at the devil’s exit. She put her earplugs again and lost in it completely. I smirked “She has started listening the same Rock song.” It was quite apparent from her movements. I couldn’t resist anymore and asked “Are you listening to Hard Rock!!!” She was amused at this and making irregular faces said “No...It is a Guajarati folk song”. I burst into laughter but realized “Girls will be Girls”. I flattered”you seem to have a very good knowledge of music. Your face expression and body movement reveals so”. Every girl wants to hear her praise and she was no different. I kept on scoring runs on that slow pitch like Virendra sehwag. But it has to come to an end. Her stop came and she was about to get down. I was still staring at her eyes. She left without saying anything not even bye. I was surprised at this but kept mum. Suddenly after a while some unknown thrust from inside forced me out of the train. I screamed from behind “Prakruti wait!!!” She halted instantly and looked back. I reached there and asked for her number. I never knew I can be so bold. She pronounced some number but I asked her to write it on my palm since I had no paper with me. The train was about to leave. She tried to write her number on my palm but since it was wet all in vain. She slide my shirt cuff and wrote her number on my wrist.
I heard the whistle of train and rushed towards my compartment. I was immensely overjoyed. All the way I was thinking how I can build relationship with her. I had even planned to buy a cell phone. How a girl can impact one’s mind, it was quite evident there. The guy who never spends extravagantly was thinking to buy a cell phone. In few hours I reached Pune.
I tried to call her from a PCO but the number was coming unreachable. All my plans went into trash soon I reached the college premises. The Security Guard told me that there was a call for me of my parents. I went back to the PCO and got the news of my younger brother’s accident in Bangalore. I was required there since nobody was there to take care of him. I returned back with a heavy heart. Ved, one of my friends noticed it. I told him about my brother’s accident. In the hurry he arranged for my travel as he knew a travel agent. As a part of gratitude I handed over the cell number of that girl to him. After hearing all that stuff he was enthralled” buddy! Don’t worry I will take care of everything”. Moreover he had a cell phone so he was absolutely a better choice for a distance relationship.
In a fortnight, I was back to my place. I went to my friend’s room but he was not there. I asked his fellow roommate. He grinned “must be talking to his girl. I am fed up with him. He even talks in night and disturbs my sleep.” I would be mean if I will blame him for this, I thought. So I kept mum. From inside, I was curious to know if she is the same girl whose number I had given to him. Somewhere in the corner of my heart I was also feeling bit jealous of him. Soon he returned back to his room and found me. Being overjoyed he hugged me and asked about my brother. “He is alright now. Still needs some rest” I was keen to know about her. He continued “She is a sweetheart! We daily talk for hours and it seems we know each other from ages.” “Are you serious about this?? How you could be?? You have not even seen her. Better come to your flirting routine” I suggested and left for my room. I knew all his love is a crap only time pass nothing more.
I started neglecting that dear friend of mine. Not because I am saint and wanted to leave him with his girl but I always feel uncomfortable whenever he used to talk to her in front of me. One day He came to me and said” Dude! She loves me equally yaar. She wants to meet me. And I have asked her to come to Pune this Sunday. Please come along with me. ” Even I wanted to see Prakruti again but I declined” No Yaar what will I do there? Kabab me Haddi “. But he insisted me to come.
Days passed on and finally the much awaited Sunday arrived.
I was lying on bed. I was in no mood to get up. I put the blanket all over my body and slept again. But someone pulled it off and wakes me up. I saw him dressing up with full zeal. He picked his best shirt from the wardrobe and put it on the bed. He first shaved and went to take a bath. He took almost half an hour for it. Generally he used to take bath once in a week. He put the perfume combed his hair. I was watching all this as if a TV serial was going on in front of me. He was writing something on a piece of paper. When I closely saw it, it was a greetings card for the first love. I wondered how many first loves this guy had. He tucked a rose into it and was now all prepared to go. I apologized for the delay and asked for ten minutes. I brushed my teeth, washed my face and sprayed deo and left with him. Well in College Hostels taking bath is considered as a special occasion. More over this time I was in hurry so no question of taking bath. In an hour or so we reached there at station. Ved was constantly there on phone all his way discussing where she supposed to wait, what kind of get up he has and asking her get up as well. I overheard that she is wearing a blue Capri and white T. He instructed her to come out of gate no 1. He left to receive her towards Gate. I stayed back.
In a flash I saw him running towards me. Run Vikki! Run…He screamed from a distance. I had no clue what he was talking But I ran. I asked him what happened. He sighed “Thank God, I am spared. She is not at all good looking. Oh...How did I put myself into her trap? Anyway let’s get back to hostel.” He was trying to hide his face. Even I was feeling like laughing on his hard luck but suddenly the poor thought of that innocent girl struck. I yelled at him” Are you crazy!!! That girl is coming from Mumbai to meet you and you coward, you are doing this to her. Go and spend some time with her. In the evening send her back to Mumbai. And tell her after some days that you don’t love her. She will understand it. But For now just go to her.” He said” If you are feeling so much about her, why don’t you go and show her the city. Take my cell, contact her and move. I am leaving”. He was shameless as ever and I was helpless as always.
I was standing alone there. I was amused how that beautiful girl whom I met in the train can turn out to be so ugly. With a heavy heart I moved towards Gate No 1. I saw a girl in the same outfit. I went to her greeted” Hi. I am Vikki. I know you are looking for Ved but he has got a very urgent college work now. So he has left for the university in between from the halfway. And he has sent me to receive you. He will be back in few hours.” I was quite hesitant in it but said” I am feeling very sorry about it. If you don’t mind you can come with me. By then he will come back I can take you to some coffee shop.” But she declined gracefully”No thanks! Even I have to go back due to some urgent work”. Needless to say that she understood every bit of what happened there. I saw her moist eyes and cursed Ved for all this. InFact I was the root cause for all this. I took the ticket for the next train to Mumbai. I said Bye to her and came back.
My head was aching. So I took a disprin. After some time I went to PCO to call that girl, just to know If she has reached safe. Soon the call got connected, a female voice came from the other end “Hi , Prakruti speaking…”. I was freezed at this. This was her voice whom I met in the train. I mumbled” Can you guess who is speaking??”
She replied naughtily “Hiren Stop it!!! Now switch back to your original voice. I know today is 1st April and you cannot make me fool. Come home soon. I am waiting for you”. I lost my grip on the phone. I redialed and then realized my mistake. Earlier I had dialed a wrong number. The last digit I pressed zero instead of eight.
I checked the date in my watch. It was 1st April.... April Fool…
I realized she made me fool long before and destiny made me this realize on 1st April.
After a short vacation of Holi, I was returning back to Pune from Ahmedabad. To my disappointment, the train was even late by an hour. I had to spend more than an hour at the platform. I went to the Waiting Hall but it was full more than its capacity. I came out of it and went to the stairs of the flyover made to cross the platform. I sat comfortably and took a glance all over the station. Beggars were begging and the hawkers were selling their stuff. Suddenly a noise broke and I looked towards it. A beautiful girl of around 19 or 20 had lost her grip on the suitcase she was holding. Generally what happens, it happened here also. Lot of guys came forward to help her. They lift her suitcase, asked if she is alright and made her sit at a sophisticated place. I looked at her from a distance and somehow she seemed to me very pretty and attractive. When alone, every second girl seems to be attractive. Moreover I was feeling dizzy at the very idea of spending an hour at the platform.
Suddenly they announced”Sarathi Express coming from Bhuj to Pune is delayed by 3 hours. Your Inconvenience regretted.” This wrecked me from the core. I went to the girl and sat just in front of her. I was trying to take a glance at her but I observed she was continuously gazing at me as if I was insane. Suddenly I realized I am sitting on someone else’s luggage that was lying nearby. I got up in a flash but in hurry I tumbled down but somehow managed to hold myself. It was an utter embarrassment. I took out my novel and started reading it. Every when and then my eyes were looking for her. I was scanning all her activities. She was all sport, all alone but still so enthusiastic. She has put earplugs into her ears and was listening to some music; it was hard rock I suppose. Getting enthralled at times she was shaking her body too. She took her magazine out but kept it inside soon. Then took some stuff from her hand bag and started playing with it. It was small toy car I noticed. Even this was not pleasing her anymore; she threw it off in the bag and started singing some song loudly. She had almost forgotten that she is at public place and she was not supposed to do this. An Old man beckoned her to stop it. She started talking to him. I was wondering if what they must be talking; Father –daughter kind of stuff!!! Or some social topic or what! I thought for a minute to take part in the conversation but I saw that old man left in between and I stopped myself halfway. She saw me coming towards her but showed if she has never seen me before. I came back to my place and again looked back at her. For some time nothing happened between us except few eye contacts. Again I saw her playing with a kid. I was feeling jealous of the boy who was playing in her lap. He was playing with her hairs and she was pampering him.
All of a sudden, the announcement came for the arrival of the train. Already it was 10:00 PM; I looked into my watch. Soon the train came; I rushed into Sleeper coach and found my seat. All the ideas of that girl vanished in moment. I slept tightly like a baby.
When I wake up early in the morning, I asked the pantry person who was selling tea”Bhaiya!!! How long it will take to reach Pune??” He smirked “Sir!!! The train is 8 hours late. It will take three more hours to reach Mumbai. Then after that three more for Pune.” I got aghast at this but nothing was in my control.
Suddenly a female voice pinched me from behind” mumbai paachhad toh nai rahi gayu??”. It was she, the same girl. At first I didn’t understand what to say. So I just nodded. The gentleman who was sitting below replied instantly in Gujrati “train moodi che 6 kallak thi ! mumbai jaava 3 kalaak lagse.”. Nobody leaves a chance to show off. He continued “Hi I am Hiren! Are you coming from Bhuj??” She replied negatively “I am coming from Ahmedabad. I have to attend a seminar today in my college but I will be late I suppose.” He nodded in sympathy” Oh that’s bad!!! By the way I am an engineering student infact E&TC one. I stay in Kalyan. ” She replied” I study in Sardar patel College in Andheri.” It was quite evident that she was enjoying his company and I was feeling jealous at it.
“Hey what a coincidence! I am also an E&TC engineering student” I dropped myself in between their conversation from nowhere. They were astonished but smiled. I looked at her and apologized “Sorry!!! I don’t understand Guajarati…That’s why I stood like dumb” Everyone laughed. I started”I am coming from a Project Exhibition in Ahmedabad. I started talking about the companies which visited the college campus to patronize the program. I was giving all my best to impress her.” I saw she was no more interested in all this technical stuff. So I invited them to play cards. They agreed. But I made a mistake here. He was a champ in playing cards.
He very soon swept three four games in a row. I will never suggest any of my friends to give challenge any Gujarati at least for playing cards. She was enjoying every moment of it. I felt him taking an edge over me. But I was consoling myself within that this guy has to get down before both of us. So still I had a chance. They stopped playing card and started playing jokes. I also got involved in that and showed my skills. Both of them praised my sense of humor.
At the next stop he was about to get down. “I will get down at next stop. Hey Sorry I didn’t even ask your name” He giggled at me. “I am Viki and she is…” I beckoned towards her deliberately so that at least now she will reveal her name. She continued”I am prakruti”. I knew that prakruti means nature but still to carry on the conversation I exclaimed “Enviroment. Right ??”. Hiren tried to shine in between “No yaar , It means Earth”. Prakruti screamed “ STOP IT!!! Boys…it means nature”. Oh..such a sweet meaning I complimented her. Hiren shook hands with both of us and got down. I thanked God at the devil’s exit. She put her earplugs again and lost in it completely. I smirked “She has started listening the same Rock song.” It was quite apparent from her movements. I couldn’t resist anymore and asked “Are you listening to Hard Rock!!!” She was amused at this and making irregular faces said “No...It is a Guajarati folk song”. I burst into laughter but realized “Girls will be Girls”. I flattered”you seem to have a very good knowledge of music. Your face expression and body movement reveals so”. Every girl wants to hear her praise and she was no different. I kept on scoring runs on that slow pitch like Virendra sehwag. But it has to come to an end. Her stop came and she was about to get down. I was still staring at her eyes. She left without saying anything not even bye. I was surprised at this but kept mum. Suddenly after a while some unknown thrust from inside forced me out of the train. I screamed from behind “Prakruti wait!!!” She halted instantly and looked back. I reached there and asked for her number. I never knew I can be so bold. She pronounced some number but I asked her to write it on my palm since I had no paper with me. The train was about to leave. She tried to write her number on my palm but since it was wet all in vain. She slide my shirt cuff and wrote her number on my wrist.
I heard the whistle of train and rushed towards my compartment. I was immensely overjoyed. All the way I was thinking how I can build relationship with her. I had even planned to buy a cell phone. How a girl can impact one’s mind, it was quite evident there. The guy who never spends extravagantly was thinking to buy a cell phone. In few hours I reached Pune.
I tried to call her from a PCO but the number was coming unreachable. All my plans went into trash soon I reached the college premises. The Security Guard told me that there was a call for me of my parents. I went back to the PCO and got the news of my younger brother’s accident in Bangalore. I was required there since nobody was there to take care of him. I returned back with a heavy heart. Ved, one of my friends noticed it. I told him about my brother’s accident. In the hurry he arranged for my travel as he knew a travel agent. As a part of gratitude I handed over the cell number of that girl to him. After hearing all that stuff he was enthralled” buddy! Don’t worry I will take care of everything”. Moreover he had a cell phone so he was absolutely a better choice for a distance relationship.
In a fortnight, I was back to my place. I went to my friend’s room but he was not there. I asked his fellow roommate. He grinned “must be talking to his girl. I am fed up with him. He even talks in night and disturbs my sleep.” I would be mean if I will blame him for this, I thought. So I kept mum. From inside, I was curious to know if she is the same girl whose number I had given to him. Somewhere in the corner of my heart I was also feeling bit jealous of him. Soon he returned back to his room and found me. Being overjoyed he hugged me and asked about my brother. “He is alright now. Still needs some rest” I was keen to know about her. He continued “She is a sweetheart! We daily talk for hours and it seems we know each other from ages.” “Are you serious about this?? How you could be?? You have not even seen her. Better come to your flirting routine” I suggested and left for my room. I knew all his love is a crap only time pass nothing more.
I started neglecting that dear friend of mine. Not because I am saint and wanted to leave him with his girl but I always feel uncomfortable whenever he used to talk to her in front of me. One day He came to me and said” Dude! She loves me equally yaar. She wants to meet me. And I have asked her to come to Pune this Sunday. Please come along with me. ” Even I wanted to see Prakruti again but I declined” No Yaar what will I do there? Kabab me Haddi “. But he insisted me to come.
Days passed on and finally the much awaited Sunday arrived.
I was lying on bed. I was in no mood to get up. I put the blanket all over my body and slept again. But someone pulled it off and wakes me up. I saw him dressing up with full zeal. He picked his best shirt from the wardrobe and put it on the bed. He first shaved and went to take a bath. He took almost half an hour for it. Generally he used to take bath once in a week. He put the perfume combed his hair. I was watching all this as if a TV serial was going on in front of me. He was writing something on a piece of paper. When I closely saw it, it was a greetings card for the first love. I wondered how many first loves this guy had. He tucked a rose into it and was now all prepared to go. I apologized for the delay and asked for ten minutes. I brushed my teeth, washed my face and sprayed deo and left with him. Well in College Hostels taking bath is considered as a special occasion. More over this time I was in hurry so no question of taking bath. In an hour or so we reached there at station. Ved was constantly there on phone all his way discussing where she supposed to wait, what kind of get up he has and asking her get up as well. I overheard that she is wearing a blue Capri and white T. He instructed her to come out of gate no 1. He left to receive her towards Gate. I stayed back.
In a flash I saw him running towards me. Run Vikki! Run…He screamed from a distance. I had no clue what he was talking But I ran. I asked him what happened. He sighed “Thank God, I am spared. She is not at all good looking. Oh...How did I put myself into her trap? Anyway let’s get back to hostel.” He was trying to hide his face. Even I was feeling like laughing on his hard luck but suddenly the poor thought of that innocent girl struck. I yelled at him” Are you crazy!!! That girl is coming from Mumbai to meet you and you coward, you are doing this to her. Go and spend some time with her. In the evening send her back to Mumbai. And tell her after some days that you don’t love her. She will understand it. But For now just go to her.” He said” If you are feeling so much about her, why don’t you go and show her the city. Take my cell, contact her and move. I am leaving”. He was shameless as ever and I was helpless as always.
I was standing alone there. I was amused how that beautiful girl whom I met in the train can turn out to be so ugly. With a heavy heart I moved towards Gate No 1. I saw a girl in the same outfit. I went to her greeted” Hi. I am Vikki. I know you are looking for Ved but he has got a very urgent college work now. So he has left for the university in between from the halfway. And he has sent me to receive you. He will be back in few hours.” I was quite hesitant in it but said” I am feeling very sorry about it. If you don’t mind you can come with me. By then he will come back I can take you to some coffee shop.” But she declined gracefully”No thanks! Even I have to go back due to some urgent work”. Needless to say that she understood every bit of what happened there. I saw her moist eyes and cursed Ved for all this. InFact I was the root cause for all this. I took the ticket for the next train to Mumbai. I said Bye to her and came back.
My head was aching. So I took a disprin. After some time I went to PCO to call that girl, just to know If she has reached safe. Soon the call got connected, a female voice came from the other end “Hi , Prakruti speaking…”. I was freezed at this. This was her voice whom I met in the train. I mumbled” Can you guess who is speaking??”
She replied naughtily “Hiren Stop it!!! Now switch back to your original voice. I know today is 1st April and you cannot make me fool. Come home soon. I am waiting for you”. I lost my grip on the phone. I redialed and then realized my mistake. Earlier I had dialed a wrong number. The last digit I pressed zero instead of eight.
I checked the date in my watch. It was 1st April.... April Fool…
I realized she made me fool long before and destiny made me this realize on 1st April.
She.....
She.....
POOoooooooooooo….n…… the whistle of train generally excites those who are outside it. But I was inside lying on my berth waiting desperately for Pune station to come. I had finished two books already and was in no mood to go for the third one. The excitement of coming back to Pune for awhile was enthralling me. In fact it was going to be a very brief visit but still in few next moments I would be at the place where I spent my most of the young life perhaps the advent of my JAWANIHOOD.I had to just get some papers verified and attested from my Last company. My stay was arranged in company campus only. I had decided that I will stay for a night only.
Soon the train reached at Pune Station. It was a pleasant evening. I rushed for a taxi and asked him to go to Hinjewadi. Then I poured myself in whirlpool of old memories of this place. Suddenly when I broke out of it, we were somewhat near Wakad where I stayed for more than two years with two of my best friends. Out of my astonishment I got down at that crossroad where one very life impacting incident of my Life happened few years back.I never knew before this happened that sometimes what just starts with a prank can turn to be so devastating. I couldn’t stop myself from blaming myself for all that what happenend that night. I ruined my dear friend's life...I sighed within myself.
I saw three guys coming from a distance. All the faces seemed to be familiar. I could recognize them.. Hey it was me (Akash) with Siddhartha (Sid) and Samir (Sam).
I could hear what they were discussing.
Sam was prompting something to Sid. “Hey Sid, we want to gift you something on your birthday. If you are ready for that , well and good else don’t ask for any other gift”. I too nodded “This is the time to fulfill your wishes man. Some time down the line, you will get married and lose your freedom. So better enjoy your singlehood.” I grinned. I pointed to the T shirt Sam was wearing. The punch line written on it was “I am still single but this time with experience”. Sam chuckled” If you want I can get one for you tonight”.
Sid didn’t say anything just moved from his place. I knew Sid is a fattoo. It is not his cup of tea. He will never agree on this. But we never know what could be his reaction as we are so unsure about his mood. Suddenly He said “OK!!! I am ready. But now you are trapped. You big ass. Go and arrange a girl for me tonight as my birthday gift. If you cannot, I am going to bump your head”. Saying this he left for home.
I was stunned. So as Sam was. No one expected this from our cool customer Sid. But now this has turned to be a matter of ego. I was clueless about how Sam is going to keep his promise. I just knew that I have to share the half of the expenses whatever it is. I was angry within but couldn’t do much as I was also half responsible for it. I looked at Sam’s face. He was panicked but was trying to hide all his emotions. “I know one medical shop here. I guess the shop keeper can help. He must have some idea I feel. He was talking regarding this to someone last Sunday when I visited him”.
“I am not a part of this. I screamed. I don’t care for your promise or ego whatever. I don’t want to get crushed publicly” I said terrified. But Sam pleaded “Don’t leave me like this man. You simply can’t. Just stay with me. Don’t do anything. I will take care of everything.” OK..I agreed. I was sure Sam has no guts to do this. But I accompanied him.
He went towards the Shop. I was watching him from a distance. But he returned halfway. I smiled at him and said Lets go back and play cards at home. “No yaar few guys are there. Let them move from there”.
He was moving to and fro like a pendulum. I was excited from within just wanted to see the outcome of the whole episode. Moreover deep inside I was frightened. I guess we stayed there looking at shop for more than an hour. I looked at my watch. It was showing 10:00PM. I said “I am leaving. All the best you carry on your expedition”. I rushed towards our home. Sam too followed me.
Very soon he caught me and yelled out “You coward!!! Don’t show your face again”. I was walking steadily. Suddenly a harsh voice asked us to stop from behind. We looked back. A guy of age 27-28 was there. He came closer and muttered “I saw you at the shop discussing something for a long time. Can I help you?” I said “No. Thanks” and moved forward. After some time I realized Sam is not walking along me. I turned back to see what happened. I saw him talking to that guy. Soon he came to me. He was looking relieved. I asked what happened. He laughed loudly “That guy was an agent. My part DONE. Now I will see what guts Sid has”. While we were returning a black cat crossed the road ahead of us. It was a bad omen. I was too afraid to say anything. Still I said “Stop It. Here itself and close the deal.” But Sam was adamant.
We entered the house. Sid was watching the movie “DIL CHAHTA HAI”. Sam ecstatically said “I have arranged a bride for you for tonight. Enjoy your Birthday Gift. She will be coming in few minutes”. Sid got fainted at this but controlled himself and said” You morons move from here. I will tackle everything”. Suddenly the door bell rang. We two rushed to upstairs and seized ourselves in my room.
Next morning when we got up, it was already 11 am. Sid was not there downstairs. We searched the entire house. But we didn’t find him. The day passed and in the evening around 7, I with Sam went to have some tea at the chowk. We saw Sid coming from a distance. He was enthralled even he hugged Sam. I was clueless wondering what happened to this guy.
Sid started “The girl’s name is Shalini. She is very good girl. So enthusiastic and refreshing. I was with her for entire day. We roamed around throughout the city.” Sam interrupted in between “Did anything happen last night you dumb” couldn’t control his excitement. Sid said “No. I took her back home. But I met her today morning and we hanged around together. I don’t know but I guess I have developed some feelings for her.”
“What rubbish feelings!!! Are you sick??” I nearly screamed at him. Sam was equally amused “ Have you gone nuts!!! Think of the girl you are planning to settle with..She is a bloody…I simply can’t accept this”.
But I guess there was no impact of all this on Sid. He was adamant as always. Nevertheless we were much bothered about his parents.
Sid tried to convince us “Look guys!!! I was with her for entire day. I know how tough it is to lead life at her place. She is not doing all this with her will. She is forced to do all this as her younger brother is in Hospital undergoing a treatment for blood cancer. Now I will handle everything. Just do me a favor. You guys please don’t tell my parents about all this. When the right time will come I will tell them myself.” We were astonished by the guts of this chap. I guess sometimes for a man, his reputation is everything. That’s why we stopped talking to Sid for a while. It was a clear indication that he has to either choose her or us. Days followed on and he kept meeting her.
But finally this has to come to an end. Sam called Sid’s parents and bitched everything. Of course I was with him in this holy act of his. They were shocked after hearing this. His Dad showed up next morning. He locked himself in a room with Sid. After few minutes Sid came out crying “ My mom is ill. I have to go back to my place at the earliest.” Both of them left in the afternoon.
Days passed on. We were waiting for Sid to come back. But neither he nor his phone came. I was afraid if he will ever show up. One day his resignation letter came. I was shocked and so was Sam. We had lost our dear friend. I didn’t know whether we should regret or what. But a burden was there in back of my mind. We were missing him. Suddenly one fine day I got opportunity to go Onsite for a project running out of Australia. I restarted my life from there leaving behind all the miseries. Time passed on and then I travelled various places across the globe. Sam also moved to United states for higher education and got settled there. But still no clue of Sid. What happened to him. Where is he? How is he? No idea at all.
“Eiiii…..” suddenly I came out of my dream by this noise. Probably it came out of that car when it applied its brakes. I saw the indicators turning on and off. The car owner was on call as the car was on halt. Still the indicators were on. I was bit surprised at this but neglected it. All of a sudden I saw a lady inching towards that car. Alas it was she..SHALINI…
All of a sudden all the burden on my head went off. I was now much relieved and I sighed “I saved him. I saved my dear friend.” I got up and left for my destination.
POOoooooooooooo….n…… the whistle of train generally excites those who are outside it. But I was inside lying on my berth waiting desperately for Pune station to come. I had finished two books already and was in no mood to go for the third one. The excitement of coming back to Pune for awhile was enthralling me. In fact it was going to be a very brief visit but still in few next moments I would be at the place where I spent my most of the young life perhaps the advent of my JAWANIHOOD.I had to just get some papers verified and attested from my Last company. My stay was arranged in company campus only. I had decided that I will stay for a night only.
Soon the train reached at Pune Station. It was a pleasant evening. I rushed for a taxi and asked him to go to Hinjewadi. Then I poured myself in whirlpool of old memories of this place. Suddenly when I broke out of it, we were somewhat near Wakad where I stayed for more than two years with two of my best friends. Out of my astonishment I got down at that crossroad where one very life impacting incident of my Life happened few years back.I never knew before this happened that sometimes what just starts with a prank can turn to be so devastating. I couldn’t stop myself from blaming myself for all that what happenend that night. I ruined my dear friend's life...I sighed within myself.
I saw three guys coming from a distance. All the faces seemed to be familiar. I could recognize them.. Hey it was me (Akash) with Siddhartha (Sid) and Samir (Sam).
I could hear what they were discussing.
Sam was prompting something to Sid. “Hey Sid, we want to gift you something on your birthday. If you are ready for that , well and good else don’t ask for any other gift”. I too nodded “This is the time to fulfill your wishes man. Some time down the line, you will get married and lose your freedom. So better enjoy your singlehood.” I grinned. I pointed to the T shirt Sam was wearing. The punch line written on it was “I am still single but this time with experience”. Sam chuckled” If you want I can get one for you tonight”.
Sid didn’t say anything just moved from his place. I knew Sid is a fattoo. It is not his cup of tea. He will never agree on this. But we never know what could be his reaction as we are so unsure about his mood. Suddenly He said “OK!!! I am ready. But now you are trapped. You big ass. Go and arrange a girl for me tonight as my birthday gift. If you cannot, I am going to bump your head”. Saying this he left for home.
I was stunned. So as Sam was. No one expected this from our cool customer Sid. But now this has turned to be a matter of ego. I was clueless about how Sam is going to keep his promise. I just knew that I have to share the half of the expenses whatever it is. I was angry within but couldn’t do much as I was also half responsible for it. I looked at Sam’s face. He was panicked but was trying to hide all his emotions. “I know one medical shop here. I guess the shop keeper can help. He must have some idea I feel. He was talking regarding this to someone last Sunday when I visited him”.
“I am not a part of this. I screamed. I don’t care for your promise or ego whatever. I don’t want to get crushed publicly” I said terrified. But Sam pleaded “Don’t leave me like this man. You simply can’t. Just stay with me. Don’t do anything. I will take care of everything.” OK..I agreed. I was sure Sam has no guts to do this. But I accompanied him.
He went towards the Shop. I was watching him from a distance. But he returned halfway. I smiled at him and said Lets go back and play cards at home. “No yaar few guys are there. Let them move from there”.
He was moving to and fro like a pendulum. I was excited from within just wanted to see the outcome of the whole episode. Moreover deep inside I was frightened. I guess we stayed there looking at shop for more than an hour. I looked at my watch. It was showing 10:00PM. I said “I am leaving. All the best you carry on your expedition”. I rushed towards our home. Sam too followed me.
Very soon he caught me and yelled out “You coward!!! Don’t show your face again”. I was walking steadily. Suddenly a harsh voice asked us to stop from behind. We looked back. A guy of age 27-28 was there. He came closer and muttered “I saw you at the shop discussing something for a long time. Can I help you?” I said “No. Thanks” and moved forward. After some time I realized Sam is not walking along me. I turned back to see what happened. I saw him talking to that guy. Soon he came to me. He was looking relieved. I asked what happened. He laughed loudly “That guy was an agent. My part DONE. Now I will see what guts Sid has”. While we were returning a black cat crossed the road ahead of us. It was a bad omen. I was too afraid to say anything. Still I said “Stop It. Here itself and close the deal.” But Sam was adamant.
We entered the house. Sid was watching the movie “DIL CHAHTA HAI”. Sam ecstatically said “I have arranged a bride for you for tonight. Enjoy your Birthday Gift. She will be coming in few minutes”. Sid got fainted at this but controlled himself and said” You morons move from here. I will tackle everything”. Suddenly the door bell rang. We two rushed to upstairs and seized ourselves in my room.
Next morning when we got up, it was already 11 am. Sid was not there downstairs. We searched the entire house. But we didn’t find him. The day passed and in the evening around 7, I with Sam went to have some tea at the chowk. We saw Sid coming from a distance. He was enthralled even he hugged Sam. I was clueless wondering what happened to this guy.
Sid started “The girl’s name is Shalini. She is very good girl. So enthusiastic and refreshing. I was with her for entire day. We roamed around throughout the city.” Sam interrupted in between “Did anything happen last night you dumb” couldn’t control his excitement. Sid said “No. I took her back home. But I met her today morning and we hanged around together. I don’t know but I guess I have developed some feelings for her.”
“What rubbish feelings!!! Are you sick??” I nearly screamed at him. Sam was equally amused “ Have you gone nuts!!! Think of the girl you are planning to settle with..She is a bloody…I simply can’t accept this”.
But I guess there was no impact of all this on Sid. He was adamant as always. Nevertheless we were much bothered about his parents.
Sid tried to convince us “Look guys!!! I was with her for entire day. I know how tough it is to lead life at her place. She is not doing all this with her will. She is forced to do all this as her younger brother is in Hospital undergoing a treatment for blood cancer. Now I will handle everything. Just do me a favor. You guys please don’t tell my parents about all this. When the right time will come I will tell them myself.” We were astonished by the guts of this chap. I guess sometimes for a man, his reputation is everything. That’s why we stopped talking to Sid for a while. It was a clear indication that he has to either choose her or us. Days followed on and he kept meeting her.
But finally this has to come to an end. Sam called Sid’s parents and bitched everything. Of course I was with him in this holy act of his. They were shocked after hearing this. His Dad showed up next morning. He locked himself in a room with Sid. After few minutes Sid came out crying “ My mom is ill. I have to go back to my place at the earliest.” Both of them left in the afternoon.
Days passed on. We were waiting for Sid to come back. But neither he nor his phone came. I was afraid if he will ever show up. One day his resignation letter came. I was shocked and so was Sam. We had lost our dear friend. I didn’t know whether we should regret or what. But a burden was there in back of my mind. We were missing him. Suddenly one fine day I got opportunity to go Onsite for a project running out of Australia. I restarted my life from there leaving behind all the miseries. Time passed on and then I travelled various places across the globe. Sam also moved to United states for higher education and got settled there. But still no clue of Sid. What happened to him. Where is he? How is he? No idea at all.
“Eiiii…..” suddenly I came out of my dream by this noise. Probably it came out of that car when it applied its brakes. I saw the indicators turning on and off. The car owner was on call as the car was on halt. Still the indicators were on. I was bit surprised at this but neglected it. All of a sudden I saw a lady inching towards that car. Alas it was she..SHALINI…
All of a sudden all the burden on my head went off. I was now much relieved and I sighed “I saved him. I saved my dear friend.” I got up and left for my destination.
Sunday, August 30, 2009
SSIS Best practices
SSIS Best practices
1. Readme.doc – explains the thorough purpose and functionality of the package.
2. Names for all tasks, objects, and connections should be self descriptive about the purpose. Never hard code specific database or server in names since it might change.
3. Modular structure of packages i.e. multiple number of packages is preferred over one big package to cover a big complex functionality.
4. SSIS has a significant amount of built-in functionality; use that instead of custom scripting.
5. Use configuration files to take the connection string or other properties which might change and export only configurable values.
6. Use SSIS built-in logging capabilities to log serious package error conditions and any additional information that may be useful for troubleshooting the package.
7. Use checkpoints in your packages i.e. the tasks need to be organized in a logical manner and if it makes sense, group them together via the Sequence Container to allow for the logical restart of the group if one of the tasks inside the container failed.
8. Store SSIS Configuration files in the designated folder given by DBA and it should be accessible from all the environments.
9. We should manage the configuration files to allow the same SSIS package to run in dev, test and prod environments.
10. Learn how to create a SSIS configuration file.
11. We should structure SSIS packages and configuration files with the goal of minimizing the number of different SSIS packages deployed, especially in cases where SSIS packages are very similar to one another except for some key properties, such as server and database names
12. Developers that need to connect to SSIS on a server will need to be granted membership to the “Distributed COM Users” group on that machine.
13. Learn how to deploy a package.
14. We can create SQL serve Jobs in SQL Agent to execute SSIS package.
15. Security
Protection Mechanism Details
Set protection level of packages Protection Level: ServerStorage
The protection afforded is based on SQL Server database roles. The protection level will rely on server storage and roles for access control. All packages saved in MSDB will use this protection level.
Save packages to MSDB Package Storage Location: MSDB
Saving packages to the msdb database will help provide security and the server, database, and table levels. Packages saved in MSDB will benefit from the integration service database level roles (db_ssisadmin, db_ssisltduser, db_ssisoperator). Any other options aside from saving to MSDB will be evaluated in a case by case basis and discussed with the database administrators and the information security office.
Save logs to MSDB Log Location: MSDB
Logs to MSDB. This enhances the availability of log data to tech supports outside of SQL Server. Other advanced logging options outside of SQL Server will be evaluated in a case by case basis and discussed with the database administrators and the information security office.
Save configuration in XML format Configuration Location: File system (XML format)
Ensure that configuration file has no sensitive data (e.g. connection strings) and the file and folder it is located is properly secured. Contact the appropriate database administrator and the Information Security Office for assistance for securing the folder.
Use of SQL Jobs in Package Execution Package Execution: through SQL Jobs
All packages should be executed from a SQL job. Packages executed other ways (e.g. Windows Scheduler) need to have a notification process established and should be an exception of the rule.
16. Monitoring folders for dropped files.
17. moving files from one file to another.
18. Copying data from an excel spread sheet into SQL Server.
19. Logging.
20. SSIS Naming conventions
companyname_application_taskDescription
Verify that the name and description of the task of component sufficiently describes it. Often times, the default name and description assigned to a task or component may not clearly or accurately indicate its purpose.
Prefix each task or component’s name with an identifier to describe the type of task or component it is.
[SSIS Package Name]_[Environment Name].dtsConfig
1. Readme.doc – explains the thorough purpose and functionality of the package.
2. Names for all tasks, objects, and connections should be self descriptive about the purpose. Never hard code specific database or server in names since it might change.
3. Modular structure of packages i.e. multiple number of packages is preferred over one big package to cover a big complex functionality.
4. SSIS has a significant amount of built-in functionality; use that instead of custom scripting.
5. Use configuration files to take the connection string or other properties which might change and export only configurable values.
6. Use SSIS built-in logging capabilities to log serious package error conditions and any additional information that may be useful for troubleshooting the package.
7. Use checkpoints in your packages i.e. the tasks need to be organized in a logical manner and if it makes sense, group them together via the Sequence Container to allow for the logical restart of the group if one of the tasks inside the container failed.
8. Store SSIS Configuration files in the designated folder given by DBA and it should be accessible from all the environments.
9. We should manage the configuration files to allow the same SSIS package to run in dev, test and prod environments.
10. Learn how to create a SSIS configuration file.
11. We should structure SSIS packages and configuration files with the goal of minimizing the number of different SSIS packages deployed, especially in cases where SSIS packages are very similar to one another except for some key properties, such as server and database names
12. Developers that need to connect to SSIS on a server will need to be granted membership to the “Distributed COM Users” group on that machine.
13. Learn how to deploy a package.
14. We can create SQL serve Jobs in SQL Agent to execute SSIS package.
15. Security
Protection Mechanism Details
Set protection level of packages Protection Level: ServerStorage
The protection afforded is based on SQL Server database roles. The protection level will rely on server storage and roles for access control. All packages saved in MSDB will use this protection level.
Save packages to MSDB Package Storage Location: MSDB
Saving packages to the msdb database will help provide security and the server, database, and table levels. Packages saved in MSDB will benefit from the integration service database level roles (db_ssisadmin, db_ssisltduser, db_ssisoperator). Any other options aside from saving to MSDB will be evaluated in a case by case basis and discussed with the database administrators and the information security office.
Save logs to MSDB Log Location: MSDB
Logs to MSDB. This enhances the availability of log data to tech supports outside of SQL Server. Other advanced logging options outside of SQL Server will be evaluated in a case by case basis and discussed with the database administrators and the information security office.
Save configuration in XML format Configuration Location: File system (XML format)
Ensure that configuration file has no sensitive data (e.g. connection strings) and the file and folder it is located is properly secured. Contact the appropriate database administrator and the Information Security Office for assistance for securing the folder.
Use of SQL Jobs in Package Execution Package Execution: through SQL Jobs
All packages should be executed from a SQL job. Packages executed other ways (e.g. Windows Scheduler) need to have a notification process established and should be an exception of the rule.
16. Monitoring folders for dropped files.
17. moving files from one file to another.
18. Copying data from an excel spread sheet into SQL Server.
19. Logging.
20. SSIS Naming conventions
companyname_application_taskDescription
Verify that the name and description of the task of component sufficiently describes it. Often times, the default name and description assigned to a task or component may not clearly or accurately indicate its purpose.
Prefix each task or component’s name with an identifier to describe the type of task or component it is.
[SSIS Package Name]_[Environment Name].dtsConfig
Thursday, August 20, 2009
The Girl Next to me
Few things are destined to happen. And sometimes they are beyond our control. So I always go with the philosophy “Whatever happens, happen for good”.
Yesterday I was quite overloaded with work. “It is impossible to wrap up the pending work in next half an hour. I am definitely going to miss the bus” I said to myself. I gave up all the hope and decided to go home only after finishing the work left. I guess I could have completed the task if this thought wouldn’t have come in my mind. A human mind is like that only. The biggest obstacle lies only when we keep our eye off the goal. Somehow I was trying to keep myself focused on work but every now and then my eyes were frowning to the clock. People either give their best under pressure or break. The later part happened in my case. I got up from my seat and rushed towards the bus. I didn’t even think what I will say to my lead if he will ask tomorrow. My feet were moving steadily towards the bus.
I got into the bus but to my astonishment Not a single seat was vacant. I got down and took the other one. Even it was full. My destiny was riding me somewhere else. Finally I took the third one. To my relief I saw a seat vacant. I rushed towards it as if it was food and I was starving from years. I even didn’t bother to look if any other seat was vacant or who is sitting next to me. When I was going towards the seat I found Nishi in the next seat. Even she looked up at the same time and we had an eye contact. She got uncomfortable and so was I. I didn’t know what to do and in all this mess up I sat just next to her. I completely missed the vacant seat which was next to it. She had also noticed that. I was afraid what she must be thinking of me. She will take it as a deliberate act of mine. I noticed her face.she was getting pale. Totally embarrassed she was looking here and there.
I totally lost into my old memories of the AMEX days. We were in the same floor though different Projects.I was thoroughly disgusted with the idea of going into an ODC. I had heard a lot about ODC‘s being jail. No access to communicators, outlook etc. But soon I entered the ODC premises; all my ill feelings got vanished. I saw someone who was definitely not the most beautiful but the serenity of her face was extreme. I was spell bound to see such a wonderful creation of God. She was above par simple and sober.
Days followed on. Even I got busy in my project. But still I always find out ways of going near her cubicle to have a glance of her. Even a peep used to give me immense joy. My Gang in project was all sport. Soon they traced out my feelings for her. They all were very supportive throughout this one sided love saga. All the hiccups what was happening, even she was not a dumb, she sensed it all. When I sent friend request on IM, she declined it gracefully.One day while we were returning from lunch, she was reading newspaper all alone. “You won’t get a better than this chance to show your emotions” Sandy hissed. Rest supported him. Before I could say anything someone pushed me from behind towards her. I was totally in shock since she was sitting next to me. I mumbled “Hi! Anything new in the newspaper??” She was equally stunned. Before she could reply I said sorry and moved from there. I didn’t know why I behaved like that. I was in complete panic. I knew I messed up everything. The very next day I had to go to my home city. I was regretting why I did that foolishness. At least I could have waited till I will return from home. My stay at home could be much better if I would have taken the sweet memories of her with me. But it was other way round. When I returned back, my eyes were looking for her. But she was no more there. I asked my friends about her. Kash grinned “I have not seen her from last one week. She might have been released from the project”. All my regret went off. I was satisfied at least I spoke to her that day though one-sided again, but from so close. But I was unhappy from my heart. Days passed then months.
“Excuse me…Excuse me…Vikas...… Vikas Please give me way to go. I need to get down” This familiar voice wakened me up from my day dream. I said sorry and slightly moved from my seat. Gently she said thanks and got down at her stop.
I was cursing myself “you useless fellow…again you missed this chance…you were day dreaming when you should be talking to her...You are a big time loser…you understand Mr. vikas kumar..You are a big time loser…” I felt gloomy. But all of a sudden one thought passed by my mind. It took all the misery from my mind. I felt relieved. Hey she still remembers your name….In all those happiness I got down from the bus way behind my stop. But I was not regretting this time.
I rehearsed again “Whatever happens, happen for good”.
Yesterday I was quite overloaded with work. “It is impossible to wrap up the pending work in next half an hour. I am definitely going to miss the bus” I said to myself. I gave up all the hope and decided to go home only after finishing the work left. I guess I could have completed the task if this thought wouldn’t have come in my mind. A human mind is like that only. The biggest obstacle lies only when we keep our eye off the goal. Somehow I was trying to keep myself focused on work but every now and then my eyes were frowning to the clock. People either give their best under pressure or break. The later part happened in my case. I got up from my seat and rushed towards the bus. I didn’t even think what I will say to my lead if he will ask tomorrow. My feet were moving steadily towards the bus.
I got into the bus but to my astonishment Not a single seat was vacant. I got down and took the other one. Even it was full. My destiny was riding me somewhere else. Finally I took the third one. To my relief I saw a seat vacant. I rushed towards it as if it was food and I was starving from years. I even didn’t bother to look if any other seat was vacant or who is sitting next to me. When I was going towards the seat I found Nishi in the next seat. Even she looked up at the same time and we had an eye contact. She got uncomfortable and so was I. I didn’t know what to do and in all this mess up I sat just next to her. I completely missed the vacant seat which was next to it. She had also noticed that. I was afraid what she must be thinking of me. She will take it as a deliberate act of mine. I noticed her face.she was getting pale. Totally embarrassed she was looking here and there.
I totally lost into my old memories of the AMEX days. We were in the same floor though different Projects.I was thoroughly disgusted with the idea of going into an ODC. I had heard a lot about ODC‘s being jail. No access to communicators, outlook etc. But soon I entered the ODC premises; all my ill feelings got vanished. I saw someone who was definitely not the most beautiful but the serenity of her face was extreme. I was spell bound to see such a wonderful creation of God. She was above par simple and sober.
Days followed on. Even I got busy in my project. But still I always find out ways of going near her cubicle to have a glance of her. Even a peep used to give me immense joy. My Gang in project was all sport. Soon they traced out my feelings for her. They all were very supportive throughout this one sided love saga. All the hiccups what was happening, even she was not a dumb, she sensed it all. When I sent friend request on IM, she declined it gracefully.One day while we were returning from lunch, she was reading newspaper all alone. “You won’t get a better than this chance to show your emotions” Sandy hissed. Rest supported him. Before I could say anything someone pushed me from behind towards her. I was totally in shock since she was sitting next to me. I mumbled “Hi! Anything new in the newspaper??” She was equally stunned. Before she could reply I said sorry and moved from there. I didn’t know why I behaved like that. I was in complete panic. I knew I messed up everything. The very next day I had to go to my home city. I was regretting why I did that foolishness. At least I could have waited till I will return from home. My stay at home could be much better if I would have taken the sweet memories of her with me. But it was other way round. When I returned back, my eyes were looking for her. But she was no more there. I asked my friends about her. Kash grinned “I have not seen her from last one week. She might have been released from the project”. All my regret went off. I was satisfied at least I spoke to her that day though one-sided again, but from so close. But I was unhappy from my heart. Days passed then months.
“Excuse me…Excuse me…Vikas...… Vikas Please give me way to go. I need to get down” This familiar voice wakened me up from my day dream. I said sorry and slightly moved from my seat. Gently she said thanks and got down at her stop.
I was cursing myself “you useless fellow…again you missed this chance…you were day dreaming when you should be talking to her...You are a big time loser…you understand Mr. vikas kumar..You are a big time loser…” I felt gloomy. But all of a sudden one thought passed by my mind. It took all the misery from my mind. I felt relieved. Hey she still remembers your name….In all those happiness I got down from the bus way behind my stop. But I was not regretting this time.
I rehearsed again “Whatever happens, happen for good”.
Friday, August 7, 2009
Sometimes losing is everything.
Being Successful doesn't mean being satisfied...Success and Satisfaction are oxymoron at times. Sometimes only winning is important and not the way in which it is being achieved. Sacrifices lose value and the passion to win becomes the only objective. And so we die to win.
But, something happened to me recently, which forced me to believe that sometimes winning is not everything.
Sometimes losing is everything.
I had always wanted to start my own firm. I could never work under anyone. Because, for me I am the Boss and I can never take any orders from anyone. I don’t know when I developed this sort of feelings but it is there since I was a school going kid.
I always wanted to be at the supreme position of any organization and the easiest way was to start a firm of your own. But this was not easy at all, I had to make many sacrifices in life and here I am the chairperson of Groupwell advertising Ltd.
I was going through the emails of our clients and suddenly stuck on a mail from Mehta &Sons Ltd. Last week only we had given demo & quotation copy to them.
I thought it must be a confirmation mail from their side for the billing but to my disappointment it was rather a notification that they are giving their advertising rights to Shalini Advrt. Group. I was all stunned. We had already spent so much efforts and money into this project. I will not let it go like this.
I called up my legal consultant and asked him to look into this and to update me ASAP. In an hour I received a mail from Mrs Shalini Mathur, the managing director of our rival group. She had requested for a meeting with me. Generally I don’t entertain such mails but I didn’t know why I not only replied positively but also agreed to meet her in her company. Perhaps some force was driving me from behind.
In no time I reached her company entrance. I was about to go inside but suddenly I saw someone whom I can recognize even after 100 years. The receptionist was she…Farina…I was all amused. Oh my God after fourteen years I was seeing her. I never expected that I would see her as a receptionist. We were in the same class. She was probably the brightest student of my class and I always knew she would do something bigger in her life.
I could remember the last day when we met before I left for Mumbai for my higher education. Her eyes were moist and heart was crying. How I consoled her saying I wanted to grow, prosper do something extra ordinary. I need to focus on my career. Forget everything what was there between us. May be I could return but for now forget it completely. Moreover we are from different religions and I have neither the guts nor time to put this up in front of our parents. That very evening I came down to Mumbai to pursue higher education. After that everything changed and I forgot everything it as if no Farina was there in my life.
I called Mrs. Mathur and apologized that I am not feeling well so would meet her tomorrow.
I went to her with a heavy heart and greeted her. She was equally shocked to see me. She asked me the purpose of my visit but I gave an excuse. She took me to the cafeteria and we had coffee together. She used to be a sport in college days but here she seemed to be so sad. In an hour we talked very little, looked at each other and cried. She said she is still in contact with Rakshita who was our mutual friend. I took the contact number of Rakshita and promised that definitely I will call her up.
In the night I called Rakshita. Then I came to know how Farina fell in love with a Hindu boy. Then she got married with him against her parents wish. Both have been excluded from their family. He is still unemployed and often beats her up.
She is working somewhere as a receptionist since she couldn’t continue her education due to marriage.
I was feeling very sorry for her. I felt she missed my absence so much that she tried to fill it by Rakesh. And unfortunately he ruined her life. I knew I was responsible for it by some way or the other.
I called Mrs. Mathur in my office to sort out the things. She gave me No objection papers and pleaded me not to file any case against Mehta’s as this project is very important to them. This one can revive their ailing business and save from bankruptcy. I didn’t give her any words but assured for a discussion with my team.
It was very tough for me to decide what to do. All the hopes of my employees and their efforts were at stake. Above all my winning attitude was looking at me with jeer. On the other hand her job was at stake. I could offer her a job in my office but she will never accept I knew. It was the time for penance.
I signed on the NOC papers and sighed. Even after winning so many things I have never felt so relaxed in my whole life what I experienced after losing this one. This was an eternal satisfaction.
But, something happened to me recently, which forced me to believe that sometimes winning is not everything.
Sometimes losing is everything.
I had always wanted to start my own firm. I could never work under anyone. Because, for me I am the Boss and I can never take any orders from anyone. I don’t know when I developed this sort of feelings but it is there since I was a school going kid.
I always wanted to be at the supreme position of any organization and the easiest way was to start a firm of your own. But this was not easy at all, I had to make many sacrifices in life and here I am the chairperson of Groupwell advertising Ltd.
I was going through the emails of our clients and suddenly stuck on a mail from Mehta &Sons Ltd. Last week only we had given demo & quotation copy to them.
I thought it must be a confirmation mail from their side for the billing but to my disappointment it was rather a notification that they are giving their advertising rights to Shalini Advrt. Group. I was all stunned. We had already spent so much efforts and money into this project. I will not let it go like this.
I called up my legal consultant and asked him to look into this and to update me ASAP. In an hour I received a mail from Mrs Shalini Mathur, the managing director of our rival group. She had requested for a meeting with me. Generally I don’t entertain such mails but I didn’t know why I not only replied positively but also agreed to meet her in her company. Perhaps some force was driving me from behind.
In no time I reached her company entrance. I was about to go inside but suddenly I saw someone whom I can recognize even after 100 years. The receptionist was she…Farina…I was all amused. Oh my God after fourteen years I was seeing her. I never expected that I would see her as a receptionist. We were in the same class. She was probably the brightest student of my class and I always knew she would do something bigger in her life.
I could remember the last day when we met before I left for Mumbai for my higher education. Her eyes were moist and heart was crying. How I consoled her saying I wanted to grow, prosper do something extra ordinary. I need to focus on my career. Forget everything what was there between us. May be I could return but for now forget it completely. Moreover we are from different religions and I have neither the guts nor time to put this up in front of our parents. That very evening I came down to Mumbai to pursue higher education. After that everything changed and I forgot everything it as if no Farina was there in my life.
I called Mrs. Mathur and apologized that I am not feeling well so would meet her tomorrow.
I went to her with a heavy heart and greeted her. She was equally shocked to see me. She asked me the purpose of my visit but I gave an excuse. She took me to the cafeteria and we had coffee together. She used to be a sport in college days but here she seemed to be so sad. In an hour we talked very little, looked at each other and cried. She said she is still in contact with Rakshita who was our mutual friend. I took the contact number of Rakshita and promised that definitely I will call her up.
In the night I called Rakshita. Then I came to know how Farina fell in love with a Hindu boy. Then she got married with him against her parents wish. Both have been excluded from their family. He is still unemployed and often beats her up.
She is working somewhere as a receptionist since she couldn’t continue her education due to marriage.
I was feeling very sorry for her. I felt she missed my absence so much that she tried to fill it by Rakesh. And unfortunately he ruined her life. I knew I was responsible for it by some way or the other.
I called Mrs. Mathur in my office to sort out the things. She gave me No objection papers and pleaded me not to file any case against Mehta’s as this project is very important to them. This one can revive their ailing business and save from bankruptcy. I didn’t give her any words but assured for a discussion with my team.
It was very tough for me to decide what to do. All the hopes of my employees and their efforts were at stake. Above all my winning attitude was looking at me with jeer. On the other hand her job was at stake. I could offer her a job in my office but she will never accept I knew. It was the time for penance.
I signed on the NOC papers and sighed. Even after winning so many things I have never felt so relaxed in my whole life what I experienced after losing this one. This was an eternal satisfaction.
Thursday, August 6, 2009
Dealing with a Convoy in BizTalk
Biztalk is a messaging system which is based on traditional publish and subscribe approach. In few circumstances, we need to process messages in a way that the above approach cannot handle. To meet these special business requirements, convoys comes into the picture.
• Sequential convoy - Items that are in a order, one after another for example item 1 will finish and then item 2 will start and when it will finish item 3 will start. Once all completed an action will take place.
• Parallel convoy - Items that are in any order, but must all be present before something occurs. In this case all actions item 1, item 2 and item 3 will be processed parallely independently but once we get responses of all(the order doesnot matter),an action will take place.
Consideration for using convoy processing with a business process involves following these rules:
• The correlation set used on the Receive shapes may not contain more than three properties used for correlation. A correlation set is a list of properties with specific values that you use to route messages a specific business process. This is because these values identify and store at the database level. This has support for a maximum of three parameters.
• Parallel and sequential convoy may coexist in the same business process, but they may not share any correlation sets with each other. This is because each correlation set may only belong to one convoy.
• BizTalk Server 2004 does not support convoy processing when passing in an already initialized correlation set into a new orchestration using the start orchestration. This is because convoy sets handle at the database level, independent of already running orchestration instances.
Parallel Convoy is nothing but parallel shape with receive. So follwing rules applies to that:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
Sequential receive convoys can be additionally broken down into two sub-categories:
• Uniform sequential receive convoys
• Non-uniform sequential receive convoys
Uniform sequential receive message processing exists when many instances of a message is received and all must be handled by the same business process as in case of FILE Adapter if we want FIFO mechanism.
Non-Uniform Sequential Receives
In the non-uniform sequential receive design pattern, the receipt of two or more different types of messages occurs in a known order before the rest of the business process can continue. Definition of the order of the received messages occurs inside the business process, although BizTalk Server 2004 does not enforce the order other than for the first message.
Note: Convoys have the drawbacks of bottlenecks and zombies. So it should be only used when there is such a business requirement.
• Sequential convoy - Items that are in a order, one after another for example item 1 will finish and then item 2 will start and when it will finish item 3 will start. Once all completed an action will take place.
• Parallel convoy - Items that are in any order, but must all be present before something occurs. In this case all actions item 1, item 2 and item 3 will be processed parallely independently but once we get responses of all(the order doesnot matter),an action will take place.
Consideration for using convoy processing with a business process involves following these rules:
• The correlation set used on the Receive shapes may not contain more than three properties used for correlation. A correlation set is a list of properties with specific values that you use to route messages a specific business process. This is because these values identify and store at the database level. This has support for a maximum of three parameters.
• Parallel and sequential convoy may coexist in the same business process, but they may not share any correlation sets with each other. This is because each correlation set may only belong to one convoy.
• BizTalk Server 2004 does not support convoy processing when passing in an already initialized correlation set into a new orchestration using the start orchestration. This is because convoy sets handle at the database level, independent of already running orchestration instances.
Parallel Convoy is nothing but parallel shape with receive. So follwing rules applies to that:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
Sequential receive convoys can be additionally broken down into two sub-categories:
• Uniform sequential receive convoys
• Non-uniform sequential receive convoys
Uniform sequential receive message processing exists when many instances of a message is received and all must be handled by the same business process as in case of FILE Adapter if we want FIFO mechanism.
Non-Uniform Sequential Receives
In the non-uniform sequential receive design pattern, the receipt of two or more different types of messages occurs in a known order before the rest of the business process can continue. Definition of the order of the received messages occurs inside the business process, although BizTalk Server 2004 does not enforce the order other than for the first message.
Note: Convoys have the drawbacks of bottlenecks and zombies. So it should be only used when there is such a business requirement.
Tuesday, August 4, 2009
SQL Adapter & BizTalk
SQL Adapter & BizTalk
The SQL adapter retrieves an XML message from the BizTalk MessageBox and ultimately do operations in a remote SQL Server database, all based on the contents of the XML message. The SQL adapter enables BizTalk to poll a SQL Server database via a SQL query or stored procedure to retrieve rows as one or more XML messages. Conversely, the SQL adapter can be used to insert, update, or delete rows in SQL Server tables using the SQL updategrams or by invoking predefined stored procedures.
Major Concern while dealing with SQL adapter:
a) Same Record should not be fetched again and again:
Use Record status flag which is by default 0 means record is not yet picked.
Use data Range
b) Handle the Exceptions which may occur while doing operations into a SQL table.
SQL Adapter at Send side:
1. Updategram(Insert\Update\Delete)
a. Add Generated items Add Sql Adapter
i. conn string (Server Name,DBName, Port Name)
ii. Target Namespace (very imp)
iii. Request & response document root element name
iv. Select Updategram Select (Insert\Update\Delete)
This will create two artifacts in our solution. 1. Orchestration 2. Schema
The structure of the schema generated will be different for insert, update and delete.
The key concept while using Updategram is that we have a before and after section in the updategram message that SQL Server uses to figure out what to do with the data. For instance, having a record in the before but not in the after is equal to a Delete operation in SQL Server. Also, an after record with no before equals an Insert and a record in both the before and after results in an Update.
Again in admin console we need to give the connection string and other details while configuring the SQL Send Port.
Note: To modify multiple tables, we can run the wizard multiple times and then copy the generated schemas into a single shema. However this is achievable using updategrams but we prefer stored procedures for it.
2. Stored Procedure
Same as above except in point iv we select Stored Procedure, select the spname and generate.
This will also create two artifacts one orchestration and one schema.
Advantages using Stored Procedure over updategram:
1. SELECT\INSERT\UPDATE\DELETE possible.
2. Procedure can be called to return data from a DB.
3. We can have input params to the sp but could take the entire contents of the xml message and parse the contents of the message.
SQL Adapter at Receive side:
Steps are same as above in Stored Procedure.
Since queries in SQL returns rowsets, we need a mechanism to retrieve records in xml format.
FOR XML AUTO, XMLDATA, ELEMENTS is used for that.
For xml auto returns in xml format.
Xml data is required only while running the wizard to generate the schema for the resultset from the sp. While testing we should remove this clause.
IMPORTANT: BT uses the root element name and the namespace to route the inbound xml file. If both does not match to the xsd file created, it will give routing errors.
For XML Explicit gives developer greater level of control in the resulting XML structure that is returned to BizTalk.
Adapter Configurations:
1. Poll while data found: indicates whether to continue polling for new records in additional batches or whether to submit a single query result for the entire polling window.
2. Polling interval: Identifies how often to poll for records.
3. Polling unit of measure: Identifies the unit of measure for polling.
4. connection string
5. Document Root element name
6. document Target namespace
7. SQL command
8. URI : Identifies a unique identifier for the receive location. This value is autogenerated.
I think this is enough of SQL adapter basics as far as its connectivity to BizTalk engine is considered. Lately I have come across a very good article on the same at this:
http://blogs.msdn.com/richardbpi/archive/2005/06.aspx
The SQL adapter retrieves an XML message from the BizTalk MessageBox and ultimately do operations in a remote SQL Server database, all based on the contents of the XML message. The SQL adapter enables BizTalk to poll a SQL Server database via a SQL query or stored procedure to retrieve rows as one or more XML messages. Conversely, the SQL adapter can be used to insert, update, or delete rows in SQL Server tables using the SQL updategrams or by invoking predefined stored procedures.
Major Concern while dealing with SQL adapter:
a) Same Record should not be fetched again and again:
Use Record status flag which is by default 0 means record is not yet picked.
Use data Range
b) Handle the Exceptions which may occur while doing operations into a SQL table.
SQL Adapter at Send side:
1. Updategram(Insert\Update\Delete)
a. Add Generated items Add Sql Adapter
i. conn string (Server Name,DBName, Port Name)
ii. Target Namespace (very imp)
iii. Request & response document root element name
iv. Select Updategram Select (Insert\Update\Delete)
This will create two artifacts in our solution. 1. Orchestration 2. Schema
The structure of the schema generated will be different for insert, update and delete.
The key concept while using Updategram is that we have a before and after section in the updategram message that SQL Server uses to figure out what to do with the data. For instance, having a record in the before but not in the after is equal to a Delete operation in SQL Server. Also, an after record with no before equals an Insert and a record in both the before and after results in an Update.
Again in admin console we need to give the connection string and other details while configuring the SQL Send Port.
Note: To modify multiple tables, we can run the wizard multiple times and then copy the generated schemas into a single shema. However this is achievable using updategrams but we prefer stored procedures for it.
2. Stored Procedure
Same as above except in point iv we select Stored Procedure, select the spname and generate.
This will also create two artifacts one orchestration and one schema.
Advantages using Stored Procedure over updategram:
1. SELECT\INSERT\UPDATE\DELETE possible.
2. Procedure can be called to return data from a DB.
3. We can have input params to the sp but could take the entire contents of the xml message and parse the contents of the message.
SQL Adapter at Receive side:
Steps are same as above in Stored Procedure.
Since queries in SQL returns rowsets, we need a mechanism to retrieve records in xml format.
FOR XML AUTO, XMLDATA, ELEMENTS is used for that.
For xml auto returns in xml format.
Xml data is required only while running the wizard to generate the schema for the resultset from the sp. While testing we should remove this clause.
IMPORTANT: BT uses the root element name and the namespace to route the inbound xml file. If both does not match to the xsd file created, it will give routing errors.
For XML Explicit gives developer greater level of control in the resulting XML structure that is returned to BizTalk.
Adapter Configurations:
1. Poll while data found: indicates whether to continue polling for new records in additional batches or whether to submit a single query result for the entire polling window.
2. Polling interval: Identifies how often to poll for records.
3. Polling unit of measure: Identifies the unit of measure for polling.
4. connection string
5. Document Root element name
6. document Target namespace
7. SQL command
8. URI : Identifies a unique identifier for the receive location. This value is autogenerated.
I think this is enough of SQL adapter basics as far as its connectivity to BizTalk engine is considered. Lately I have come across a very good article on the same at this:
http://blogs.msdn.com/richardbpi/archive/2005/06.aspx
Sunday, August 2, 2009
A ROADIES LIFE
Life is a Roadies and it goes on. Only the players change. We meet with several people in the due course. Few faces remain with us for entire of our lives, few leave impact on us even after they leave and few change the way of our living. It’s a whirlpool of cycles. One new cycle starts from the one last ended.
Every year thousands of trainees come to Mysore, The Institution. I never knew that this place will lay a foundation of friendship which will go so far. Six strangers each with their own qualities were the part of one of the huge batches ever. The journey started in bunch of two’s Vasu and Gadoo, me and Deep, Sharma and Jaychi. Most probably I was the common link. The Hell down under was over and we all moved to Hyderabad, our next destination. Then I can never forget future plans of Gadoo to set up a own s/w firm where he projected himself and me as manager. Jaychi, Vasu and Deep will be the coding experts. And Sharma will bring tea for everyone .We always used to pull his leg. He was our favorite.
A major vote out and Gadoo, me and deep were thrown out of the Hostel but we were still in game. Niks entered with a wild card entry. On weekend’s parties at our flat and late night playing cards was the weekly routine. The gelling between me Deep and Gadoo was like sugar in a juice. The Compre heat was on and sun was at its peak but we always remained comfortable in each other’s company. And Remember the competition was on between me and Gadoo for the number of pranks we did. And believe me this was the sanjivani which always brought smile on our faces even in the gloomier moments. Whenever In my life I will think of those moments it will make my heart lighter and fill with joy. But every joy has to come to an end and it was again a time for the opt out.
One has to go and Gadoo opted himself out due to some of his other higher priorities. We were still super six but we always missed him. I learnt from Gadoo that how to get things done even in struggle time.
Then the next destination was Pune. Super six got engaged in their work, trying hard to lose their immunity. I witnessed two more wild entries Abhi and Pranab and we become entertaining Eight.
The highlights of Lilly for me will be definitely the cricket inside the house and the night we spent on the Water tank over the terrace watching the girl in next building. Of course the bike of Jaychi added an attraction to our house. But this just lasted for very brief as one more Opt out and he opted to go back to his home city. I learnt from Jaychi that how a person can be so down to earth even after getting such a genius mind.
We were sensational seven left and got shifted to a new place Vrindavan. A fully furnished house saw us playing cards till late nights. It witnessed several parties at Shivar. The glimpse of drunkards (me too...Just from the smell of liquor) will be always there in that house. It also witnessed Deepraj coming late from office and going early. Finally he lost his immunity and moved to London. I learnt from Deepraj that how dedicated you can be towards your work and remember work is worship.
Super six kept the momentum going. We played like anything let it be cricket, football or badminton. The intellectual discussions when Pranab was around were also a major highlight. But unfortunately he had to undergo a surgery and he had to leave the game in between with a hope if he can ever come back. I gained enormous intellectual and philosophical thoughts from Pranab.
But Funny fives were as enthusiastic as before. I and Niks always dream..”we will purchase this plot of land and 4 houses of four friends in each corner. And in center a glass house where we will be playing cards. Our wives would be frying snacks for us and all our funny dreams”.
Movies on weekends with Bookeazy were a major highlight of this period. Cricket in daytime and Dumsarraz in nights was a big time pass. But destiny took a U turn and two of us lost their immunities, Sharma and Nikesh. One got the much desired transfer to his home and the other much more desired onsite. I learnt from Nikesh and Sharma how to balance your work and personal life and exceed in them.
With the entry of Vikas Borse, the game moved on but not with the same energy. Weekends had become dull. I got engaged myself more in out of house affairs. Abhishek started coming late. Borse was as usual busy in his own world. I could understand the plight of Vasu.
All of a sudden three of us lost their immunities. Everyone doing what is best for him and automatically I become the winner of this Roadies, me all Immune. I learnt from Vasu,Abhi and Borse how honest one could be to his dreams.
I saw people coming and going. I learnt various things from each and every individual. Although this family no longer exists but I would say the memories will last long. I wave every one and wish them luck in their future endeavors. I am all alone now but now more stronger from inside,more philosphical and offcourse a better person...
Hopefully the dream of me and Niks will come true some day…..Aameen.
Every year thousands of trainees come to Mysore, The Institution. I never knew that this place will lay a foundation of friendship which will go so far. Six strangers each with their own qualities were the part of one of the huge batches ever. The journey started in bunch of two’s Vasu and Gadoo, me and Deep, Sharma and Jaychi. Most probably I was the common link. The Hell down under was over and we all moved to Hyderabad, our next destination. Then I can never forget future plans of Gadoo to set up a own s/w firm where he projected himself and me as manager. Jaychi, Vasu and Deep will be the coding experts. And Sharma will bring tea for everyone .We always used to pull his leg. He was our favorite.
A major vote out and Gadoo, me and deep were thrown out of the Hostel but we were still in game. Niks entered with a wild card entry. On weekend’s parties at our flat and late night playing cards was the weekly routine. The gelling between me Deep and Gadoo was like sugar in a juice. The Compre heat was on and sun was at its peak but we always remained comfortable in each other’s company. And Remember the competition was on between me and Gadoo for the number of pranks we did. And believe me this was the sanjivani which always brought smile on our faces even in the gloomier moments. Whenever In my life I will think of those moments it will make my heart lighter and fill with joy. But every joy has to come to an end and it was again a time for the opt out.
One has to go and Gadoo opted himself out due to some of his other higher priorities. We were still super six but we always missed him. I learnt from Gadoo that how to get things done even in struggle time.
Then the next destination was Pune. Super six got engaged in their work, trying hard to lose their immunity. I witnessed two more wild entries Abhi and Pranab and we become entertaining Eight.
The highlights of Lilly for me will be definitely the cricket inside the house and the night we spent on the Water tank over the terrace watching the girl in next building. Of course the bike of Jaychi added an attraction to our house. But this just lasted for very brief as one more Opt out and he opted to go back to his home city. I learnt from Jaychi that how a person can be so down to earth even after getting such a genius mind.
We were sensational seven left and got shifted to a new place Vrindavan. A fully furnished house saw us playing cards till late nights. It witnessed several parties at Shivar. The glimpse of drunkards (me too...Just from the smell of liquor) will be always there in that house. It also witnessed Deepraj coming late from office and going early. Finally he lost his immunity and moved to London. I learnt from Deepraj that how dedicated you can be towards your work and remember work is worship.
Super six kept the momentum going. We played like anything let it be cricket, football or badminton. The intellectual discussions when Pranab was around were also a major highlight. But unfortunately he had to undergo a surgery and he had to leave the game in between with a hope if he can ever come back. I gained enormous intellectual and philosophical thoughts from Pranab.
But Funny fives were as enthusiastic as before. I and Niks always dream..”we will purchase this plot of land and 4 houses of four friends in each corner. And in center a glass house where we will be playing cards. Our wives would be frying snacks for us and all our funny dreams”.
Movies on weekends with Bookeazy were a major highlight of this period. Cricket in daytime and Dumsarraz in nights was a big time pass. But destiny took a U turn and two of us lost their immunities, Sharma and Nikesh. One got the much desired transfer to his home and the other much more desired onsite. I learnt from Nikesh and Sharma how to balance your work and personal life and exceed in them.
With the entry of Vikas Borse, the game moved on but not with the same energy. Weekends had become dull. I got engaged myself more in out of house affairs. Abhishek started coming late. Borse was as usual busy in his own world. I could understand the plight of Vasu.
All of a sudden three of us lost their immunities. Everyone doing what is best for him and automatically I become the winner of this Roadies, me all Immune. I learnt from Vasu,Abhi and Borse how honest one could be to his dreams.
I saw people coming and going. I learnt various things from each and every individual. Although this family no longer exists but I would say the memories will last long. I wave every one and wish them luck in their future endeavors. I am all alone now but now more stronger from inside,more philosphical and offcourse a better person...
Hopefully the dream of me and Niks will come true some day…..Aameen.
Is Love Lethal?????????
Is Love Lethal?????????
I have heard people saying "Love is lethal", Love hurts and blah blah....... but it’s said all over the world that...God lies in love. Love is the most beautiful thing ever happened to us. So how can the most beautiful thing in world be lethal? How can it hurt someone?
I often become clueless. Then I found out something which made me realize...it’s not the love which is painful...but the feelings which supersede it are painful...
Love is as sweet as it is always....
Love to me should be unconditional. It should be free from all the selfishness except the one of finding his\her happiness in her\his happiness. I had seen such a love in their eyes for each other but they were emotional fools as they call themselves mere friends. As for me they were clearly made for each other.
I don’t know how they met but what I know is it was all destined.
Brendon Circle: A circle across which thousands of working professionals cross every day, below the hoarding of the MTV Roadies you could easily see a guy of 22 with a guitar in hands. Always busy in trying a new tune, he never even looks at the Guitar case kept for the collection of alms. But I often feel refreshing whenever I pass by that. I don’t know the reason but may be my lost love for music is the one which I killed in search of a living when I came out of my college. And this software industry buried it forever. So I see myself in him when I was of his age. He is striving hard to keep his dreams alive. I must say Human’s best asset is not that he can read write or think but is that he can dream and make it real.
And there she is Kunjal selling roses in the traffic. She is more beautiful than the roses in her hands. And her tinkling eyes convince you to buy one for your girlfriend. She does this every day before going to college not for living but for the company she gets of Himen even for a minute. Moreover she loves flowers. Her dream is to open a florist shop.
At the end of the day they go for a long walk. They discuss their dreams. They simply complement each other. But they were unknown to the love they have developed for each other. Days passed on.
One day as usual she was selling the roses. A descent personality Mr. Vikings what he calls himself came to her and offered her to buy all the roses since there was a function in his office. But for this she needs to join him till his office since alone he couldn’t handle all the flowers. But she refused politely. He insisted but she was rigid. He left the place wondering but he couldn’t help himself investigating the matter and he got to know the truth. It increased respect for the girl in his heart. One day he offered her to drop her to her college. On the way she told him everything about Himen. How great singer he is and what his inspirations are. She told him that he is her best friend and her happiness lies in his.
That person was no less. He instantly gave her idea to what she had to agree. He told her that he knows many of the corporate organizational heads. He can take permission from them and they can allow Himen to perform once in a month in their company premises. This will give him a platform to prove himself. She was very excited to hear it. She told Himen everything and convinced him.
Meanwhile she came closer to Mr. Vikings while Himen was practicing hard. He started his singing career from Pune from one company to another. He has become quite popular in corporate arena and was getting offers from other cities as well but he declined to all. Kunjal was finding herself at cloud nine. Again days passed on. One day Kunjal told Himen that she is getting married to Mr. Vikings this month 25th. He said he is quite happy for her and will cancel his entire schedule for that week. But very next morning he left for Hyderabad and had no contact with them.
The marriage day arrived. They got happily married. When they entered in the house they saw a gift lying there. She unwrapped it and was aghast to find an authority letter of a florist shop. It was on her name. It was from him. She cried “He must have spent all his earnings to buy that”. There was a piece of paper on which it was scribbled “ This is for you my eternal love…you were my inspiration for singing…I have left singing and now I sell roses in Bangalore streets…”.
She fell over from the stairs. Mr. Vikings took her to hospital but all in vain…she was dead…..but her memories are still with him…that piece of paper is still with him…He left his corporate job and continued the florist work……
“Excuse me…What is the price of this bouquet, sir?”…One man asked………….
It startled me of my dream. “Sorry”…I apologized…
“What is the price of this bouquet, sir?”…The man repeated………….
“Oh It is for Rs 250 only”…I replied. I sold that bouquet, closed the shop and left for my house with a heavy heart.
I have heard people saying "Love is lethal", Love hurts and blah blah....... but it’s said all over the world that...God lies in love. Love is the most beautiful thing ever happened to us. So how can the most beautiful thing in world be lethal? How can it hurt someone?
I often become clueless. Then I found out something which made me realize...it’s not the love which is painful...but the feelings which supersede it are painful...
Love is as sweet as it is always....
Love to me should be unconditional. It should be free from all the selfishness except the one of finding his\her happiness in her\his happiness. I had seen such a love in their eyes for each other but they were emotional fools as they call themselves mere friends. As for me they were clearly made for each other.
I don’t know how they met but what I know is it was all destined.
Brendon Circle: A circle across which thousands of working professionals cross every day, below the hoarding of the MTV Roadies you could easily see a guy of 22 with a guitar in hands. Always busy in trying a new tune, he never even looks at the Guitar case kept for the collection of alms. But I often feel refreshing whenever I pass by that. I don’t know the reason but may be my lost love for music is the one which I killed in search of a living when I came out of my college. And this software industry buried it forever. So I see myself in him when I was of his age. He is striving hard to keep his dreams alive. I must say Human’s best asset is not that he can read write or think but is that he can dream and make it real.
And there she is Kunjal selling roses in the traffic. She is more beautiful than the roses in her hands. And her tinkling eyes convince you to buy one for your girlfriend. She does this every day before going to college not for living but for the company she gets of Himen even for a minute. Moreover she loves flowers. Her dream is to open a florist shop.
At the end of the day they go for a long walk. They discuss their dreams. They simply complement each other. But they were unknown to the love they have developed for each other. Days passed on.
One day as usual she was selling the roses. A descent personality Mr. Vikings what he calls himself came to her and offered her to buy all the roses since there was a function in his office. But for this she needs to join him till his office since alone he couldn’t handle all the flowers. But she refused politely. He insisted but she was rigid. He left the place wondering but he couldn’t help himself investigating the matter and he got to know the truth. It increased respect for the girl in his heart. One day he offered her to drop her to her college. On the way she told him everything about Himen. How great singer he is and what his inspirations are. She told him that he is her best friend and her happiness lies in his.
That person was no less. He instantly gave her idea to what she had to agree. He told her that he knows many of the corporate organizational heads. He can take permission from them and they can allow Himen to perform once in a month in their company premises. This will give him a platform to prove himself. She was very excited to hear it. She told Himen everything and convinced him.
Meanwhile she came closer to Mr. Vikings while Himen was practicing hard. He started his singing career from Pune from one company to another. He has become quite popular in corporate arena and was getting offers from other cities as well but he declined to all. Kunjal was finding herself at cloud nine. Again days passed on. One day Kunjal told Himen that she is getting married to Mr. Vikings this month 25th. He said he is quite happy for her and will cancel his entire schedule for that week. But very next morning he left for Hyderabad and had no contact with them.
The marriage day arrived. They got happily married. When they entered in the house they saw a gift lying there. She unwrapped it and was aghast to find an authority letter of a florist shop. It was on her name. It was from him. She cried “He must have spent all his earnings to buy that”. There was a piece of paper on which it was scribbled “ This is for you my eternal love…you were my inspiration for singing…I have left singing and now I sell roses in Bangalore streets…”.
She fell over from the stairs. Mr. Vikings took her to hospital but all in vain…she was dead…..but her memories are still with him…that piece of paper is still with him…He left his corporate job and continued the florist work……
“Excuse me…What is the price of this bouquet, sir?”…One man asked………….
It startled me of my dream. “Sorry”…I apologized…
“What is the price of this bouquet, sir?”…The man repeated………….
“Oh It is for Rs 250 only”…I replied. I sold that bouquet, closed the shop and left for my house with a heavy heart.
Friday, July 31, 2009
A battle of Ego...Triumphed...
To become an engineer was never my dream and that too an electronics engineer was all a chance. I was adventurous since my childhood and I always considered myself as a tough guy. I always wanted to join Indian Army not because it would be the best way to serve the nation but also I could serve my inner soul. I appeared twice for the NDA exams but couldn’t make it and had to go by my dad’s wish to join an engineering college.
And as there was no self will, it got reflected into the first semester results. Nikhil, the guy who topped the charts was a son of an Army officer. I always tried to make friendship with him but myself being a defaulter and Nikhil little arrogant, it took some time. As some time passed I told him about my past dreams of joining Army. He jeered “How people who cannot even clear their papers can have so high dreams”. I was hurt and that even to the core. I didn’t say a word but moved from there.
Again by chance I got a point to prove myself. From second year of engineering we both were in different branches he in civil and me in Electronics. So there was no direct competition. Moreover I couldn’t ever overtake Nikhil as far as academics were concerned. Also in sports, Nikhil was always one step ahead.
But I never lost hope and kept myself going. In third year of engineering Indian Army came to college for placements under university entry scheme. Both of us appeared for it and got short listed for SSB. The date and venue was to be sent to us in due course by mail. I had to leave for my home town due to some critical problem in my house. I requested Nikhil to call me up soon he gets the SSB dates. On Sunday when I was returning for the college, I received the call from Nikhil. He said that he has reached Bangalore for the SSB which will start today. I got wrenched and couldn’t speak after that. All the hopes and desire to join Indian army went into trash.
In a week time, even Nikhil came back with empty hands. Days passed on and next year again Indian army came for the placements. Nikhil again appeared for it and this time he made it. I was too placed into DRDO. College got over and we moved on in our respective lives. In six months time my college mates decided for a get together. After such a long time we saw each other. I was feeling bit inferior since every one was giving all attention to him. At last the function got ever and I moved to the Railway station with my luggage. I saw him coming from the front smiling at me. Two Jawans were holding his luggage. For the first time I realized the royalty of an Army Officer. We departed for our respective destinations but the pain was there in my heart.
In DRDO I was involved in making an apparatus capable of sensing activities even happening at 5 Km range. And in the mean time War broke up with neighboring country. I was asked to visit the war place and demonstrate this to our army men. I was more than delighted to get this opportunity. When I reached there I found Nikhil in the troops who were to be trained. My demonstration gave them faith that they can win. In the battle field we showed lot of grit and resilience and finally we won. But we lost several of our Jawans including Nikhil. I saw 4 Jawans carrying his dead body. My eyes filled with the tears and my heart with respect for him. For the first time I realized the glory of an Army personnel. I felt proud to call myself his friend.
When I returned back, I had to fill the details of the work I carried out. I got stuck with a column “source of inspiration in the Warfield”. I wrote “Late Capt Nikhil”.
And as there was no self will, it got reflected into the first semester results. Nikhil, the guy who topped the charts was a son of an Army officer. I always tried to make friendship with him but myself being a defaulter and Nikhil little arrogant, it took some time. As some time passed I told him about my past dreams of joining Army. He jeered “How people who cannot even clear their papers can have so high dreams”. I was hurt and that even to the core. I didn’t say a word but moved from there.
Again by chance I got a point to prove myself. From second year of engineering we both were in different branches he in civil and me in Electronics. So there was no direct competition. Moreover I couldn’t ever overtake Nikhil as far as academics were concerned. Also in sports, Nikhil was always one step ahead.
But I never lost hope and kept myself going. In third year of engineering Indian Army came to college for placements under university entry scheme. Both of us appeared for it and got short listed for SSB. The date and venue was to be sent to us in due course by mail. I had to leave for my home town due to some critical problem in my house. I requested Nikhil to call me up soon he gets the SSB dates. On Sunday when I was returning for the college, I received the call from Nikhil. He said that he has reached Bangalore for the SSB which will start today. I got wrenched and couldn’t speak after that. All the hopes and desire to join Indian army went into trash.
In a week time, even Nikhil came back with empty hands. Days passed on and next year again Indian army came for the placements. Nikhil again appeared for it and this time he made it. I was too placed into DRDO. College got over and we moved on in our respective lives. In six months time my college mates decided for a get together. After such a long time we saw each other. I was feeling bit inferior since every one was giving all attention to him. At last the function got ever and I moved to the Railway station with my luggage. I saw him coming from the front smiling at me. Two Jawans were holding his luggage. For the first time I realized the royalty of an Army Officer. We departed for our respective destinations but the pain was there in my heart.
In DRDO I was involved in making an apparatus capable of sensing activities even happening at 5 Km range. And in the mean time War broke up with neighboring country. I was asked to visit the war place and demonstrate this to our army men. I was more than delighted to get this opportunity. When I reached there I found Nikhil in the troops who were to be trained. My demonstration gave them faith that they can win. In the battle field we showed lot of grit and resilience and finally we won. But we lost several of our Jawans including Nikhil. I saw 4 Jawans carrying his dead body. My eyes filled with the tears and my heart with respect for him. For the first time I realized the glory of an Army personnel. I felt proud to call myself his friend.
When I returned back, I had to fill the details of the work I carried out. I got stuck with a column “source of inspiration in the Warfield”. I wrote “Late Capt Nikhil”.
Wednesday, July 29, 2009
SSIS Funda’s ……………………
Objective : Extraction of data, Transformation and insertion.
Control Flow: Roughly we can call it as a work flow.
Data Flows are the modules which does a series of operation to achieve a desired result.
SSIS 2005 provides three different types of control flow elements
1. Containers: Provide structures in packages.
2. Tasks: provides functionality.
3. Precedence constraint: it connects the executables, containers and tasks into an ordered flow.
First of all the package control flow must include a data flow task then only we can add a data flow to a package. For each Data flow task in package a separate instance of the data flow engine is invoked.
ERROR Handling in SSIS:
Typically three sort of errors can happen in SSIS viz. Data conversion errors, Expression evaluation errors or Look up Errors.
In the transformation editor, we can click configure Error Output to get the configure error o/p wizard.
There are three options:
1) Ignore Failure
2) Redirect Row
3) Fail Component
Other than these we have event handlers where we can execute some task or run scripts or do anything we want in case of error occurred or after execution of some block.
LOGGING in SSIS:
We can write log entries to text files, SQL Server profiler, Windows event log or xml files. Logs are associated with the packages and are configured at the package level. Each task or container in a package can log information into any package log. To enable logging in a package:
1. Open the integration services in BIDS.
2. On the SSIS menu click logging.
3. Select a log provider in the provider type list and then click ADD.
Deployment of SSIS packages:
SSIS supports the deployment of packages through the use of the package configurations and the ability to easily deploy packages using the package deployment utility.
1. Build the integration services project to create a package deployment utility.
2. Now run the package installer wizard to install the package.
VARIABLES: variables store values that a SSIS package and its contains, tasks and event handlers can use at run time.
SSIS provides a checkpoint facility which allows a package to restart at the point of failure.
SSIS connection managers:
1. OLE DB Connection.
2. Flat file connection.
3. ADO.Net connection
4. Analysis service connection.
Difference between DTS and SSIS:
1. No Deployment wizard in DTS.
2. Limited set of transformations in DTS.
3. No BI functionality in DTS.
4. Dynamic properties + ActiveX scripts in DTS, Configuration + Property Expression in SSIS
5. Message Boxes in active scripts, Message Boxes in script tasks.
Merge transformation can accept only two inputs where as Union ALL can take more than two inputs.
Data has to be sorted before merge transformation where as UNION ALL doesn’t have any such condition.
Control Flow: Roughly we can call it as a work flow.
Data Flows are the modules which does a series of operation to achieve a desired result.
SSIS 2005 provides three different types of control flow elements
1. Containers: Provide structures in packages.
2. Tasks: provides functionality.
3. Precedence constraint: it connects the executables, containers and tasks into an ordered flow.
First of all the package control flow must include a data flow task then only we can add a data flow to a package. For each Data flow task in package a separate instance of the data flow engine is invoked.
ERROR Handling in SSIS:
Typically three sort of errors can happen in SSIS viz. Data conversion errors, Expression evaluation errors or Look up Errors.
In the transformation editor, we can click configure Error Output to get the configure error o/p wizard.
There are three options:
1) Ignore Failure
2) Redirect Row
3) Fail Component
Other than these we have event handlers where we can execute some task or run scripts or do anything we want in case of error occurred or after execution of some block.
LOGGING in SSIS:
We can write log entries to text files, SQL Server profiler, Windows event log or xml files. Logs are associated with the packages and are configured at the package level. Each task or container in a package can log information into any package log. To enable logging in a package:
1. Open the integration services in BIDS.
2. On the SSIS menu click logging.
3. Select a log provider in the provider type list and then click ADD.
Deployment of SSIS packages:
SSIS supports the deployment of packages through the use of the package configurations and the ability to easily deploy packages using the package deployment utility.
1. Build the integration services project to create a package deployment utility.
2. Now run the package installer wizard to install the package.
VARIABLES: variables store values that a SSIS package and its contains, tasks and event handlers can use at run time.
SSIS provides a checkpoint facility which allows a package to restart at the point of failure.
SSIS connection managers:
1. OLE DB Connection.
2. Flat file connection.
3. ADO.Net connection
4. Analysis service connection.
Difference between DTS and SSIS:
1. No Deployment wizard in DTS.
2. Limited set of transformations in DTS.
3. No BI functionality in DTS.
4. Dynamic properties + ActiveX scripts in DTS, Configuration + Property Expression in SSIS
5. Message Boxes in active scripts, Message Boxes in script tasks.
Merge transformation can accept only two inputs where as Union ALL can take more than two inputs.
Data has to be sorted before merge transformation where as UNION ALL doesn’t have any such condition.
Monday, July 27, 2009
SQL Server Fundas…………….by Vikash kumar
1. Database Management System: Store --> Manage --> Retrieve (to persist information)
2. Difference between DBMS and RDBMS: RDBMS = DBMS + Referential integrity.
3. Difference between SQl Server 2000 and SQL Server 2005:
a. User defined functions or triggers can be written using any .Net language. (TSQL in 2000)
b. Reporting Services.
c. New data types.
d. Stored Procedure invocation is enabled using the SOAP protocol.
e. Data partitioning feature
f. SQL Server 2000 can have maximum of 16 instances where as SQL 2005 can have up to 50 instances.
g. SQL query analyzer has been integrated.
4. Entity Diagrams shows the relationship between the tables.
5. SQL Server stores data in
a. .MDF file (physical database file where data is finally stored.)
b. .LDF file (Log files are actually data which is recorded from the last time data was committed in DB)
6. ON DELETE Restrict: Should not allow to drop tables if dependency is there. ON DELETE Cascade: should delete the dependency first and then delete the table.
7. Types of Joins:
a. Inner Join: only matches present in both tables. Most commonly used.
b. Left outer join: All records of Left table
c. Right outer Join: All records of right table
d. Cross Join : Cartesian product
e. Self join : Join between two instances of same table.
8. Difference between DELETE and TRUNCATE
a. Truncate is faster.
b. Truncate table cannot trigger.
c. DELETE table can have criteria while TRUNCATE cannot.
d. DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.
9. Difference between UNION and UNION ALL
a. Union gives distinct records from both the tables but UNION ALL gives all the records.
10. Significance of SET ROW COUNT is that it limits the number of rows returned.
11. Exception Handling in SQL:
a. Use TRY Catch block.
b. Can designate ERROR_NUMBER, ERROR_Severity, ERROR_State, ERROR_MESSAGE, SET ERROR.
c. The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement custom error messages in your applications.
12. Types of Triggers:
a. Instead of
b. After trigger
Differences between the two:
INSTEAD OF triggers gets executed automatically before the Primary Key and the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked. Unlike AFTER triggers, INSTEAD OF triggers can be created on views.
13. To define the sequence of the triggers on a table if more than one trigger exist on that table then use the system stored procedure sp_settriggerorder.
14. Difference between Data Set and Data Reader:
a. Data reader provides forward only and ready only access to data while dataset can hold more than a table.
b. Dataset persists the content but Data reader not.
15. Methods provided by the dataset for XML:
a. Read XML
b. Get XML
c. Write XML
16. For XML clause in SQL server returns data in XML rather than simple rows and columns.
17. To generate schema of a table: Select * from mytable For XML AUTO, XMLSCHEMA
18. OPEN XML is vice versa of FOR XML AUTO. When XML is passed it returns rows and column.
19. XMLA: XML for analysis is fundamentally based on web services and SOAP. MS SQL 2005 analysis services use XMLA to handle all client application communication for analysis services. XMLA is a SOAP based XML protocol designed specifically for universal data access to any standard multi dimensional data source residing on the web.
20. Normalization: Suppose there are few tables having relationships between them. So while designing these tables we need to follow some set of rules to connect these tables. These set of rules are called normalization.
Advantages of Normalization:
a. Avoid redundancy i.e. repetitive entries.
b. Reducing required storage space.
c. Preventing the need to restructure existing tables to accommodate new data.
d. Increased speed and flexibility of queries, sorts, and summaries.
First Normal Form For a table to be in first normal form, data must be broken up into the smallest units possible. In addition to breaking data up into the smallest meaningful values, tables in first normal form should not contain repetitions groups of fields. In a table if there are two columns city1,city2 and customer name. To make it in first normal form we should break the Customer name into two columns First Name and Last Name. Moreover the repetitive columns like city1, city2 should be merged as City.
Second Normal form The second normal form states that each field in a multiple field primary key table must be directly related to the entire primary key. So If we will shift City to a different master table then our database is said to be in Second Normal Form.
Third normal form A non-key field should not depend on other Non-key field. The field "Total" is dependent on "Unit price" and "qty". Suppose our table contains three fields Unit price, Qty and Total. Total can be calculated by multiplication of Unit price * Qty. So we can remove the Total field from the table. This will bring our table in Third normal form.
21. Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance. The sacrifice to performance is that you increase redundancy in database.
22. Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
23. How can we increase SQL performance
Following are tips which will increase your SQl performance :-
a. Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes may be increased.
b. Keep your indexes as narrow as possible. This reduces the size of the index and reduces the number of reads required to read the index.
c. Try to create indexes on columns that have integer values rather than character values.
d. If you create a composite (multi-column) index, the order of the columns in the key are very important. Try to order the columns in the key as to enhance selectivity, with the most selective columns to the left most of the key.
e. If you want to join several tables, try to create surrogate integer keys for this purpose and create indexes on their columns.
f. Create surrogate integer primary key (identity for example) if your table will not have many insert operations.
g. Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.
h. If your application will be performing the same query over and over on the same table, consider creating a covering index on the table.
i. You can use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries instead of using an index.
24. Following are the problems that occur if we do not implement locking properly in SQL SERVER.
a. Lost Updates: This happens due to most likely to occur with the READ UNCOMMITTED isolation level. Due to this we lose the first transaction if two transaction happens over the same data simultaneously.
b. Non-Repeatable Read: Non-repeatable reads occur if a transaction is able to read the same row multiple times and gets a different value each time.
c. Dirty Reads: Dirty reads are a special case of non-repeatable read. This happens if we run a report while transactions are modifying the data that we're reporting on.
d. Phantom Reads: Phantom reads occur due to a transaction being able to read a row on the first read, but not being able to modify the same row due to another transaction deleting rows from the same table.
25. Transaction Isolation level decides how is one process isolated from other process. Using transaction levels we can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER :
a. READ COMMITTED: The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time.
b. READ UNCOMMITTED: No shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.
c. REPEATABLE READ: This setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.
d. SERIALIZABLE: This is the most restrictive setting holding shared locks on the range of data. This setting does not allow the insertion of new rows in the range that is locked; therefore, no phantoms are allowed. Following is the syntax for setting transaction level in SQL SERVER. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
26. Depending on the transaction level six types of lock can be acquired on data :
a. Intent: Intent locks come in three flavors: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX). IS locks indicate that the transaction will read some (but not all) resources in the table or page by placing shared locks. IX locks indicate that the transaction will modify some (but not all) resources in the table or page by placing exclusive locks. SIX locks indicates that the transaction will read all resources, and modify some(but not all) of them. This will be accomplished by placing the shared locks on the resources read and exclusive locks on the rows modified. Only one SIX lock is allowed per resource at one time; therefore, SIX locks prevent other connections from modifying any data in the resource (page or table), although they do allow reading the data in the same resource.
b. Shared locks (S) allow transactions to read data with SELECT statements. Other connections are allowed to read the data at the same time; however, no transactions are allowed to modify data until the shared locks are released.
c. Update locks (U) are acquired just prior to modifying the data. If a transaction modifies a row, then the update lock is escalated to an exclusive lock; otherwise, it is converted to a shared lock. Only one transaction can acquire update locks to a resource at one time. Using update locks prevents multiple connections from having a shared lock that want to eventually modify a resource using an exclusive lock. Shared locks are compatible with other shared locks, but are not compatible with Update locks.
d. Exclusive locks (X) completely lock the resource from any type of access including reads. They are issued when data is being modified through INSERT, UPDATE and DELETE statements.
e. Schema modification locks (Sch-M) are acquired when data definition language statements, such as CREATE TABLE, CREATE INDEX, ALTER TABLE, and so on are being executed. Schema stability locks (Sch-S) are acquired when store procedures are being compiled.
f. Bulk update locks (BU) are used when performing a bulk-copy of data into a table with TABLOCK hint. These locks improve performance while bulk copying data into a table; however, they reduce concurrency by effectively disabling any other connections to read or modify data in the table.
27. Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.
28. Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber.
a. Publisher: Database server that makes data available for replication is called as Publisher.
b. Subscriber: Database Servers that get data from the publishers is called as Subscribers.
There are three types of replication supported by SQL SERVER.
a. Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The only disadvantage of this type of replication is that all data has to be copied each time the table is refreshed.
b. Transactional Replication In transactional replication data is copied first time as in snapshot replication, but later only the transactions are synchronized rather than replicating the whole database. We can either specify to run continuously or on periodic basis.
c. Merge Replication. Merge replication combines data from multiple sources into a single central database. Again as usual the initial load is like snapshot but later it allows change of data both on subscriber and publisher, later when they come on-line it detects and combines them and updates accordingly.
29. User defined Functions:
User defined functions are TSQL routines used to encapsulate the programming logic.
Types of UDF:
1. Scalar: Returns a single value of a scalar data type. Cannot return text, timestamp or image.
Things we cannot do:
a. Insert/Update/Delete
b. Execute SP’s
c. Error Handling
d. Print
2. Inline: Return tables equivalent to views with parameters.
Insert\update \Delete are possible.
3. Multi statement: Tables can be returned.
Following are some major differences between a stored procedure and user defined functions:
a. Stored procedures are called independently, using the EXEC command, while functions need to be called from within another SQL statement.
b. Stored procedure allow you to enhance application security by granting users and applications permission to use stored procedures, rather than permission to access the underlying tables. Stored procedures provide the ability to restrict user actions at a much more granular level than standard SQL Server permissions.
c. UDF cannot be used in XML FOR clause but SP’s can be used.
d. Functions must always return a value (either a scalar value or a table). Stored procedures may return a scalar value, a table value or nothing at all.
e. If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
f. UDF cannot make permanent changes to server environments while SP’s can change some of the server environment.
g. UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
30. Performance Tuning SQL Server Cursors:
If possible, we should avoid using SQL Server cursors. They generally use a lot of SQL Server resources and reduce the performance and scalability of our applications. If we need to perform row-by-row operations here are some alternatives:
• Use WHILE LOOPS
• Use temp tables
• Use derived tables
• Use correlated sub-queries
• Use the CASE statement
• Perform multiple queries
1. If we have to use a cursor, we should try to reduce the number of records to process by using temp table. The lower the number of records to process, the faster the cursor will finish.
2. If the number of rows you need to return from a query is small, and we need to perform row-by-row operations on them, don't use a server-side cursor. Instead, consider returning the entire rowset to the client and have the client perform the necessary action on each row, then return any updated rows to the server
3. If we have no choice but to use a server-side cursor in our application, we should try to use a FORWARD-ONLY or FAST-FORWARD, READ-ONLY cursor. Also we should try to locate the SQL Server tempdb database on its own physical device for best performance. This is because cursors use the tempdb for temporary storage of cursor data. The faster your disk array running tempdb, the faster our cursor will be.
4. If we need to perform a JOIN as part of our cursor, keyset and static cursors are generally faster than dynamic cursors, and should be used when possible.
31. To get all the row values concatenated.
Declare @colors varchar(250)
Select @colors = COALESCE(@colors + '/','') + CompanyName from dbo.Company
print @colors
2. Difference between DBMS and RDBMS: RDBMS = DBMS + Referential integrity.
3. Difference between SQl Server 2000 and SQL Server 2005:
a. User defined functions or triggers can be written using any .Net language. (TSQL in 2000)
b. Reporting Services.
c. New data types.
d. Stored Procedure invocation is enabled using the SOAP protocol.
e. Data partitioning feature
f. SQL Server 2000 can have maximum of 16 instances where as SQL 2005 can have up to 50 instances.
g. SQL query analyzer has been integrated.
4. Entity Diagrams shows the relationship between the tables.
5. SQL Server stores data in
a. .MDF file (physical database file where data is finally stored.)
b. .LDF file (Log files are actually data which is recorded from the last time data was committed in DB)
6. ON DELETE Restrict: Should not allow to drop tables if dependency is there. ON DELETE Cascade: should delete the dependency first and then delete the table.
7. Types of Joins:
a. Inner Join: only matches present in both tables. Most commonly used.
b. Left outer join: All records of Left table
c. Right outer Join: All records of right table
d. Cross Join : Cartesian product
e. Self join : Join between two instances of same table.
8. Difference between DELETE and TRUNCATE
a. Truncate is faster.
b. Truncate table cannot trigger.
c. DELETE table can have criteria while TRUNCATE cannot.
d. DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.
9. Difference between UNION and UNION ALL
a. Union gives distinct records from both the tables but UNION ALL gives all the records.
10. Significance of SET ROW COUNT is that it limits the number of rows returned.
11. Exception Handling in SQL:
a. Use TRY Catch block.
b. Can designate ERROR_NUMBER, ERROR_Severity, ERROR_State, ERROR_MESSAGE, SET ERROR.
c. The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement custom error messages in your applications.
12. Types of Triggers:
a. Instead of
b. After trigger
Differences between the two:
INSTEAD OF triggers gets executed automatically before the Primary Key and the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked. Unlike AFTER triggers, INSTEAD OF triggers can be created on views.
13. To define the sequence of the triggers on a table if more than one trigger exist on that table then use the system stored procedure sp_settriggerorder.
14. Difference between Data Set and Data Reader:
a. Data reader provides forward only and ready only access to data while dataset can hold more than a table.
b. Dataset persists the content but Data reader not.
15. Methods provided by the dataset for XML:
a. Read XML
b. Get XML
c. Write XML
16. For XML clause in SQL server returns data in XML rather than simple rows and columns.
17. To generate schema of a table: Select * from mytable For XML AUTO, XMLSCHEMA
18. OPEN XML is vice versa of FOR XML AUTO. When XML is passed it returns rows and column.
19. XMLA: XML for analysis is fundamentally based on web services and SOAP. MS SQL 2005 analysis services use XMLA to handle all client application communication for analysis services. XMLA is a SOAP based XML protocol designed specifically for universal data access to any standard multi dimensional data source residing on the web.
20. Normalization: Suppose there are few tables having relationships between them. So while designing these tables we need to follow some set of rules to connect these tables. These set of rules are called normalization.
Advantages of Normalization:
a. Avoid redundancy i.e. repetitive entries.
b. Reducing required storage space.
c. Preventing the need to restructure existing tables to accommodate new data.
d. Increased speed and flexibility of queries, sorts, and summaries.
First Normal Form For a table to be in first normal form, data must be broken up into the smallest units possible. In addition to breaking data up into the smallest meaningful values, tables in first normal form should not contain repetitions groups of fields. In a table if there are two columns city1,city2 and customer name. To make it in first normal form we should break the Customer name into two columns First Name and Last Name. Moreover the repetitive columns like city1, city2 should be merged as City.
Second Normal form The second normal form states that each field in a multiple field primary key table must be directly related to the entire primary key. So If we will shift City to a different master table then our database is said to be in Second Normal Form.
Third normal form A non-key field should not depend on other Non-key field. The field "Total" is dependent on "Unit price" and "qty". Suppose our table contains three fields Unit price, Qty and Total. Total can be calculated by multiplication of Unit price * Qty. So we can remove the Total field from the table. This will bring our table in Third normal form.
21. Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance. The sacrifice to performance is that you increase redundancy in database.
22. Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
23. How can we increase SQL performance
Following are tips which will increase your SQl performance :-
a. Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes may be increased.
b. Keep your indexes as narrow as possible. This reduces the size of the index and reduces the number of reads required to read the index.
c. Try to create indexes on columns that have integer values rather than character values.
d. If you create a composite (multi-column) index, the order of the columns in the key are very important. Try to order the columns in the key as to enhance selectivity, with the most selective columns to the left most of the key.
e. If you want to join several tables, try to create surrogate integer keys for this purpose and create indexes on their columns.
f. Create surrogate integer primary key (identity for example) if your table will not have many insert operations.
g. Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.
h. If your application will be performing the same query over and over on the same table, consider creating a covering index on the table.
i. You can use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries instead of using an index.
24. Following are the problems that occur if we do not implement locking properly in SQL SERVER.
a. Lost Updates: This happens due to most likely to occur with the READ UNCOMMITTED isolation level. Due to this we lose the first transaction if two transaction happens over the same data simultaneously.
b. Non-Repeatable Read: Non-repeatable reads occur if a transaction is able to read the same row multiple times and gets a different value each time.
c. Dirty Reads: Dirty reads are a special case of non-repeatable read. This happens if we run a report while transactions are modifying the data that we're reporting on.
d. Phantom Reads: Phantom reads occur due to a transaction being able to read a row on the first read, but not being able to modify the same row due to another transaction deleting rows from the same table.
25. Transaction Isolation level decides how is one process isolated from other process. Using transaction levels we can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER :
a. READ COMMITTED: The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time.
b. READ UNCOMMITTED: No shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.
c. REPEATABLE READ: This setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.
d. SERIALIZABLE: This is the most restrictive setting holding shared locks on the range of data. This setting does not allow the insertion of new rows in the range that is locked; therefore, no phantoms are allowed. Following is the syntax for setting transaction level in SQL SERVER. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
26. Depending on the transaction level six types of lock can be acquired on data :
a. Intent: Intent locks come in three flavors: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX). IS locks indicate that the transaction will read some (but not all) resources in the table or page by placing shared locks. IX locks indicate that the transaction will modify some (but not all) resources in the table or page by placing exclusive locks. SIX locks indicates that the transaction will read all resources, and modify some(but not all) of them. This will be accomplished by placing the shared locks on the resources read and exclusive locks on the rows modified. Only one SIX lock is allowed per resource at one time; therefore, SIX locks prevent other connections from modifying any data in the resource (page or table), although they do allow reading the data in the same resource.
b. Shared locks (S) allow transactions to read data with SELECT statements. Other connections are allowed to read the data at the same time; however, no transactions are allowed to modify data until the shared locks are released.
c. Update locks (U) are acquired just prior to modifying the data. If a transaction modifies a row, then the update lock is escalated to an exclusive lock; otherwise, it is converted to a shared lock. Only one transaction can acquire update locks to a resource at one time. Using update locks prevents multiple connections from having a shared lock that want to eventually modify a resource using an exclusive lock. Shared locks are compatible with other shared locks, but are not compatible with Update locks.
d. Exclusive locks (X) completely lock the resource from any type of access including reads. They are issued when data is being modified through INSERT, UPDATE and DELETE statements.
e. Schema modification locks (Sch-M) are acquired when data definition language statements, such as CREATE TABLE, CREATE INDEX, ALTER TABLE, and so on are being executed. Schema stability locks (Sch-S) are acquired when store procedures are being compiled.
f. Bulk update locks (BU) are used when performing a bulk-copy of data into a table with TABLOCK hint. These locks improve performance while bulk copying data into a table; however, they reduce concurrency by effectively disabling any other connections to read or modify data in the table.
27. Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.
28. Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber.
a. Publisher: Database server that makes data available for replication is called as Publisher.
b. Subscriber: Database Servers that get data from the publishers is called as Subscribers.
There are three types of replication supported by SQL SERVER.
a. Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The only disadvantage of this type of replication is that all data has to be copied each time the table is refreshed.
b. Transactional Replication In transactional replication data is copied first time as in snapshot replication, but later only the transactions are synchronized rather than replicating the whole database. We can either specify to run continuously or on periodic basis.
c. Merge Replication. Merge replication combines data from multiple sources into a single central database. Again as usual the initial load is like snapshot but later it allows change of data both on subscriber and publisher, later when they come on-line it detects and combines them and updates accordingly.
29. User defined Functions:
User defined functions are TSQL routines used to encapsulate the programming logic.
Types of UDF:
1. Scalar: Returns a single value of a scalar data type. Cannot return text, timestamp or image.
Things we cannot do:
a. Insert/Update/Delete
b. Execute SP’s
c. Error Handling
d. Print
2. Inline: Return tables equivalent to views with parameters.
Insert\update \Delete are possible.
3. Multi statement: Tables can be returned.
Following are some major differences between a stored procedure and user defined functions:
a. Stored procedures are called independently, using the EXEC command, while functions need to be called from within another SQL statement.
b. Stored procedure allow you to enhance application security by granting users and applications permission to use stored procedures, rather than permission to access the underlying tables. Stored procedures provide the ability to restrict user actions at a much more granular level than standard SQL Server permissions.
c. UDF cannot be used in XML FOR clause but SP’s can be used.
d. Functions must always return a value (either a scalar value or a table). Stored procedures may return a scalar value, a table value or nothing at all.
e. If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
f. UDF cannot make permanent changes to server environments while SP’s can change some of the server environment.
g. UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
30. Performance Tuning SQL Server Cursors:
If possible, we should avoid using SQL Server cursors. They generally use a lot of SQL Server resources and reduce the performance and scalability of our applications. If we need to perform row-by-row operations here are some alternatives:
• Use WHILE LOOPS
• Use temp tables
• Use derived tables
• Use correlated sub-queries
• Use the CASE statement
• Perform multiple queries
1. If we have to use a cursor, we should try to reduce the number of records to process by using temp table. The lower the number of records to process, the faster the cursor will finish.
2. If the number of rows you need to return from a query is small, and we need to perform row-by-row operations on them, don't use a server-side cursor. Instead, consider returning the entire rowset to the client and have the client perform the necessary action on each row, then return any updated rows to the server
3. If we have no choice but to use a server-side cursor in our application, we should try to use a FORWARD-ONLY or FAST-FORWARD, READ-ONLY cursor. Also we should try to locate the SQL Server tempdb database on its own physical device for best performance. This is because cursors use the tempdb for temporary storage of cursor data. The faster your disk array running tempdb, the faster our cursor will be.
4. If we need to perform a JOIN as part of our cursor, keyset and static cursors are generally faster than dynamic cursors, and should be used when possible.
31. To get all the row values concatenated.
Declare @colors varchar(250)
Select @colors = COALESCE(@colors + '/','') + CompanyName from dbo.Company
print @colors
BizTalk Bizzare
BizTalk Bizarre………………………………….by Vikash Kumar…………………….
1. Active property made true invokes a new instance of an orchestration. Only a nested Orchestration can be started without an active receive. BizTalk Server has no built in mechanism for controlling the number of instances of a given orchestration. If we have to control the number of instances of Orch A then we have to create some rule or Orch which will allow/restrict it to activate one more instance.
2. Static Global variables can be stored in Configuration files or SQL tables in order to share them across all the instances of the Orchestration.
3. Zombie is a message which is discarded when the instance of the Orchestration ends with “Completed with Discarded Message”. It typically occurs when an extra message is routed after control flow in the executing orchestration has passed the receive shape with the matching subscription or due to a time out on a LR transaction or a time out of a delay branch on a listen shape or in a loop that consists a receive shape that exits before consuming all the routed messages.
4. “Delivered Not Consumed” this is the status of the message when it is in the BTS internal work queue. It might be in this state because the engine is busy with other messages or because the destination is processing more slow than expected.
5. Curious case of Serialization in orchestration:
The XLANG compiler requires all its variables in an orchestration to be serializable since when the orchestration dehydrates and rehydrates then it serializes and deserializes those variables.
A non serializable object can only be declared and used in an atomic scope.
An interface cannot be marked as a serializable because we are never sure about their implementation. So Non Serializable objects must run inside atomic scopes.
6. For an Atomic Scope, if Retry is set to true only two exceptions “Persistence Exception” and “RetryTransactionExcepion” will make the atomic transaction retry work.
7. Orchestration supports parallel activation only in following conditions:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
8. Difference between Start Orchestration and Call Orchestration:
a. Call Orchestration is a synchronous call and it returns the control back to the caller.
b. Start orchestration is an Asynchronous call and hence it starts the orchestration in a non deterministic way. In this case some time what we expect that the new orchestration will start in time to create the necessary subscriptions to receive the messages that will be sent to it but quite often it doesn’t happen so. In this case it gives” could not find subscription error".
9. Persistence points in Orchestration:
The orchestration engine saves the entire state of an orchestration instance at various persistence points to allow rehydration of the orchestration instance. The engine stores state at the following persistence points:
• End of a transactional scope (atomic or long running)
• At debugging breakpoints
• At the execution of other orchestrations through the Start Orchestration shape
• At the Send shape (except in an atomic transaction)
• When an Orchestration Instance is suspended
• When the system shutdowns in a controlled manner
• When the engine determines it wants to dehydrate
• When an orchestration instance is finished
10. BizTalk Server upgrade: BizTalk 2004 and BizTalk 2006 cannot reside on the same machine and so as SQL Server 2000 and 2005. So while upgrading BTS2004 to 2006 database also needs to upgraded from 2000 to 2005.
Note: Within a single group in case of multiple BizTalk servers if one server is upgrade then all the servers need to be upgraded because interoperability between BTS2004 and BTS 2006 is not supported due because of DB changes.
11. Business Rule Engine:
a. Rule: A single executable statement which is made up of a condition and an action.
b. Policies: Logical group of rules.
c. Vocabulary: Friendly name given to a field.
How does rule engine works:
Business Rule Composer is used for developing business policies, vocabulary definitions, publish the policies. Inside the BRC when we want to test the policy for a .Net component we need to create a Fact creator wrapper around the .Net Component implementing the interface IFactCreator. Create Facts is the method called by the rule engine. Rule engine deployment wizard deploy/export/import the policies and vocabularies. Rule engine evaluates the condition based on fact. When a policy is executed, the facts are brought into memory. After execution all the facts submitted to the rule engine are retracted from the working memory of the rule engine.
Important: When we test a policy that uses database facts with the DataConnection binding in the Business Rule Composer, a DataConnection object is automatically built. However, when we call the same policy from an orchestration by using the Call Rules shape, no DataConnection object is passed to the policy automatically. We should create a DataConnection object in the orchestration and pass it as a parameter or create a fact retriever component that asserts the DataConnection object, and configure the policy to use the fact retriever component.
How to call Rules from:
a. Orchestration: We can call rules from orchestration using Call Rule shape. Also we can use .Net API inside the expression shape to call the policies.
i. Create the object of the samplepolicy we created in BRC.
Policy = new Microsoft.RuleEngine.Policy(“SamplePolicy”,1,0);
ii. Create the input parameter for the policy
typedXmlDoc = new MS.RE.TypedXmlDocument(“inputXML”,inmputmessgae);
iii. Execute the policy and then dispose.
Policy.Execute(typedXmlDoc);
Policy.dispose();
b. C# code:
Same as above. Only difference is that we need to create the facts object array to hold the input params for the policy as objects[] facts = new object[1];
Facts[0] = typedXmlDoc;
Policy.Execute(facts);
Advanced Concepts:
a. Forward chaining: One rule invokes the other rule.
b. Short term vs. long term fact:
i. Short-term facts are facts loaded into memory by rule engine and are available for only one execution cycle of the rule engine, after the execution facts are retracted back from memory. Long term facts are available for multiple execution cycles of rule engine.
ii. Short term facts are passed to rule engine as array of objects, whereas long term facts are passed as typed Data Table which has typed Data Rows to rule engine.
12. Transactions in Orchestration:
a. Atomic Transaction: Either completely successful or completely rollbacked.
i. Cannot contain nested Atomic transaction or LR transaction or a exception handler however can contain a compensation block.
ii. We cannot construct an atomic transaction with a request response pair of actions, nor we can have send and receive shape that uses the same correlation set.
iii. When a message is received in an atomic transaction, it is delivered to the orchestration but not removed from the message box until the transaction commits.
b. LR Transaction: A transaction which executes for several hours, days or even weeks and contains several atomic transactions. These smaller atomic transactions which are completed/committed, cannot be rolled back and hence need to be compensated.
COMPENSATION: Undo operation
Exception block does not roll back the transaction but just throws the error.
13. When many long-running business processes are running at the same time, memory and performance are potential issues. The orchestration engine addresses these issues by "dehydrating" and "rehydrating" orchestration instances.
Dehydration is the process of serializing the state of an orchestration into a SQL Server database. Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database. Dehydration is used to minimize the use of system resources by reducing the number of orchestrations that have to be instantiated in memory at one time.
14. Correlation is used to map a message to its corresponding Orchestration instance A correlation set is a collection of promoted message property values that we use to route an incoming message to an executing instance. The message is evaluated for the message type and every property in the set in order to correctly route it to the instance. Correlation is achieved with the help of "Initialize Correlation Set" and "Follow up Correlation Set" properties in the Send and Receive shapes.
15. Deployment: After build phase of the BizTalk project when we need to migrate the work from our work environment to test environment first we need to export the .msi files. Remenber that configuration values what we have made in BTSNTSvc.exe.config file are not exported. Patches(only added\modified file) can also be exported. Export bindings and plocies.
After exporting import the .msi and binding files in the test environment.
16. Binding Model in BizTalk:
a. Direct Binding(Most Flexible): In this Model, orchestration ports do not automatically use BTS.SPID or BTS.RecievePortId. Rather filter expressions or self correlating or message context property can be used. Can be used to send message to other orchestration. Drawback is that we cannot configure our orchestration port using binding files. We need to do more programming in order to fully exploit the flexibility.
b. Specify later: Less flexible but most common. BTS.SPID, BTS.RecieverId
c. Specify now: BizTalk collects transport and pipeline info at design time.
d. Dynamic Binding: In expressions we have to give URLs that can be picked from config file.
17. Delivery Notification in BizTalk: If an Orchestration port is marked with Delivery Notification = Transmitted, and the Send shape in the Orchestration is in a synchronized scope, the Orchestration will wait until it either receives an ACK or a NACK for the message that was transmitted. In the case that the message was successfully transmitted, the engine will publish an ACK ensuring that it is routed back to that Orchestration instance, once the Orchestration receives the ACK it will leave the scope and continue processing. If however the transmission failed and the message was suspended, the engine will publish a NACK which again will be routed back to the Orchestration instance, the Orchestration will throw a DeliveryFailureException which can of course be caught and handled as appropriate in the Orchestration.
18. Dynamic Mapping: Dynamic mapping is the concept of specifying the map to be used for a transform at runtime inside the orchestration. That means no Transform Shape is used to specify the map or input and output schemas.
Example: We are receiving a standard invoice from multiple locations for the same vendor. The schema is exactly the same but the mapping of the vendor data to the base schema (date formats, currency conversion, etc.) is slightly different based on the vendor location.
Why not map on the Receive Port? This is the most common solution to this type of scenario. This uses document normalization to transform all your messages into the same type before it hits our business process. This is a great solution but what about exceptions?
Exceptions in maps on the Receive Port can be hard to react to and even harder to orchestrate a retry or recovery process. That is when mapping inside an Orchestration and Dynamic Maps come into play.
With dynamic maps, the map name can be stored inside an attribute in the message, read from the SSO, or read from some other custom component. Then, it is as simple as creating a System.Type with the strong fully qualified map name.
This would look something like this:
Suppose SubscriberInformation is the node in input xml which contains the recipients info then we will take it in a variable.
SubscriberInformation = Generic_In(DynamicMaps.PropertySchema.SubscriberInfo );
then we will take the maptype in another variable of System.Type like this
tMap = System.Type.GetType("DynamicMaps.Map_ABC,DynamicMaps, Version=1.0.0.0, Culture=neutral,PublicKeyToken=f85be9e4dd36fb1d");
then in a message assignment shape we can construct the out message as follows:
transform (Message_Out) = tMap(Generic_In);
Alternatively we can do it in an expression shape using the construct keyword as below:
construct Message_Out
{
transform (Message_Out) = tMap(Generic_In);
}
19. BizTalk Server can accommodate two or more schema with the same root node as long as the schemas have unique namespace designations.
20. Message context includes all the instance specific and exchange specific data fields, and essentially is the metadata that the messaging engine of BizTalk Server uses to process messages. While duplicating a message it should be noted that Only MessageDataPropertyBase gets copied not the MessageContextProperty Base. So to copy the message context property of message 2 into the message context of message 1
Message1(*) = Message2(*);
21. Distinguish fields are used opposed to promoted fields to enhance the performance.
a) Distinguish fields are available only within a single orchestration and they are not available to other BizTalk Server objects such as receive locations, send ports, send port groups and tracking utilities.
b) Distinguish fields can be of any length; promoted properties have a maximum length of 255 characters.
c) Distinguished fields have less of a performance impact than promoted properties as they are not persisted to the Message Box database. Instead they are XPath aliases which simply point to the appropriate XML data field.
d) Distinguish fields are accessed in following fashion: MessageName.RecordName.Childname while Promoted fields are accessed in this way MessageName(PropertySchemaName.PromotedPropertyName)
22. To hide promoted properties from the tools like HAT and BAM, set the promoted property’s Sensitive Information property to True.
23. It is also possible to create message context properties that do not exist in the message by just adding a node to the property schema and setting its Property Schema base property to MessageContextProperty Base.
24. To process a message that contains multiple records in a batch fashion we need to create envelopes. Nesting of Envelopes is also possible to ensure a flexible way of transferring message batches that have complex structure or relationship.
a. Set Envelop property to YES.
b. Body Xpath property need to be set.
25. We can put validation on the input data as in the case of phone numbers, ip address as they should come in a specific format. So we can define formats for them by setting Derived By property to Restriction and specifying the required pattern for that particular field.
1. Active property made true invokes a new instance of an orchestration. Only a nested Orchestration can be started without an active receive. BizTalk Server has no built in mechanism for controlling the number of instances of a given orchestration. If we have to control the number of instances of Orch A then we have to create some rule or Orch which will allow/restrict it to activate one more instance.
2. Static Global variables can be stored in Configuration files or SQL tables in order to share them across all the instances of the Orchestration.
3. Zombie is a message which is discarded when the instance of the Orchestration ends with “Completed with Discarded Message”. It typically occurs when an extra message is routed after control flow in the executing orchestration has passed the receive shape with the matching subscription or due to a time out on a LR transaction or a time out of a delay branch on a listen shape or in a loop that consists a receive shape that exits before consuming all the routed messages.
4. “Delivered Not Consumed” this is the status of the message when it is in the BTS internal work queue. It might be in this state because the engine is busy with other messages or because the destination is processing more slow than expected.
5. Curious case of Serialization in orchestration:
The XLANG compiler requires all its variables in an orchestration to be serializable since when the orchestration dehydrates and rehydrates then it serializes and deserializes those variables.
A non serializable object can only be declared and used in an atomic scope.
An interface cannot be marked as a serializable because we are never sure about their implementation. So Non Serializable objects must run inside atomic scopes.
6. For an Atomic Scope, if Retry is set to true only two exceptions “Persistence Exception” and “RetryTransactionExcepion” will make the atomic transaction retry work.
7. Orchestration supports parallel activation only in following conditions:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
8. Difference between Start Orchestration and Call Orchestration:
a. Call Orchestration is a synchronous call and it returns the control back to the caller.
b. Start orchestration is an Asynchronous call and hence it starts the orchestration in a non deterministic way. In this case some time what we expect that the new orchestration will start in time to create the necessary subscriptions to receive the messages that will be sent to it but quite often it doesn’t happen so. In this case it gives” could not find subscription error".
9. Persistence points in Orchestration:
The orchestration engine saves the entire state of an orchestration instance at various persistence points to allow rehydration of the orchestration instance. The engine stores state at the following persistence points:
• End of a transactional scope (atomic or long running)
• At debugging breakpoints
• At the execution of other orchestrations through the Start Orchestration shape
• At the Send shape (except in an atomic transaction)
• When an Orchestration Instance is suspended
• When the system shutdowns in a controlled manner
• When the engine determines it wants to dehydrate
• When an orchestration instance is finished
10. BizTalk Server upgrade: BizTalk 2004 and BizTalk 2006 cannot reside on the same machine and so as SQL Server 2000 and 2005. So while upgrading BTS2004 to 2006 database also needs to upgraded from 2000 to 2005.
Note: Within a single group in case of multiple BizTalk servers if one server is upgrade then all the servers need to be upgraded because interoperability between BTS2004 and BTS 2006 is not supported due because of DB changes.
11. Business Rule Engine:
a. Rule: A single executable statement which is made up of a condition and an action.
b. Policies: Logical group of rules.
c. Vocabulary: Friendly name given to a field.
How does rule engine works:
Business Rule Composer is used for developing business policies, vocabulary definitions, publish the policies. Inside the BRC when we want to test the policy for a .Net component we need to create a Fact creator wrapper around the .Net Component implementing the interface IFactCreator. Create Facts is the method called by the rule engine. Rule engine deployment wizard deploy/export/import the policies and vocabularies. Rule engine evaluates the condition based on fact. When a policy is executed, the facts are brought into memory. After execution all the facts submitted to the rule engine are retracted from the working memory of the rule engine.
Important: When we test a policy that uses database facts with the DataConnection binding in the Business Rule Composer, a DataConnection object is automatically built. However, when we call the same policy from an orchestration by using the Call Rules shape, no DataConnection object is passed to the policy automatically. We should create a DataConnection object in the orchestration and pass it as a parameter or create a fact retriever component that asserts the DataConnection object, and configure the policy to use the fact retriever component.
How to call Rules from:
a. Orchestration: We can call rules from orchestration using Call Rule shape. Also we can use .Net API inside the expression shape to call the policies.
i. Create the object of the samplepolicy we created in BRC.
Policy = new Microsoft.RuleEngine.Policy(“SamplePolicy”,1,0);
ii. Create the input parameter for the policy
typedXmlDoc = new MS.RE.TypedXmlDocument(“inputXML”,inmputmessgae);
iii. Execute the policy and then dispose.
Policy.Execute(typedXmlDoc);
Policy.dispose();
b. C# code:
Same as above. Only difference is that we need to create the facts object array to hold the input params for the policy as objects[] facts = new object[1];
Facts[0] = typedXmlDoc;
Policy.Execute(facts);
Advanced Concepts:
a. Forward chaining: One rule invokes the other rule.
b. Short term vs. long term fact:
i. Short-term facts are facts loaded into memory by rule engine and are available for only one execution cycle of the rule engine, after the execution facts are retracted back from memory. Long term facts are available for multiple execution cycles of rule engine.
ii. Short term facts are passed to rule engine as array of objects, whereas long term facts are passed as typed Data Table which has typed Data Rows to rule engine.
12. Transactions in Orchestration:
a. Atomic Transaction: Either completely successful or completely rollbacked.
i. Cannot contain nested Atomic transaction or LR transaction or a exception handler however can contain a compensation block.
ii. We cannot construct an atomic transaction with a request response pair of actions, nor we can have send and receive shape that uses the same correlation set.
iii. When a message is received in an atomic transaction, it is delivered to the orchestration but not removed from the message box until the transaction commits.
b. LR Transaction: A transaction which executes for several hours, days or even weeks and contains several atomic transactions. These smaller atomic transactions which are completed/committed, cannot be rolled back and hence need to be compensated.
COMPENSATION: Undo operation
Exception block does not roll back the transaction but just throws the error.
13. When many long-running business processes are running at the same time, memory and performance are potential issues. The orchestration engine addresses these issues by "dehydrating" and "rehydrating" orchestration instances.
Dehydration is the process of serializing the state of an orchestration into a SQL Server database. Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database. Dehydration is used to minimize the use of system resources by reducing the number of orchestrations that have to be instantiated in memory at one time.
14. Correlation is used to map a message to its corresponding Orchestration instance A correlation set is a collection of promoted message property values that we use to route an incoming message to an executing instance. The message is evaluated for the message type and every property in the set in order to correctly route it to the instance. Correlation is achieved with the help of "Initialize Correlation Set" and "Follow up Correlation Set" properties in the Send and Receive shapes.
15. Deployment: After build phase of the BizTalk project when we need to migrate the work from our work environment to test environment first we need to export the .msi files. Remenber that configuration values what we have made in BTSNTSvc.exe.config file are not exported. Patches(only added\modified file) can also be exported. Export bindings and plocies.
After exporting import the .msi and binding files in the test environment.
16. Binding Model in BizTalk:
a. Direct Binding(Most Flexible): In this Model, orchestration ports do not automatically use BTS.SPID or BTS.RecievePortId. Rather filter expressions or self correlating or message context property can be used. Can be used to send message to other orchestration. Drawback is that we cannot configure our orchestration port using binding files. We need to do more programming in order to fully exploit the flexibility.
b. Specify later: Less flexible but most common. BTS.SPID, BTS.RecieverId
c. Specify now: BizTalk collects transport and pipeline info at design time.
d. Dynamic Binding: In expressions we have to give URLs that can be picked from config file.
17. Delivery Notification in BizTalk: If an Orchestration port is marked with Delivery Notification = Transmitted, and the Send shape in the Orchestration is in a synchronized scope, the Orchestration will wait until it either receives an ACK or a NACK for the message that was transmitted. In the case that the message was successfully transmitted, the engine will publish an ACK ensuring that it is routed back to that Orchestration instance, once the Orchestration receives the ACK it will leave the scope and continue processing. If however the transmission failed and the message was suspended, the engine will publish a NACK which again will be routed back to the Orchestration instance, the Orchestration will throw a DeliveryFailureException which can of course be caught and handled as appropriate in the Orchestration.
18. Dynamic Mapping: Dynamic mapping is the concept of specifying the map to be used for a transform at runtime inside the orchestration. That means no Transform Shape is used to specify the map or input and output schemas.
Example: We are receiving a standard invoice from multiple locations for the same vendor. The schema is exactly the same but the mapping of the vendor data to the base schema (date formats, currency conversion, etc.) is slightly different based on the vendor location.
Why not map on the Receive Port? This is the most common solution to this type of scenario. This uses document normalization to transform all your messages into the same type before it hits our business process. This is a great solution but what about exceptions?
Exceptions in maps on the Receive Port can be hard to react to and even harder to orchestrate a retry or recovery process. That is when mapping inside an Orchestration and Dynamic Maps come into play.
With dynamic maps, the map name can be stored inside an attribute in the message, read from the SSO, or read from some other custom component. Then, it is as simple as creating a System.Type with the strong fully qualified map name.
This would look something like this:
Suppose SubscriberInformation is the node in input xml which contains the recipients info then we will take it in a variable.
SubscriberInformation = Generic_In(DynamicMaps.PropertySchema.SubscriberInfo );
then we will take the maptype in another variable of System.Type like this
tMap = System.Type.GetType("DynamicMaps.Map_ABC,DynamicMaps, Version=1.0.0.0, Culture=neutral,PublicKeyToken=f85be9e4dd36fb1d");
then in a message assignment shape we can construct the out message as follows:
transform (Message_Out) = tMap(Generic_In);
Alternatively we can do it in an expression shape using the construct keyword as below:
construct Message_Out
{
transform (Message_Out) = tMap(Generic_In);
}
19. BizTalk Server can accommodate two or more schema with the same root node as long as the schemas have unique namespace designations.
20. Message context includes all the instance specific and exchange specific data fields, and essentially is the metadata that the messaging engine of BizTalk Server uses to process messages. While duplicating a message it should be noted that Only MessageDataPropertyBase gets copied not the MessageContextProperty Base. So to copy the message context property of message 2 into the message context of message 1
Message1(*) = Message2(*);
21. Distinguish fields are used opposed to promoted fields to enhance the performance.
a) Distinguish fields are available only within a single orchestration and they are not available to other BizTalk Server objects such as receive locations, send ports, send port groups and tracking utilities.
b) Distinguish fields can be of any length; promoted properties have a maximum length of 255 characters.
c) Distinguished fields have less of a performance impact than promoted properties as they are not persisted to the Message Box database. Instead they are XPath aliases which simply point to the appropriate XML data field.
d) Distinguish fields are accessed in following fashion: MessageName.RecordName.Childname while Promoted fields are accessed in this way MessageName(PropertySchemaName.PromotedPropertyName)
22. To hide promoted properties from the tools like HAT and BAM, set the promoted property’s Sensitive Information property to True.
23. It is also possible to create message context properties that do not exist in the message by just adding a node to the property schema and setting its Property Schema base property to MessageContextProperty Base.
24. To process a message that contains multiple records in a batch fashion we need to create envelopes. Nesting of Envelopes is also possible to ensure a flexible way of transferring message batches that have complex structure or relationship.
a. Set Envelop property to YES.
b. Body Xpath property need to be set.
25. We can put validation on the input data as in the case of phone numbers, ip address as they should come in a specific format. So we can define formats for them by setting Derived By property to Restriction and specifying the required pattern for that particular field.
Friday, July 24, 2009
Kya ab bhi Insaniyat baaki hai....
Kya ab bhi Insaniyat baaki hai....
Ek vyang bhari muskaan kal mujhe chhoo kar nikal gai..
Dil me bhavnayein jo thos thi, Sab pighal gai...
Aansuon ki dhar kuchh aise bahi surk gaalo par..
dhadkan meri antar tak sihar gayi....
jab bhangi se jaaga to paas koi bhi nahi tha...
Dur un masoom hatho me aluminium ka katora pada tha..
Log aate jate us par taras khate nikal jate the..
Katora paise se kam, bas umidon se bhara tha..
Aaj un karun aankho me kasish thi, tanmayta thi...
kabhi jinme sapne saakaar karne ki utsukta thi...
bhavishya apna wo ab logo ki thikro pe banata hai bigarta hai..
kal tak jin khwabo me kuchh kar gujarne ki kshamta thi...
Kaise toote sapne uske iski bhi ek datsan hai..
maa baap ke guzarte hi bechara kitna pareshaan hai..
karib ke rishtedaro ne mushkil me kinara kar liya..
aur nishthur lalchi duniya ne use besahara kar diya..
Jab Jab ek palak bhi use dekhta hun..
is nirdai samaj ko kosta hun...
Bharosa ab to insaniyat par se uth gaya hai..
Aur sir bhi mera sharam se jhuk gaya hai..
Kya manviya mulya patal k gart me sama gaye hain..
ya fir hamari aatmaaon ko kaal nigal gaye hain..
Mar chuki hai insaniyat ab to, sirf chhal kapat chhaya hai..
Is kale mahasagar me bas kagazo ki maya hai..
Hatash ho chala tha mai, par tabhi dekha un haatho ko..
jo badh chale us chhote bachhe ko thamne ko...
Is wakye ne Insaniyat ko fir se jila diya..
aur ab bhi mari nahi hai insaniyat, ye mujhe sikha diya..
par ek vyang wali muskaan fir se mujhe hila gai...
apne kavi hone ke garv ko jad se murja gayi..
kalam se likhe ke apna kaam poora kar diya..
maan ke ho gai smaaj jagrut, man me hi khush ho liya..
par humse bada kavi to wo insaan hai ..
Jo samasya ko samajhta hai..janta hai..
Sirf likhta hi nahi, balki kuchh karke dikhata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
Ek vyang bhari muskaan kal mujhe chhoo kar nikal gai..
Dil me bhavnayein jo thos thi, Sab pighal gai...
Aansuon ki dhar kuchh aise bahi surk gaalo par..
dhadkan meri antar tak sihar gayi....
jab bhangi se jaaga to paas koi bhi nahi tha...
Dur un masoom hatho me aluminium ka katora pada tha..
Log aate jate us par taras khate nikal jate the..
Katora paise se kam, bas umidon se bhara tha..
Aaj un karun aankho me kasish thi, tanmayta thi...
kabhi jinme sapne saakaar karne ki utsukta thi...
bhavishya apna wo ab logo ki thikro pe banata hai bigarta hai..
kal tak jin khwabo me kuchh kar gujarne ki kshamta thi...
Kaise toote sapne uske iski bhi ek datsan hai..
maa baap ke guzarte hi bechara kitna pareshaan hai..
karib ke rishtedaro ne mushkil me kinara kar liya..
aur nishthur lalchi duniya ne use besahara kar diya..
Jab Jab ek palak bhi use dekhta hun..
is nirdai samaj ko kosta hun...
Bharosa ab to insaniyat par se uth gaya hai..
Aur sir bhi mera sharam se jhuk gaya hai..
Kya manviya mulya patal k gart me sama gaye hain..
ya fir hamari aatmaaon ko kaal nigal gaye hain..
Mar chuki hai insaniyat ab to, sirf chhal kapat chhaya hai..
Is kale mahasagar me bas kagazo ki maya hai..
Hatash ho chala tha mai, par tabhi dekha un haatho ko..
jo badh chale us chhote bachhe ko thamne ko...
Is wakye ne Insaniyat ko fir se jila diya..
aur ab bhi mari nahi hai insaniyat, ye mujhe sikha diya..
par ek vyang wali muskaan fir se mujhe hila gai...
apne kavi hone ke garv ko jad se murja gayi..
kalam se likhe ke apna kaam poora kar diya..
maan ke ho gai smaaj jagrut, man me hi khush ho liya..
par humse bada kavi to wo insaan hai ..
Jo samasya ko samajhta hai..janta hai..
Sirf likhta hi nahi, balki kuchh karke dikhata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
Subscribe to:
Posts (Atom)