Using a CTE for Heirarchical Query

A project I did a few years back was for a large company with thousands of employees.  The project was essentially building a system to allow managers to evaluate employees and give them quarterly bonuses.  […] Read More

Free IT Subject Webcasts

Through Steve Lamb’s blog, I found IT Conversations.  Just briefly reviewing what they have, looks like a great place to go to learn some things through the old headset.  Steve mentions security, but they have […] Read More

Snippet Compiler

I’ve used the Snippet Compiler from Jeff Key in the past, but “lost” it for about a year.  I recently rediscovered it through Scott Watermasysk’s blog.  A great tool for writting little snippets (hence the […] Read More

MyGeneration Released

On another project at my current client the developers decided to use a code generation tool to help them save some time.  They ended up using MyGeneration, which at the time was in beta, to […] Read More

SCHEMABINDING Option

I’ve never run into the situation where I was worried about a table being accidentally dropped (maybe I should have been?) as I usually let a good security model restrict that.  But, accidents do happen. […] Read More

Select DISTINCT in a DataTable

Just a quick bookmark…Found this posting by Sahil Malik on how to implement a SELECT DISTINCT from a DataTable.  It required the table to be sorted, but it’s a good start.

Zipcode/Postalcode Validation

My current client has customers that are located all throughout the world, but the majority of which reside or work in the US, Canada or the UK.  We recently had a situation where a user […] Read More

Research Your House

I’m terrible with names.  So much so that if I don’t use it on a daily basis I’ll more than likely forget it within a couple of days.  Such is the case with my neighbors.  […] Read More

What’s the Population of Madagascar?

Beats me. But I found a really cool site that will tell you.  And the best part is, it’s paid for by our tax dollars. It’s called The World Factbook and is put together by our […] Read More

Is Your Fourth Grader a Criminal

The whole “school violence” and political correctness of this world is really getting to me.  As a father of two it’s getting close to being frightening.  Not that I’m worried my kids will be the […] Read More