• 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

    Weekly linkage

    Down to six hundred sixteen unread Google Reader items! Here are some of the coolest of the nearly 200 I’ve read in the last couple of weeks (as well as random surfing, of course): How to Lower Your Heating Bills This Winter – I definitely need to try out lowering our thermostat. We keep it on 72 F in the winter, which we could probably stand to lower by 5-7 degrees if I bundled up more. 9 New High-Quality Free Fonts | Freebies – I really like the Spatha and My Fair Cody fonts on this list. I'm (back-burner) working on a design for charsheet.net, and the styles of those…

  • On Life and Love

    Quasi-daily linkage

    The Tiny Life , Archive » Julie’s Cozy House – This little house — although not terribly little at 410 sq ft, I think — is so pretty. Purple! UX Myths – Great list of user experience myths, with evidence and references. Buttersafe – Family Road Trip – Incredibly cute. Falsehoods Programmers Believe About Names: MicroISV on a Shoestring – Too many of the comments are grumpy and the post doesn't offer any practical solutions, but it's a thought-provoking post anyway. Nonprofit Gym Helps Low-Income Community Get Fit : NPR – I love this. Too bad it's not here in Charlotte; I'd love to help out a group doing this.

  • On Life and Love

    Quasi-daily linkage

    Welcome! – Okay, nevermind on the link below. This intro provides some good insight into the Tiny Living thing, which is more than just 60 sq. ft houses. Not sure that I want to downsize my house in particular, but it's an interesting movement. Tiny House In Asheville – I'm increasingly fascinated by this Tiny House movement (and need to do more research on it), although it initially strikes me as a fairly artificial constraint on living. a series of rants – Auntie Pixelante gives good rants. On a non-game-related note (but relevant), I really should stop saying "fail". If I talk to you in person, help me stop saying…

  • On Life and Love

    Quasi-daily linkage

    10 Usability Crimes You Really Shouldn’t Commit – Nice and easy list to follow. I fixed a silly problem on my site this morning courtesy of the reminder. Clients From Hell : The client calls around 9 PM on a Saturday… – “[very angry] I am reading your email in disbelief. You are the webmaster – how can there be an aspect of our website that you have no control over?” Why You Can’t Work at Work | Jason Fried | Big Think – This is a great video on office workspaces. As an aside, Jason Fried's voice and style of talking remind me a whole lot of Dane Cook.…