BALA SINGAM

Its just another day at work …. mani 4.23pm achi , tukkam tukkam ma varethe verra…. innum SSIS velai senji mudikele. GRE exam ke verra padikenum ( book vanggi oru month kude achi  annal innum orru chapter kude padichi kileke) , exam on 31st december Neraiya velai pending le irukke ethuvum seiya mood ille.

Need to prepare my Statement of purpose for the masters application , anthe eleve verra prepare pennenum , atherkum idea ille. Chinna vaise le irunthe ellathiyum last minute lei seirethe nan vanggithe vanthe varam achi. Evele time iruthalum anthe kadi minute le than velei ye nadekum. My biggest weakness is time management. I wasted a lot of time in my life dreaming .

Valkeile neraiya seiyenum , achieve pennenum assai , neraiya kathekenum assai annal because my bad time management ellamme half way stop airum. Mukiyumma rumba neram tunggiye vinaikireven ( and lately its getting worse). I only have 8 days left to study for my GRE exam and i have alot to cover. I also need write letter to my past university (where i done my BSc) to request to send official transcript to the university that i intend to apply. Ithe ennoru thalei valli. Universities in Malaysia not familiar of this procedure sending official transcripts onbehalf of student.

When i call the CalState LA earlier this month to explain my situation this was the response from the person who answer my call

“No , your not the first person applying from Malaysia , we have been receiveing students from Malaysia and they able to request their University to send official transcripts and you should too”.

I know i gonna have hard time to convince my university to do this for me , knowing their attitude very much. Anthe Murugan orru nalle valiye kathenum.

Inthe paracheneigal gap le blog penneve time ille ( actually time irukke annal manage penne terile ). Initially I planned to fill this blog with technical posting , annel kalam pokkal athe kunjem mission imposibble mathiri peikithe irukke , cause its take more time to prepare the materials.

Manasene nimthiya blog penne kude vidematherangge (athe kule customer kithe irunthe call , ethavethe sethei pennithe nambe uyire vanggevangge :(  ).

Eppediyo inthe year end ke vare pothe and next new year yum varre pothe, so new year sonnale new year resolution irukenum ( achieve pennerumo illayo itu belakang cerita ). So nanum 3 visiyum en year 2009 resolution vichiruken.

First resolution , by this time of next year I must enroll for masters at any one of university in United State most likely in California. Second ASP.Net MVC mastered pennenum , means atleast have one online website based on ASP.Net MVC. Kadesi resolution , chinna vaisele irunthe rumba asai guitar kathekenum ne. Recently varanam aiyerum movie light the spirit back in me and most important thing last nite i have found a channel in YouTube by itsSoldier . He is tamilan and currently in california and play guitar excellent!

To end this rambling post i have post one of performance from itsSoldier

To Create A Service

* Start | Run and type cmd in the Open: line. Click OK.
* Type: sc create
* Reboot the system

To Delete A Service

* Start | Run and type cmd in the Open: line. Click OK.
* Type: sc delete
* Reboot the system

This small tutorial is to show how to get particular date part of from a date value field in SQL Server query.

select sales_date,
         Day(sales_date) as Day,
         Month(sales_date) as Month,
         Year(sales_date) as Year,
         Day(getDate()) as Current_Day,
         Month(getDate()) as Current_Month,
         Year(getDate()) as Current_Year
   from sales_detail

Result

In above query my date field is sales_date , using Day , Month and Year function i can get the particular date part by passing sales_date as parameter. This is to get date part value from a particular field value.

To get date part from current date is almost same only passing the current date as parameter. To get current date use getDate() function which will return the current date.