check-tfspolicies.ps1 – sanity check your checkin policy types

I thought I would have done something more significant for my 100th blog post.  Ah, well, maybe for the 200th. I was coding an example checkin policy from scratch last night (1am insomnia, and I had already caught up on my TiVo’d Colbert Report episodes) and had screwed up something in the authoring.  I had registered the…


The TFS "extranet" ISAPI filter mechanics

What’s this ISAPI filter chupathingy you’re talking about? Here’s some background via links: The quick version?  The filter lets you support/require Basic (or Digest) authentication for particular clients (usually ones coming “from the internet”).   Why do you need to use Basic or Digest, though?  What’s wrong with good ol’ NTLM…


Maximum Capacity numbers for SQL 2005

This came up during an internal thread and I found the data interesting, so I wanted to pass it along. SQL Server 2005 Books Online  Maximum Capacity Specifications for SQL Server 2005  The following tables specify the maximum sizes and numbers of various objects defined in Microsoft SQL Server 2005 components. […]


ping-db.ps1 – quick ping to see if you can talk to a database instance

Very simple, just contact a SQL Server instance to see if it can do the CPU-heavy calculation of 2+2 🙂  I put this together just to verify that I could use server=hostname,port when connecting to a SQL Server instance on a particular port.  param( [string] $serverName = $(throw ‘serverName is required’) ) $connectionString = “Server=$serverName;Database=master;Integrated…


getting the xml for running tfsreg.exe

The TfsReg.exe utility lets you change the URL’s that are registered with TFS (tells TFS how to access version control, work item tracking, reporting services, sharepoint, any third-party tools that have registered, etc.).  The biggest problem is usually in getting that “clean” xml that represents the current state of your server, so you can edit…