Tuesday, July 15, 2014
I hate enclosed/extra commas in comma delimited files

The end.

posted @ Tuesday, July 15, 2014 11:05 AM | Feedback (0)
Saturday, July 05, 2014
Testing your developer skills – Rewrite some code from a language you don’t know into a language you know

Here’s something that I had to do today, but which it occurs to me is something that I could try to do more often.

I needed to write some code to do X.  For whatever reason, the only sample code that I could find that did X was written in language Y, except that I don’t really know much about language Y.  I didn’t know how to run it or debug it or anything, though I was able to read it enough to see roughly what it did and how it did it, so that I could re-write it in language Z, which in my case is C#.

By doing so, I now know a little bit more about language Y.  I don’t care about language Y, so it isn’t that much of a gain, but it was a slightly taxing test of abilities.

posted @ Saturday, July 05, 2014 10:42 PM | Feedback (0)
Friday, July 04, 2014
Brief review – Pluralsight’s Pragmatic Behavior-driven Design with .Net

I had a much longer review planned initially, but am instead just going to write down a few notes here.

Really short version: do not watch this thinking you are going to learn how to do BDD. 

Rob’s latest entry concerning BDD is really disappointing on a number of levels.  He ‘introduced me’ to BDD through his Kona webcast originally, and so I generally look forward to anything he has to say about the subject, but the overall quality of this online course was pretty lackluster, in many respects.

He starts off strong, pointing out that BDD really has nothing to do with tools or frameworks, which is spot on.

He then undercuts this throughout the rest of the webcast with his use and championing of NCrunch, a tool in search of a need <digression>seriously, I’m sure that someone could make an argument for this tool, but if you are developing such that you need ‘instantaneous’ feedback on whether your tests pass, you are doing it wrong</digression>, that also doesn’t appear to work as expected (there’s a seeming litany of “I wonder if this is working right” comments in the webcast, which seems significantly less polished than many of his previous efforts).

But moreover, a developer dicking around writing code in the absence of clear requirements and interaction with business users is what I would currently consider to be the antithesis of what BDD is all about (and no one gives a shit about emailer code anyway).  There’s nothing worse than a developer designing any sort of significant business impacting code without working with the business.  Ok, I take that back, a group of developers doing this is worse (which I experienced recently).

Some developers seem to regard the end users of the software they write as idiots who don’t know what they are doing.  I understand this, because, let’s face it, sometimes it seems pretty accurate.  But, more often than not, it’s the end users that know what they are doing, regardless of how technologically savvy they may happen to be, and it is they who know what code needs to be written (even if/though they wouldn’t know how to write code to save their lives, but I digress).

To be (somewhat) fair, it would be difficult to create an easily consumable webcast that shows how proper BDD is to be done.  “Hey Bob, how should this software work?”  “Well, Steve, it needs to do thus and so.” “Well, thanks Bob!”  Not very compelling on the face of it.

But, caricatures aside, that is what proper software development is really all about, a collaborative interaction between developers, end users, stakeholders, and the like. 

posted @ Friday, July 04, 2014 4:41 AM | Feedback (0)
Thursday, July 03, 2014
Backing up OSX with Time Machine to a Windows Server

The steps are pretty basic.  This works up to Mavericks, as of this writing.

  1. Tell Time Machine to support unsupported volumes.
  2. Create a sparsebundle
  3. Move the sparsebundle to the unsupported volume.
  4. If necessary, increase the size of the sparsebundle
  5. Mount it
  6. Tell Time Machine that the unsupported volume is the destination
  7. Run Time Machine

This is mainly for me, I’ll update the specifics as I care to.

posted @ Thursday, July 03, 2014 2:08 AM | Feedback (0)
Sunday, June 29, 2014
Microsoft Surface Pro 3 Macbook Air Trade In Value

When it came out that Microsoft was offering up to $650 trade-in value for a Macbook Air to apply to the cost of a new Microsoft Surface Pro 3, I decided to take a look.

I had a 2011 2 GB MBA, and was concerned how much it would bring, but was happy to find I got around $550 for it, so I now have a mid-level i5, 8 GB RAM, 256 GB SSD Surface Pro 3.

Just starting to play with it, I can see things I don’t like as much as with an MBA, but other things that I do like.  The biggest immediate issue is that the screen is very reflective, so I have to pay more attention to ambient lighting, but I think that is manageable.

Minor tip: when setting up the Pen, put the battery in the right way, it tends not to work as well if you don’t.

posted @ Sunday, June 29, 2014 3:53 PM | Feedback (0)
Monday, June 23, 2014
TDD isn’t dead, it’s dumb

DHH had a post about TDD which apparently has raised a lot of comments.  The usual suspects have replied, showing once again they don’t get it (and in this case adding one of the dumber discussions of monogamy I’ve seen in a while….then again, he’s a developer sort, so, you can’t really expect much).

DHH says:

But first of all take a deep breath. We're herding some sacred cows to the slaughter right now. That's painful and bloody. TDD has been so successful that it's interwoven in a lot of programmer identities. TDD is not just what they do, it's who they are. We have some serious deprogramming ahead of us as a community to get out from under that, and it's going to take some time.

I certainly agree that TDD is a sacred cow for some, and a part of some programmer identities, but I most certainly do not agree that it has been “so successful”, going so far as to posit that it hasn’t been successful at all, from almost any perspective.  The vast majority of test suites that I have encountered have been inadequate, unmaintained, meager, or even worse, have created horribly conceived code bases that are based on myopic opinions about testability, as opposed to what makes for well conceived code or properly driven software development.

Uncle Bob’s response is enlightening in ways he certainly didn’t intend, but I want to focus on one thing he says in particular, what he apparently thinks is the most important thing:

If you have a test suite that you trust so much that you are willing to deploy the system based solely on those tests passing; and if that test suite can be executed in seconds, or minutes, then you can quickly and easily clean the code without fear.

Think about this for a minute.

Cleaning code doesn’t even make it into the top five on the list of most important developer practices, and most definitely not even in the top twenty of most important software development practices.

He talks about how clean code allows developers to code quickly, and without fear.  Simply for the sake of argument, I will accept this for the moment.

But being able to quickly code poorly conceived code is not a good thing.  Most importantly, it’s the wrong focus.

Let me repeat for emphasis, it is the wrong focus.

The proper focus involves determining the proper business requirements and executing them. 

Testing itself, properly conceived, is within the top five of most important developer practices, and at least cracks the top ten of most important software development practices.

But TDD, paradoxically, typically (though not always) leads not only to bad code development, but bad testing itself.

To be a good developer, one really needs to stop thinking and being just a developer, and learning the techniques of TDD but abandoning the dogma of it is probably a necessary step in that direction.

posted @ Monday, June 23, 2014 12:09 AM | Feedback (0)
Thursday, March 27, 2014
Date UTC format has zero index months

So, like, if you have January, it, like, is 0, not, like, 1.  And, like, so on.

Just in case you run into this.

posted @ Thursday, June 05, 2014 8:35 PM | Feedback (0)
Thursday, June 05, 2014
OleDbDataAdapter and Excel: Why are some of the column values missing?

Ran into this recently, writing it down in case I forget.

I had an excel spreadsheet that I had been importing for quite a while (meaning, a job that had been working for months on daily submitted spreadsheets) and I wanted to add new columns that were present, so I did all the necessary c# work, but then when I ran the updated project, the values were blank, though I verified they were present in the spreadsheet.

It turns out to be related to the fact that the columns were sparsely populated and how the connection string was set up.  The code will try to ‘guess’ data types and whatnot depending on what it sees in the first few rows, so since the columns I was interested weren’t populated in the first few rows, it was missing them later.

You need to add extended properties, like this:

Extended Properties='Excel 8.0;HDR=YES;IMEX=1'

And it is important to put the single-quotes around them, otherwise you will get a “could not find installable ISAM” error message.

posted @ Thursday, June 05, 2014 11:46 AM | Feedback (0)
Wednesday, June 04, 2014
EF 6 Bug – Can’t share tables across edmx files?

I’m trying to upgrade an application from EF 4 to EF 6 and ran into a number of problems, so I spiked out a simple console app and am seeing the same bizarre behavior.

Using two different .edmx files, using different connection settings, and using custom namespaces, if I try to have each one reference the same two tables, so that they could have those mapped as entities in each namespace, it fails. 

If I run custom tool on the model .tt file one by one, I can see that it will ‘steal’ the entities back and forth, and obviously, when I try to build the solution as a whole, it will choose one of them (reverse alphabetical order?  not sure).

This can’t possibly be right.  Think of a stereotypical eCommerce app.  I will want to have cart entities in a ‘shopping around’ context as well as cart entities in a ‘checking out’ context.  They aren’t the same entities (though they ultimately map to the same tables).  I use earlier versions of Entity Framework to do this as expected.

This can’t possibly be right, I must be doing something horribly silly.

posted @ Wednesday, June 04, 2014 4:06 PM | Feedback (0)
Saturday, May 31, 2014
Visual Studio Build Error: Error to use a section registered as allowDefinition='MachineToApplication' beyond application level

I get this from time to time, and though it is commonplace to me now, I thought I’d blog it just in case I forgot.

Sometimes you try to build your web application and you get this error.  And you haven’t been doing anything with your web.config file, so you know it has nothing to do with that.

Delete the “obj” folder from your solution (it might be hidden since it isn’t technically part of the solution).  For some unknown reason, this causes this error to occur.  Deleting the folder clears the error.

Update: I’m not sure it is the only scenario, but it happens often after publishing.  FWIW.

posted @ Saturday, May 31, 2014 3:16 PM | Feedback (0)