Why can't I install programs as an administrator?

Insure the regsitry keys under the following node have a value of "Enabled"

\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\.NETFramework\Security\TrustManager\

References:

https://msdn.microsoft.com/en-us/library/cc176048(v=vs.90).aspx

https://msdn.microsoft.com/en-us/library/ee308453.aspx

Get top 2 rows per group by

Given a Commissions table with a Commission (decimal) and an employeeID primary key columns,  list the top 2 commissions of each employee:

Best is to use a CTE with either the ROW_NUMBER() or RANK() partitions:

 ;With CTE_MyRank as (
SELECT [Commission]
      ,[EmployeeId]
      ,[CommissionID]
 , ROW_NUMBER() over (partition by employeeID order by commission desc) as Rankx
  FROM [Training].[dbo].[Commissions] 
  )

  select  EmployeeID, commission, Rankx from CTE_MyRank where rankx < 3 order  by [EmployeeId] desc, commission desc



OR the less favorite way is to use MAX , Group By and a UNION:

  Select  Max([Commission]) xMax, [EmployeeId] from [Training].[dbo].[Commissions]
   Group by [EmployeeId] 
  UNION
 Select Max(Commission) xMax, [EmployeeId] from [Training].[dbo].[Commissions] 
 where (Commission) not in (select Max([Commission]) from [Training].[dbo].[Commissions] 
 Group by [EmployeeId] )

Group by [EmployeeId] 
   order by [EmployeeId] desc, xMAx desc

Get the values of all fields/properties of a C# object using reflection

using System.Reflection;     


 private List GetPropertyList(object obj)
        {
            List propertyList = new List();

            Type type = obj.GetType();
            PropertyInfo[] properties = type.GetProperties(BindingFlags.Instance |
                                                            BindingFlags.Public);
            foreach (PropertyInfo property in properties)
            {
                object o = property.GetValue(obj, null);
                propertyList.Add(o == null ? "" : o.ToString());
            }
            return propertyList;
        }

Link to one of the best bootstrap validators

http://1000hz.github.io/bootstrap-validator/

Also angular validations:

https://scotch.io/tutorials/angularjs-form-validation-with-ngmessages

Open modal is shifting fixed navbar to the right

Solution:

body.modal-open {

overflow-y: scroll;

padding-right: 0 !important;

}

Reference:

https://github.com/twbs/bootstrap/issues/14040

Copying long path names in Windows - robocopy to the rescue

To copy from long path names use the robocopy command provided in Windows 8.1:

For example to mirror a folder and its sub-folders issue:

robocopy Z:\Dev\GruntDemo C:\DevNew\GruntDemo /mir

CORS, access denied issue resolved in IE11

1) Remove both server and client from Trusted sites. This solved my problems:
http://devmohd.blogspot.com/2013/09/cross-domain.html

2) If using JQuery, optionally add this for older versions of IE

                jQuery.support.cors = true;

3) Optionally add this in angular config:
      $httpProvider.defaults.useXDomain = true;
      delete $httpProvider.defaults.headers.common['X-Requested-With'];