Monthly Archives: December 2011

I was doing some SQL work today and was trying to insert a few thousand records into a user defined table type that would then be passed to a stored procedure to be operated on. The data was really simple: Id, ModuleId, Code.  The primary key was a composite key across all 3 fields.  To ...

In my last post, I had tried to post some code but could not get it to work.  I thought I would use Gist to show it.  Even though I’m more of a Bitbucket type of guy than a Git guy, all the cool kids are using Gist.  The problem was, Tumblr didn’t like me trying ...

I recently started working on a new DAL during my day job.  We’re using PetaPoco for the most part, and we have it separated out into it’s own assembly.  One reason we did this was because we foresee needing this in multiple projects, possibly even creating a service.  After I got a test case working ...

The big sports news this weekend is that Albert Pujols did not stay in St. Louis, but instead accepted something like $230 million dollars to change teams.  I really don’t care about the Cardinals (when I care about baseball, I cheer for the Royals.)  I do remember seeing Pujols play in Peoria, IL back in ...