BALA SINGAM

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.

Few weeks back , I have this reportviewer printing problem during our UAT. When user click the print button in reportviewer the machine died and reboot , and its only happen in few machine. In others machine reportviewer working fine.

Further finding shows only the machines that have installed the Security Patch KB925902 facing this problem.

The problem

The user machine crash and reboot when users click print button in reportviewer.

Cause

The problem exist after the installation of Security Patch KB925902 and microsoft site reported following models of printers effected

The site also stated

This problem occurs when a printer driver makes a call that has invalid parameters to the Win32K.sys component. This problem affects the following printer drivers:

Solution

I guess you already know , yes apply another hotfix , KB 935843

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

Rocky Balboa

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

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

The writer say

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

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

Click here the read the full article.