Collate in SQL Server

Collate specifies the set of rules that are used during various comparisons, sorting etc. For example it specifies whether the comparisons should be case sensitive or not etc.

KoGrid with server side paging, sorting and filtering

Here is the code for implementing server side paging, sorting and filtering in koGrid (a.k.a. knockout grid). To see how to implement lazy loading in koGrid follow the link.

Committing against a workitem in VSTS

The detailed steps for creating a workitem in VSTS and committing against it in Git version control system are provided below :-

Using Git with VSTS

Below are the steps to get started with VSTS with Git as the version control system.

Sorting in Angular js controller (along with paging)

Considering the problem of sorting only a handful of items that are on the current page, I guess sorting using the "orderBy" filter inside ng-repeat tag is not a good idea. So the solution is to apply sorting in AngularJS controller and here is how you can do that.

Sorting in Angular JS along with paging - (in View)

Below is the code for applying sorting in Angular js table along with paging applied. In this code the sorting is done on the view only i.e. sorting is done using attributes in the ng-repeat tag itself.

Generic way to access the members of an object and their values in C#

There might be situations where you want to loop through the members of an object or you want to create some generic means to access the members of one or more classes, so here is how you can access the members of an object in C# in a generic manner.

Calling a Oracle S.P. that is returning REFCURSOR through Entity Framework

Here are the steps for how to call Oracle S.P. that is returning REFCURSOR through Entity Framework :-

Restrict desktop application to single instance using MUTEX

Here is the code to restrict a desktop application to single instance (for creating single instance per user application follow the link).

Single instance per user of desktop application (.NET)

Here is the code to restrict a desktop application to single instance per user (for single instance desktop application follow the link).