October 2005 Blog Posts
MVC Links

Various links about MVC:

posted @ Monday, October 31, 2005 12:44 PM | Feedback (0)
T-SQL: Using arrays and lists

Very comprehensive article:

posted @ Thursday, October 27, 2005 9:32 AM | Feedback (0)
T-SQL: Select where date = max

select t.column1, t.column2, t.column3, from table t with (nolock) where t.column2 like '%AAA%'
and = (select max(date) from table where column2 = t.column2)
order by t.column2

posted @ Friday, October 14, 2005 2:31 PM | Feedback (1)
Perl: Debugger Command Line

perl -d:ptkdb <program name> <variable list>

posted @ Thursday, October 13, 2005 10:03 AM | Feedback (1)
.NET: Can't change Visual Studio .NET Configuration Properties

So I have a project that has something like 15 projects, and sometimes don't want to rebuild all of them.  So I tried to create a new configuration and then choose not to include other projects, but I couldn't change anything.  I couldn't uncheck anything, change a dropdown value, etc.  Why?

Basically, if you have two monitors, there are cases where the popup box is in the 'wrong' monitor.  Move it to the other monitor...voila.  Works.  Why?  Who knows.  At least this work-around works.

posted @ Sunday, October 09, 2005 9:34 PM | Feedback (1)
.NET: Adding a pause

int pauseTime = 2000;

posted @ Thursday, October 06, 2005 12:47 PM | Feedback (1)
The Art of Project Management

A good read:

posted @ Thursday, October 06, 2005 10:42 AM | Feedback (2)
.NET: the property Size has an invalid size: 0

If you are using output parameters with ADO.NET, then you need to explicitly set the size of the output parameter (despite what the documentation says on MSDN). 

posted @ Tuesday, October 04, 2005 10:23 AM | Feedback (3)
Connection String Site

Forget how to write a connection string for a particular provider?  Here's the site for you:

posted @ Monday, October 03, 2005 11:54 AM | Feedback (1)
SQL: Ghost Cleanup


“When rows are deleted from the leaf level of an index, the are not removed immediately. Instead, they are marked as invalid and are called ghost records. Periodically, SQL Server starts a special housekeeping thread that locates and removes the ghost records.”

posted @ Monday, October 03, 2005 10:41 AM | Feedback (1)