February 2007 Blog Posts
Sahil just posted a nice little primer for getting started with the FOR XML clause in sql 2005. Good start, however I feel like he missed a technique.One of my major gripes with working with FOR XML is when you have to join more than 2 tables in your query. FOR XML AUTO tends to create a child node for each join. Say for example you want to show a list of customers, their contact information (address and phone being separate tables) and their order history. With a default join using FOR XML you'll end up with something like this:<Customer...
I think most people who have been in the IT industry for an average amount of time can agree with my perception that for the most part, the consulting industry is garbage. Consultants are expensive, usually on par or worse than your full time employees, and for the most part are willing to bend a client over the table if the opportunity arises. Here's what I perceive as the problems with the mainstream consulting industry and my thoughts on how to make things better.Problem 1: Consultants don't have a large stake in your success.One of the major problems with consultants...
Simple rant, nothing more. Just sent in some immigration papers for my wife, who is a Swedish citizen who came here when we got married. The paperwork carried a $275 processing fee.This brings the total since she came here two years ago to be well over $2,000 plus the time we had to spend apart while they processed our petition to begin with. I can see why immigration reform is necessary from personal experience.That being said I hope people can understand why the illegal immigration/amnesty situation being bantered around by congress really gets under my skin. Here I am, a...