Keith Barrows
Musings on Microsoft Technologies and other technical things
-
SQL Not In Revisited
I always seem to struggle with a NOT IN clause when there are more than one column to compare. This, of course, comes up when I am trying to get records from one set that are NOT IN another set and the comparison has to be done across multiple columns. For instance, if I want to compare table 1 (users) against table 2 (importedUsers) and I want to see if the mandatory fields are there and *NOT* work with those that fail I usually ended up doing a cursor. But - there is a much easier way to do it and it does need a cursor! Thanks to David Penton for pointing me in this direction!
-
SQL XML - TreeView
I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship. There is a great explanation on SQL Server Central on *how* to do this. I am mainly capturing the link and the SQL I just generated to do this. This query will drill down 12 levels at the most. Just alter the case statement (pivot) to go deeper.
-
Microsoft's Velocity - Caching turned up a notch
-
VS 2008 and .NET FX 3.5 SP1 (Beta)
The beta has been released. Scott Guthrie has a huge list of what to expect.
-
ALT.NET?
-
Using multiple config files in one application
I'm supporting an ASP (Application Service Provider) style application for my company. Instead of putting each client's settings into a single config file, I wanted to have the main config file point to each clients configuration. After a bit of digging, I came up with a solution that works. I don't know if it is the best solution but it does work. My main config file now looks like:
-
Latest build of the ASP.NET MVC source on CodePlex
Come and get it! If you are a MVC developer and really want to dig into the core of MVC then go directly to CodePlex and get the code! Scott Guthrie has a LOT more details on his blog.
-
DDD Ireland
Looking for events? Are you in Ireland on May 3rd? What better way to spend a Saturday than at an event with some
funnycharismaticnotable characters like Plip and Sussman! With Plip's permission I've duplicated his blog entry for this event. -
Getting started for the long haul...
I've worked in everything from startups to multi-billion dollar companies plying my trade as a software engineer (head geek, architect, tester, developer, business analyst, janitor, etc). There seems to be 2 defining characteristics that define successful ventures and flailing ventures. One is the individual doing the work and the other is documentation.
-
Microsoft Mix 08
