Here is some sql to reset the identity column on a table in Microsoft SQL Server.

dbcc checkident ('tablename', reseed, 1)

Below is a snippet of SQL code that I use to add transaction-time columns to a database table.

a) when and who created a record

b) when and who updated a record

Snodgrass refers to a table with these columns as a transaction-time state table.

alter table [table1] add [CreateDate] [smalldatetime] NOT NULL CONSTRAINT [DF_table1_CreateDate] DEFAULT (getdate())
alter table [table1] add [CreateUserId] [varchar] (20) NOT NULL CONSTRAINT [DF_table1_CreateUserId] DEFAULT (suser_sname())
alter table [table1] add [UpdateDate] [smalldatetime] NOT NULL CONSTRAINT [DF_table1_UpdateDate] DEFAULT (getdate())
alter ta ...

Have you ever created a class library project, started to write some unit tests and realize you did not use the VS2005 UnitTest Project Template to create your project.

I have done this countless times, left over habits from NUnit days I guess.

So, using notepad, I popped open a csproj file the I created using the correct VS2005 Project Template for unit testing.  I found a key called ProjectTypeGuids.  Using notepad again, I opened my class library project and did not find a key called ProjectTypeGuids.  So, I put the following key in my project, and what do you know it worked!!!!

I think the guids are different for VB.NET and C# project templates.  So if  you are using VB.NET, you may have to lookup the appropriate guids.

Jeff Beehler, thanks for pointing us to this.

Finally, some documented Branching Guidance with Team Foundation Server from Microsoft .  This includes a section on how Microsoft is using branching using "Feature Crews".

Doug Neumann is a program manager on Visual Studio Team System's Source Code control system, and I found the video Branching 101 with him very useful.  However, watch him squirm in his chair when asked about when should a client consider branching, or what is the right branching mod ...