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.

Powershell 2.0 for Vista/Server 2008 - RC

Read about it here.

.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.

Powershell Audit Script

I knew I did not have to build it from scratch...here 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.

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)
              SetInteriorColorIndex(_defaultInteriorColorIndex);
      }

      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
      {
          get
          {
              return (Excel.Range)_sheet.Cells[_row, _col];
          }
      }

      #endregion
  }
}

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.

Procdump instead of debugdiag

This post on the IIS blog is interesting.