-
Subscription
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.
Categories
- .Net (7)
- WCF (2)
- Web Services (1)
- C# (6)
- Design Patterns (2)
- Management (4)
- Individual (3)
- Organization (2)
- New Updates (2)
- SQL Server (4)
- SQL Server 2005 (3)
- SQL Server 2008 (4)
- .Net (7)
Popular
.Net .Net WCF abstract class Architecture asp.net 4.0 C# Communication Design Pattern dynamic 4.0 Error Tracking Event log Features fo windows 7 HRM HR Managers Individual interface interview tips LINQ LINQ Queries Management Non Verbal paging preventing select * Singelton SQL Server unique constraint var asp.net WCF Web Services Windows 7
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 ...
Sample LINQ Queries in .net
1) Simple Query
var CustQuery= from cust in customers
select cust;
2) Where Clause
var DelhiCustomerQuery = from cust in customers
where cust.City == "Delhi"
select cust;
Logical Operator
where cust.City=="delhi" && cust.Name == "mumbai"
3) Order by
var DelhiCustomerQuery = from cust in customers where cust.City == "Delhi" orderby cust.Name ascending
select cust;
4) Group by
var QueryGroupByCity = from cust in customers group cust by cust.City
Now ...
3 Key new features in .net 4.0
Following are the 3 new Key features in .net 4.0
1) Windows work flow and WCF 4.0:- This is a major change in 4.0.
In WCF they have given following features :-
Dynamic Service and End Point discovery - The problem was faced in earlier version of WCF that if theend point has been changed at service ...
Difference between dynamic and var keyword .net 4.0
In .net 4.0 dynamic keyword has been introduced. This allows you to define the object without specifying its type. So let say we have following string :-
string s = "sachin";
We can define another variable without specifying the type
dynamic d = s;
Now this can also be done through var keyword so whats the difference?
The difference is ...
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 ...