Steam - Updating stuck

If steam gets stuck at the "Updating Steam" progress bar, open TCP View, right-click on steam.exe and select "Close Connection".

You may have to do this twice.

LinqPad + EF Code First: The type 'UserQuery+' was not mapped. Check that the type has not been explicitly excluded by using the Ignore method or NotMappedAttribute data annotation. Verify that the type was defined as a class, is not primitive, nested or generic, and does not inherit from EntityObject.

Take the following simple Entity Framework code:

public static void Main()
{
 var context = new MyContext();
 context.Database.Connection.ConnectionString = "Data Source=.;Integrated Security=SSPI;Initial Catalog=AndyTest;MultipleActiveResultSets=true";
}

public class Person
{
 [Key]
 public int Id { get; set; }
 public int Age { get; set; }
 [StringLength(50)]
 public int Name { get; set; }
}

public class MyContext : DbContext
{
 public DbSet Persons {get; set;}
}

If you run this in LinqPad, you get the error: The type 'UserQuery+Person' was not mapped. Check that the type has not been explicitly excluded by using the Ignore method or NotMappedAttribute data annotation. Verify that the type was defined as a class, is not primitive, nested or generic, and does not inherit from EntityObject. This is because all the code written in LinqPad is encapsulated within a UserQuery class - and Entity Framework will complain that the Person class is nested within LinqPad's UserQuery class. To allow this code to work within LinqPad, add the following line to the top of the LinqPad code:

#define NONEST

http://stackoverflow.com/questions/8730225/linqpad-ef-4-1-sqlce

Allowing Firefox to work on an Intranet application that uses Kerberos authentication

http://blog.webonweboff.com/2010/12/integrated-windows-authentication-and.html

Checking in from VS2008 to TFS2010

In order to check in from VS2008 to TFS2010, you need to install

Team Foundation Server Power Tools   October 2008
Power Tools that extend the Team Foundation Server integration with Visual Studio.

This enables custom check-in policies.

Context sensitive help in Endur

To get context sensitive help in Endur,

locate the help file (e.g. C:\OpenLink\helpdir\olf.chm).

Edit your start configuration, setting the environment variable:

SET AB_HELP_FILE=C:\OpenLink\helpdir\olf.chm

To set the variable immediately, go into System Wide Configuration.
Enter Help into the Search box. Click on AB_HELP_FILE.
In the right hand pane, select the username and enter the User Value (e.g. C:\OpenLink\helpdir\olf.chm).

Click Save.

Firefox credential delegation

http://stackoverflow.com/questions/809317/configure-firefox-3-0-x-to-authenticate-with-kerberos-and-not-prompt

It IS necessary to restart Firefox after changing the settings.

T-SQL: Selecting the top n rows from a Group By

I have the following data

deal_tracking_num	tran_num	type_id	value	personnel_id	last_update
897693	897693	20065	Manual	20015	2012-11-22 10:59:38.240
897693	897693	20065	Non-STP	20015	2012-11-22 11:09:09.190
897695	897695	20065	Manual	20015	2012-11-22 10:58:58.063
897695	897702	20065	Manual	20015	2012-11-22 10:59:23.493
897698	897698	20065	STP	20015	2012-11-22 10:16:23.903
897698	897698	20065	eCM	20015	2012-11-22 10:18:38.587
897698	897701	20065	eCM	20015	2012-11-22 10:21:07.350
897698	897703	20065	eCM	20015	2012-11-22 11:22:25.377

To select the first row for each deal_tracking_num, use the following query:

select a.deal_tracking_num, a.value from 
(
     SELECT ab.deal_tracking_num, ati.*, ROW_NUMBER() over (partition by deal_tracking_num ORDER BY ab.deal_tracking_num, ati.last_update) as rank
     FROM ab_tran_info_history ati JOIN ab_tran ab ON ab.tran_num = ati.tran_num
     WHERE ati.type_id = 20065 -- Trade Confirmation Type
) a
where RANK = 1

This returns

897693	Manual
897695	Manual
897698	STP