Collation Got Me

21. December 2011 Howto 2
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 ...

Hello there Posterous

17. December 2011 One-Time 0
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 ...

A New PetaPoco Glimpse Approach

15. December 2011 One-Time 0
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 ...

Loyalty is a Two Way Street

10. December 2011 Uncategorized 0
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 ...