Command Line TFS Access

There are a couple of useful powershell command-line tools that are of use:

This is useful to query tasks and work items

tfpt query “ProjectPath to query”

From a mapped folder allows the running of existing tfs work item queries from the command-line

It uses the current folders mapping to identify the project.

This is useful for quering checkins:

Run from the VS2012 command prompt:

tf history x:path_to_project /recursive /noprompt /user:”My User Name”

Querying Azure Table Storage

Here is how to generically query Azure Table Storage without having to define the entity that is in the table (which you may not know and can vary).

CloudStorageAccount storageAccount = CloudStorageAccount.Parse(diagnostics);
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable cloudTable = tableClient.GetTableReference(“WADLogsTable”);
TableQuery query = new TableQuery();

query.FilterString = filter;
var items = cloudTable.ExecuteQuery(query).ToList();

See my previous post for how to set the filters.

Why Value At Risk Does Not Work

The financial system is currently using the Value at Risk model.

One of the fundamental assumptions of it is that the trades used are normally distributed. The benefit of assuming normal distribution is that it is well known and easy to calculate. You can’t assume normal distribution. Is the height of a large enough population normally distributed? If you believe so where are the 6m tall humans or those less than 0m tall? These are reasonably expected to exist in a large enough normally distributed population.