TFS not compatible with SQL collation during setup

Installing TFS in existing database and come across this issue.

The following SQL Server instance is not compatible with Team Foundation Server: TFS\tfs_db. 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 requirement

Solution is to run the following code in visual studio command prompt, the code can change the sql collation to support collation. Latin1_General_CI_AS

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=TFS /SQLSYSADMINACCOUNTS=sa /SAPWD=pass@word1 /SQLCOLLATION=Latin1_General_CI_AS

Issue install .NET3.5 in Windows Server 2012

Using windows server add role feature to install .net3.5 framework in server 2012 has an issue in one of the wizard steps as it prompt me:
Do you need to specify an alternate source path?...missing source file on destination

weird...seems like a defeat in the wizard.

Solution is to use the CD with command prompt to execute it.
Insert the windows server 2012 disk into CDrom, example (d:)

Type following command in command prompt:
dism /online /enable-feature /featurename:NetFX3 /all /Source:d:\sources\sxs /LimitAccess

This solved my problem.

Update Rollup 2 for CRM 2013 (2919956)

Released on 22/3. This is a cumulative updates.
Support for the following items:
    -Windows 8.1 and Internet Explorer 11 using CRM 2013 web application and CRM for Tablets
    -iOS7 support with Safari on iPad using the web application
    -Support for Safari using web application and CRM for Tablets using the tablet app for iPad Air
    -Windows Server 2012 R2 for CRM Server

Download from here
KB2919956

Visual Studio Error: The project type is not supported by this installation

Just some quick tips on how I solve the visual studio error "the project type is not supported by this installation"
I got this error when I tried to copy a plugin solution into another VM.

Solution:
Open the csproj file in notepad
Search and replace the ProjectTypeGuids with the line below:

<ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids>

SQL Server 2008 Native Client cannot be found

 Hit a weird issue while trying to install SQL server 2008 native client. I'm sure i have the correct installer and is extracted to local drive. Throw me resource unavailable 'sqlncli_x64.msi' not found.

Log file shows : "An installation package for the product Microsoft SQL Server 2008 Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'."

Endup is the issue with previous installation caused some incomplete setup on the client, go into control panel, find the SQL 2008 native client.
Unintall the existing client, then reinstall. Everything run successfully after that.