Anuj Chauhan

[Configuration Database] TF255374: The following SQL Server instance is not compatible with Team Foundation Server: VBXW2008\SQLSVR08. The default collation is set to Latin1_General_CI_AI. Team Foundation Server requires that the default collation be case insensitive and accent sensitive. You must choose a SQL Server instance whose default collation settings match these requirements

The best option i found out was either i re-install the SQL SERVER 2008 again fresh or create a new instance with collation settings defined properly at the time of installation . 

Team Foundation Server 2010 TFS 2010, TF255374

We can enable this setting by including the below code in webconfig of WCF web service . By adding the tag <serviceDebug includeExceptionDetailInFaults="true"/> we can get the details of the specific exception raised at server side into client side when Debugger is attached with client application .

<system.serviceModel>
    <behaviors>
      <serviceBehaviors>
        <behavior>
          <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
          <serviceMetadata httpGetEnabled="true"/>
          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
          <serviceDebug includeExceptionDetailInFaults="true"/>
        </behavior>
      </serviceBehaviors>
    </behaviors>
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
  </system.serviceModel>

WCF Exception

I was getting a stackOverFlowException in my program , i found out that i have called my function in its own definition body , actually i had a similar name function in other class and i forgot to call that function with its own instance and hence this exception was thrown . 

C# StackOverFlowException

Nice msdn article for this topic :- http://msdn.microsoft.com/en-us/library/system.windows.data.ivalueconverter(v=vs.100).aspx

C# IValueConverter

We can use Lambda expression in order to pass a multiple parameter function to a thread .

Thread MailThread = new Thread(() => StartSendMail(Email, VerificationCode));

Threading C# Multiple Parameter function, Thread

These two links below explains how we can use a utility called Portqry to determine whether a specific port or range of ports opened on Remote Machine or not .

1. http://www.speedguide.net/faq_in_q.php?qid=117

2. http://www.petri.co.il/quickly_find_remote_open_ports.htm

Utility PortQry, Port Open, Remote Port

This is a good post which explains thoroughly how to check whether your processor support SLAT . 

http://www.howtogeek.com/73318/how-to-check-if-your-cpu-supports-second-level-address-translation-slat/

Windows Phone 8 Dev SLAT, Windows Phone 8, WP8 Emulator

Its a very nice blog which explains how to set a VMware containing machine to act as server for VMware 8.0 . 

http://esense.be/33/2012/04/16/the-virtual-machine-sharing-service-is-not-available-in-vmware-workstation-8/

VMWARE

Its a great blog where you can learn how to host multiple sites on a single IP - http://weblogs.asp.net/istofix/archive/2009/08/18/hosting-multiple-websites-applications-on-iis-part-1.aspx

IIS multiple site

The simplest process i came across while searching for a way to host my own website on my own server without getting in hassles of choosing web hosting service was www.no-ip.com

All you have to do is register for the free service there and you will get an email with the steps to follow with a client software which you have to install on your machine. After that you will have to configure your ADSL Router ( if you are using it to access internet ) to forward port number 80 to the ip address of your machine which is going to be a web server . And you are done now the client software you installed will automatically update the IP in DNS server of no-ip.com and you can access your site with

<your site name >.no-ip.org

this kind of domain is given when you use free package and there is also an option to pay and use your own domain but i haven't checked that yet . So enjoy and Host your site with a dynamic IP !

no-ip.com Dynamic IP Hosting