Follow the article: http://www.c-sharpcorner.com/uploadfile/b1df45/web-api-self-hosting-using-windows-service/
Also make sure to follow the steps by the SO answer: http://stackoverflow.com/a/6382120
Category: Tips and tricks
Consume Web API response in SSRS
Follow the article: http://jaliyaudagedara.blogspot.sg/2015/10/using-aspnet-web-api-as-data-source-for.html
Need to configure the web api service to always return XML data. When configuring the data source, add ?type=xml at the end of the URL.
Note: for SSRS/Report Builder to retrieve the fields, don’t use blank query string, use the following:
<Query>
</Query>
Allow multiple users to remote to a computer using same account in Windows
Just change the value of a registry key.
Open regedit, browse to HKEY_LOCAL_MACHINE\ System\ CurrentControlSet\ Control\ TerminalServer
change the value of the key fSingleSessionPerUser from 1 to 0.
Use immediate window to run code in Visual Studio while debugging
It’s like Chrome Developer’s tools console. You can execute command easily
Get a schema of a database table listed out in SQL Server
From SQL Management Studio, select the table you want to generate schema, right click and select “Script table as…”, then “CREATE to”, then “New query window”
The management studio will generate a create statement to recreate the table, copy the code for your purpose.
Productivity tools
Kanban board
The offline tool I’m currently using http://greggigon.github.io/my-personal-kanban/ . Simple, fast and easy to use. Just create an IIS web application and put this inside. Make sure to export and backup data regularly.
Time tracking
Time tracker at http://0xff.net/site/index.php/timetracker/downloads/ seems to have a really great UI and easy to use with automatic tracking with reports and ability to export.