Listing 1, Inside the TFS Databases, Part 2

[ID] 			[int] 		NOT NULL,
[ParentID] 		[int] 		NOT NULL,
[Node Name] 		[nvarchar](255) NULL,
[Node Type] 		[nvarchar](128) NULL,
[InDeletedTreeFlag] 	[bit] 		NOT NULL,
[InAdminOnlyTreeFlag] 	[bit] 		NOT NULL,
[Team Project] 		[nvarchar](255) NULL,
[Area Level 1] 		[nvarchar](255) NULL,
[Area Level 2] 		[nvarchar](255) NULL,
[Area Level 3] 		[nvarchar](255) NULL,
[Area Level 4] 		[nvarchar](255) NULL,
[Area Level 5] 		[nvarchar](255) NULL,
[Area Level 6] 		[nvarchar](255) NULL,
[Area Level 7] 		[nvarchar](255) NULL,
[Iteration Level 1] 	[nvarchar](255) NULL,
[Iteration Level 2] 	[nvarchar](255) NULL,
[Iteration Level 3] 	[nvarchar](255) NULL,
[Iteration Level 4] 	[nvarchar](255) NULL,
[Iteration Level 5] 	[nvarchar](255) NULL,
[Iteration Level 6] 	[nvarchar](255) NULL,
[Iteration Level 7] 	[nvarchar](255) NULL,
[Area Path] 		[nvarchar](4000)NOT NULL,
[Iteration Path]  	AS ([Area Path]),
[Changed Date] 		[datetime] 	NOT NULL

About the Author

Jeff Levinson is the Application Lifecycle Management practice lead for Northwest Cadence specializing in process and methodology. He is the co-author of "Pro Visual Studio Team System with Database Professionals" (Apress 2007), the author of "Building Client/Server Applications with VB.NET" (Apress 2003) and has written numerous articles. He is an MCAD, MCSD, MCDBA, MCT and is a Team System MVP. He has a Masters in Software Engineering from Carnegie Mellon University and is a former Solutions Design and Integration Architect for The Boeing Company. You can reach him at [email protected].

comments powered by Disqus

Featured

  • Black White Wave IMage

    Neural Regression Using PyTorch: Training

    The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.

  • Microsoft Ships Visual Studio 2019 v16.9 Servicing Baseline Release

    Microsoft is urging enterprises and professional coders to standardize on the new Visual Studio 2019 v16.9, a servicing baseline release that's guaranteed to receive official support for an extended period.

  • Microsoft Extends Low-Code Push with Power Fx Programming Language

    "Using formulas that are already familiar to hundreds of millions of users, Power Fx allows a broad range of people to bring skills they already know to low code solutions."

  • Microsoft's Tools to Fight Solorigate Attack Are Now Open Source

    Microsoft open sourced homegrown tools it used to check its systems for code related to the recent massive breach of supply chains that the company has named Solorigate.

Upcoming Events