FetchXML Builder for Microsoft CRM

Every now and then, I come across a developer utility that’s worth mentioning. The utility might not be new or even great, but its a tool that I’m able to put to use somewhere to solve a problem or just assist in the problem solving.
The FetchXML Builder by James Downey is a great tool because [...]

Read Full Post »

Halo: The Fall of Reach (Book Review)

I wasn’t too familiar with the Halo series until last year when I played Halo for the first time. I knew it was a FPS (first person shooter) and knew that it involved running around and shooting aliens, much like most other FPS games. Since FPS games weren’t my speciality, I had never spent much [...]

Read Full Post »

The Year 2038 Bug (January 19, 2038)

In about 29 years from today, you’ll be hearing a lot about the 2038 bug. This bug is similar to the Y2K bug, but this bug could actually affect computers more than the Y2K bug.
The Y2K (Year 2000) bug was due using two digits to manage the year value. For example, 99 represented 1999 and [...]

Read Full Post »

How to create a delimited list of values from a one-to-many relationship

Recently, I needed to denormalize a database by putting child records into a single delimited field. For example, the following tables contain source data and the expected output from our function.
The following code is based on Microsoft SQL Server 2005 and has only been tested using Microsoft SQL Server 2005.

Read Full Post »