Frusteration

I have been wanting a cool new phone for quite some time now. I first fell in love with the iPhone (I don’t care that it is not open source). Then like most geeks I know the G1 was my new item to desire. I am half way through a contract right now with AT&T and they will not let me get the iPhone at the discounted price. Being in the contract means that I can’t switch over to TMobile to get the G1 either. Bummer huh.

Last night my wife and one of our friends went to a party. While there I met a girl that has a 3G iPhone that she has only had for about a month. She said that she would rather go back to her old phone and that she would sell it to me for $100. That is a heck of a deal right? The sad thing is that I don’t have $100. 3 kids are depending on us to have a good Christmas this year. On the other side of that coin my wife said that she wasn’t sure that even if we did have the money to get the phone that we may not have the extra money each month to pay for the iPhone data plan.

It sucks so bad being a poor geek

IIS ODBC Logging (the way that works)

This post is mainly for my benefit (it may help others too).

I was asked at work to turn on IIS logging to an ODBC connection. I did a little Googleing and found this site http://support.microsoft.com/kb/245243. Microsoft recommends that you do not do this though because on a heavily used site it can cause performance issues. They appear to be so against the idea of doing it that the script that they provide in %Windir%\System32\Inetsrv does not work. The rest of the steps on that site are correct though. Here is the script that I used to create the table that will actually allow the logging to work:

CREATE TABLE [InternetLog] (
	[LogTime] [datetime] NOT NULL ,
	[ClientHost] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[service] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[machine] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[serverip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[processingtime] [int] NULL ,
	[bytesrecvd] [int] NULL ,
	[bytessent] [int] NULL ,
	[servicestatus] [int] NULL ,
	[win32status] [int] NULL ,
	[operation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[target] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[parameters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[username] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_InernetLog] PRIMARY KEY  CLUSTERED
	(
		[LogTime]
	) WITH  FILLFACTOR = 90  ON [PRIMARY]
) ON [PRIMARY]
GO

With any luck we will just turn this on when it is needed and not leave it running all the time.