• On Life and Love

    SqlBulkCopy Matching Columns

    If you’re trying to do a SqlBulkCopy using a DataTable and getting lots of column type (integer, string) mismatches, it’s probably because you haven’t mapped not only the column types, but also the column names. SqlBulkCopy assumes that your DataTable is going to have its columns in the same order as the database table, which will cause mismatches when it tries to send your (string) Name field into your (int) Age column. Just having your DataTable column names match the table isn’t enough, either. There must be a manual mapping. But if your DataTable column names are the same as the table column names, a simple method can take care…

  • On Life and Love

    1 Damn Percent

    I’m just about ready for a new release of Granny Squares. I did all my tests and development, merged with the master branch, and ran my tests again. And one failed. A trivial case–ensure that there’s one instance of the form in the formset on the main page of the site. It certainly works. But the response object’s context is None, even though the content, status code, etc., are on point. I’m not releasing the damn thing until the tests pass, but it’s a pain the ass, because I wanted to already be full tilt on August’s project.

  • On Life and Love

    Fun Linkage

    Errata Security: Confirmed: LinkedIn 6mil password dump is real – The updates on this are particularly interesting, as he writes about the speed of cracking passwords. Also, I want one of those video cards. An Architect’s Guide to Color – Color is beckoning this season, and one architect is heeding the call with a plethora of new hues to tempt your house's palette. Review: Sufan Stevens, Son Lux And Serengeti, ‘Beak And Claw’ : NPR – I picked up this album on iTunes and have to say that it's as quirky and cool as this review makes it out to be. Linux computer the size of a thumb drive now…

  • On Life and Love

    New Gig: March 19th

    With my contract at Big Corp coming to a natural close (they’re shutting down the site completely), I hopped back into the job market back in mid-February and landed myself a sweet position at Mid-Corp. I start on Monday! There are a lot of things I’ll miss about working downtown: it’s a thriving area, full of people and energy. I also liked taking the bus, despite the occasional shenanigans. Needing a tank of gas once a month or so ain’t bad, either.

  • On Life and Love

    Granny Squares, Now in Color

    Many moons ago, I debuted my Granny Squares Color Pattern Generator, a utility to help crocheters randomize their blankets, which can be a daunting task. I recently got a request for a way to help visualize the blanket that’s generated. It’s hard to work from a list of “r/h/p”-type entries. Not very user-friendly. So I added in a color picker today, and the generator now shows the colors of the squares. As a warning, if you have a lot of very similar colors, the generated image may be difficult to work from. Then again, if your blanket’s in 15 shades of purple (yes, please!), you may not need this utility.