Friday, May 30, 2008

[sql] Delete rows with join to another table in SQL Server

The non-obvious part is that you have to put the table name twice -- after the "delete" AND after the "from".



delete [TargetTable]
from [TargetTable]
join [JoinTable] on [TargetTable].[Column] = [JoinTable].[Column]

Monday, May 26, 2008

[outing] Memorial Day

Sunday 2008 May 26 @ Casa de Lang

- Me to Pierre: "I bet you there is a California City"
- Pierre to Steve: "I lost the bet and you have to get in the boat with me" (or was it under the bus?)
- Killer asian-styled pulled pork by Maureen
- Loving that Maureen took the recipe and crossed out half the instruction. I am not the only one!
- Shrimp, scallops, sesame noodles, gyoza, chicken wings
- Sangria, Veev, Tunnel 88, Patron, Bicardi, Grey Goose, JD
- What can you do with fun-sized kit kats, plastic cups, coffee straws, plastic utensils, and permanent markers? You can decorate pierre
- Mike's secret Yoga skills
- Who knocked over the telescope?

[quote] John Wooden on Team Work

"A player who makes a team great is much more valuable than a great player."

- UCLA Coach John Wooden


It's a wonderful quote on team work, but I'd like to offer a small edit. No where near as clever as the coach, but guaranteed to be true.

"A great player who makes a team great is much more valuable than a great player."

Saturday, May 10, 2008

[tools] Local IIS Webserver in 3 min

For some reason I was under the impression that running IIS on my local machine was gonna be a giant $ license + install ordeal. Thanks to Scott, who happened to inquire why I'm working at the office on a Saturday, to which I explained I couldn't stand the file save lags on to the dev server over VPN, who then pointed me to get IIS running on my machine.

Took all about 3 min.

Add IIS Component:
> Go to Start ... Settings ... Control Panel
> Click on "Add or Remove Programs"
> Click on "Add/Remove Windows Components"
> Check "Internet Information Services (IIS)" --- Just 13.5 MB!
> Click [Next]
> Watch the "progress bar dance" --- Less then 3 min.
> Close everything

Enable directory browsing:
> Go to Start ... Programs ... Administrative Tools ... Internet Information Services
> Click on + sign to until "Default Web Site"
> Right click on "Default Web Site". Click "Property"
> Under "Home Directory" tab, check "directory browsing", and change file root to whatever you want. Default is "c:\inetpub\wwwroot"

> Enjoy http://localhost

That sure all seems pretty darn obvious after the fact!

Now I can go home.