August 15, 2009

Preparing for vacation

Going on vacation next week starting to prepare...unfortunately I might still have to work! Really, can I get a vacation with no work..please.

August 14, 2009

Powershell 2.0 for Vista/Server 2008 - RC

Read about it here.

August 13, 2009

.NET Framework Libraries Open Ref Source

Microsoft has released some of their source code for .NET (such as WCF, ASP.NET MVC, .NET etc) as Reference Source Libraries. This is very helpful in terms of debugging your application. You can find the link here.

August 12, 2009

Powershell Audit Script

I knew I did not have to build it from is a powershell audit script that basically saved me a day or so of work.

Now the good news is that my boss does not know I found something, so I have time to work on my new project outside of work...more details on that later on this blog.

August 11, 2009

Excel C# Helper

Ever need to work with Excel in C#? It is not fun at all. Here is a helper class for you:
using System;
using System.Collections.Generic;
using System.Text;

namespace JLFramework
class ExcelAgent
Excel._Worksheet _sheet;

int _row;
int _col;

int _defaultInteriorColorIndex;

public ExcelAgent(Excel._Worksheet sheet)
_sheet = sheet;

public void SetDefaultInteriorColorIndex(int colorIndex)
_defaultInteriorColorIndex = colorIndex;

public void Goto(int row, int col)
_row = row;
_col = col;

public void DrawEdge(Excel.XlBordersIndex side, Excel.XlLineStyle lineStyle, Excel.XlBorderWeight weight)
Excel.Range range = CurrentRange;
range.Borders[side].LineStyle = lineStyle;
range.Borders[side].Weight = weight;

public void WriteLine(string text)
_sheet.Cells[_row++, _col] = text;

if (GetInteriorColorIndex() == (int)Excel.Constants.xlNone)

public void SetInteriorColorIndex(int colorIndex)
CurrentRange.Interior.ColorIndex = colorIndex;

public void SetFontColorIndex(int colorIndex)
CurrentRange.Font.ColorIndex = colorIndex;

public int CurrentRowIndex
get { return _row; }

public int CurrentColIndex
get { return _col; }

#region Private methods

private int GetInteriorColorIndex()
return (int) CurrentRange.Interior.ColorIndex;

private Excel.Range CurrentRange
return (Excel.Range)_sheet.Cells[_row, _col];


August 10, 2009

Logparser and Team Foundation Server

Gluegood has posted a really cool tool on this site. In short this tool allows for:
  • Querying and notification of recent work items
  • Querying and notification of the most recent check-ins
  • Querying and notification of check-outs which were over a time threshold
  • Querying and notification of shelvesets (parked code) which expired a certain amount of time
  • Querying and notification across linked work items
Some of this is available right in Team Server, but some of it does not really exist easily. This tool created will allow for all the above and will get you to learn some cool new features of Team Server.

August 9, 2009

Procdump instead of debugdiag

This post on the IIS blog is interesting.