About me
Name: Sachin, aka "Sach"
Web Site: http://www.sachinjain.me
Bio: I am an IT professional from india who is working from last 8 years in this industry and currently working with global leading companies. Here I would like to share my knowledge, experience and hopefully that will be useful to you people.
Why HR Managers?
On this blog I would like to ask why HR managers needed in an organization ? Are they needed for Recruitment ? Are they needed for payroll management ? Are
they needed for appraisel ? All these things can be outsourced as well, then why we need an HR manager in organization itself ? What ...
whats new in asp.net 4.0
1) Permanent redirect - for HTTP 301 Moved Permanently you can now use RedirectPermanent("yourpage.aspx");
2) Meta Properties- Now you can use page.MetaKeywords and page.metaDescription for setting up meta tags.
3) Compressing session state - ASP.NET 4 introduces a new compression option for both kinds of out-of-process session-state providers. Example
when compressionEnabled is set to true ...
Re-invention of Email – Google Wave – Top 10 Features
Google has introduced its new product GOOGLE WAVE! It is an online tool provides communication and collaboration in real time. Google wave has been build on the concept of cloud computing.
It just a next generation emailing or communication tool. It has merged social networking, instant messaging, emails, wiki all together at one platform. You can ...
Do’s and Don’t for Interview
Do's
1) Early arrival - There is no excuse for late candidates. Always arrive 15 min early.
2) Giving your qualifications - Stress your accomplishments that are most related to the job.
3) Conduct yourself professionaly - Be aware what your body language is saying. For example - Smile, make eye contact.
4) Anticipate tough questions - Prepare yourself ...
Unique constraints for LARGE TEXT columns – SQL
Suppose you are storing URL in your table and you want to apply UNIQUE contraint but as SQL allows only 900 byte limit. how can you put unique constraint for larger text ??
For this you can create a computed CHECKSUM column which is an integer vale and put constraint on it.
Example as follows
CREATE TABLE messages ...
preventing select * from the query in SQL
For Team Leads, Developer don't listen what you say :) still using * in their select queries. You can restrict them using * by using deny select on object.
This all you can do by create a dummy column in table and deny it for selection. Now user can select the rest of the columns ...
Top 7 features of windows 7
1) Home Group - Now you can share pictures, documents , videos , music in network with ease. Home Group is a feature that allows you to join any one in a network by just clicking to "join now". Yes, ofcourse privacy has been maintained, you can set the password while sharing your documents over ...
Custom application error tracking through global.asax file
Here it goes :-
void Application_Error(object sender, EventArgs e)
{
string strError = "Error in: " + Request.Path +
"Url: " + Request.RawUrl + "";
// Get the exception object for the last error message that occured.
Exception ErrorInfo = Server.GetLastError().GetBaseException();
strError += "Error Message: " + ErrorInfo.Message +
"Error Source: " + ErrorInfo.Source +
"Error Target Site: " + ErrorInfo.TargetSite +
"IP: " + ...
Non Verbal Communication – 93% effective
Communication without words plays an very important role in communication. It is surprising that the words you are delivering is not as much effective, it is
the non verbal communication which makes your communication more effective. For example eye contact, Your tone (loud , low , polite).
Lets categorized it :-
1) Kinesics or body language - It ...
WCF Architecture
Following is the diagram for WCF architecture
1. Contracts - It contains information about what service does and type of information it will make available.
a) Data - A data contract includes the data that will be exchanged by the service. The service and the client do not need to agree on the types, but they ...
Naming Conventions and Standards – C#
1) Use Pascal casing for type and method names and constants:
public class YourClass
{
const int ConstantVariable = 100;
public YourMethod( )
{}
}
2) Use camel casing for local variable names and method arguments. Use p prefix for parameterized vairables:
int intNumber;
void MyMethod(int pintNumber)
{} ...
Generate Paging – Custom function
Here it goes
private int mstrPageSize = 1;
private int mstrTotalRecords = 1;
private int mstrCurrentPage = 1;
public int PageSize
{
get
{
...