Windows Software "Best Of" Lists
Scott Hanselman updates this list every year. I use 4 of his top-10 utilities on my work laptop (my personal machine is a Macbook Pro). I use TestDriven.NET a lot as well. If you use Windows, the list is definitely worth a look.
A number of the applications Hanselman refers to can be found at Open Source Windows. It’s all really good software with an even better price ($0.00).
Universal vs. Apple on DRM-free Music
A very interesting take on Universal offering DRM-free music directly instead of through iTunes. I think the writer is on target in describing the motives of Universal in cutting Apple out as a distribution channel.
If memory serves, the big record companies tried to push Apple into variable pricing not long ago. That move didn’t seem to work, as the 99-cent single is alive and well on iTunes.
The idea of Apple signing artists directly is an interesting one, but I don’t see Apple signing artists anytime soon. Artist management is quite far afield from what they do best. It might violate their recent deal with Apple Corps too. That said, if Apple could make it easier and cheaper for indie bands to put their music out without violating that deal, they’d probably make some money they aren’t currently getting. It might even help them sell more iPods (which is really the whole point of iTunes anyway).
Improving developers
Scott Hanselman posts a number of great tips for improving development teams. The technical brown bag idea is one we’ve been following at work since the spring. We call them “learning lunches”, and they’ve proven to be an excellent vehicle for knowledge transfer, as well as connecting different offices of the company.
At my current employer and the previous one, I’ve tried to promote conferences, off-site training, and .NET user groups. Getting the staff to attend them has been more of a challenge here than at my last job. They’re all excellent ways of keeping technical skills sharp as well as networking opportunities.
Now that we have a new CIO at work, it will be interesting to see to what degree he’d buy in to some of these ideas.
To rewrite, or not to rewrite?
This question comes up rather often in my job, and this post by Adam Turoff answers the question by including “when” as a variable. In short, the sooner a project needs to succeed, the less likely it is that a rewrite will succeed.
Whenever I come across an application that isn’t designed or implemented as well as it should be, I’m biased in favor of rewriting the application. That approach tends to meet resistance because the “when” is usually very short. Refactoring is a good fallback option, but only if the application is relatively current. My desire to refactor single-tier classic ASP is nil.
Leading by example
I found this post on technical leadership particularly useful because it’s my role at work. Humility, discretion, tact, and willingness to “walk the walk” are necessary to succeed as a leader. The only thing I would add to the author’s list is the importance of patience in leading development staff. You can follow all the advice and still not see changes for awhile. I’ve been in that situation before, and always found it frustrating.
The comments on the post were enlightening as well, particularly this one by Greg Askew:
"Individuals are responsible for fixing themselves. Leading by example is a noble concept, but at the end of the day everyone is accountable for their own performance."The quote is a great reminder that as managers, we can only influence--not control--employees. Askew makes two other strong arguments about hiring and motivation. His latter point is echoed by Steven McConnell's summary of classic mistakes and by Jim Collins in Good to Great. Undermining people's motivation (and/or hiring people who aren't self-motivated) can be counted on to yield a substandard result in the end.
The full article that inspired Jeff Atwood’s post is an excellent read as well.
No parameterless constructor defined for this object.
This error message started showing up during testing of some code changes I made to an application. It took me awhile to figure out precisely what the problem was because the top of the stack trace referred to this:
System.Activator.CreateInstance[T]()As looked further down the stack trace, it ultimately pointed out which class was the culprit, so I added an empty public constructor to and redeployed the result.
I found this post rather useful in diagnosing the problem.
Die patent troll, die!
Thanks to Judge Dale Kimball, we may finally be rid of SCO. Since he ruled that they never owned UNIX patents, they owe Novell 95% of the money they got from Microsoft and Sun for the license rights they sold. It’s doubtful they have the money, so they’ll probably have to declare bankruptcy. It couldn’t happen to a more deserving company.
Refactoring
An excellent post by Julian Bucknall of Developer Express on refactoring–more specifically the eight refactorings he uses most. Of the ones he names, I use the 8th one (use string.format) the most. As you might expect with inherited code, there are plenty of places where strings are concatenated with plus signs. I root them out of every piece of code I rewrite, and highlight them in code reviews.
SQL Server Table Properties
I needed a T-SQL statement to get the created date of a couple of tables as part of a project. One of my colleagues came up with this query:
SELECT create_date FROM sys.objects WHERE type = ‘U’ AND name = ‘<tablename>’
It works in SQL Server 2005.
The SQL Server 2000 equivalent is:
SELECT crdate FROM sysobjects WHERE xtype = ‘U’ and name = ‘<tablename>’
Jeremy D. Miller on Software Teams
His top three preferences in brief:
- internalized discipline over externally-enforced discipline
- coaching over enforcement
- collaboration over direction
Miller does the best job of explaining his third preference. Providing the rationale and context for a course of action gives a developer input and an opportunity to buy into an idea. The success of this approach still depends on the having the right people. I follow it with my own employees as much as possible.
Is Fit Testing Dead?
Jeremy Miller asks that question in this post.
I haven’t had a chance to use it on any projects, but I really like the idea of customer-facing tests. Miller describes them very well as “executable requirements”. The comments highlight a number of alternatives to Fit, including FitNesse, Green Pepper, and ZiBreve.
From the comment volume on Miller’s post, it seems that only the specific implementation of Fit is on its way out. The idea looks very much alive.
Implementing IDisposable
One of the FxCop rule violations I found in one of my projects had to do with IDisposable not being implemented. My search for examples of how to resolve this yielded a lot of helpful links, including these:
- An MSDN article on correct implementation of IDisposable
- A older CodeProject article on IDisposable that takes an odd shot at unit testing
- A newer CodeProject article on IDisposable and the dispose pattern
- A Channel9 discussion on IDisposable
Comma-delimited strings in SQL with COALESCE
I came across a nice how-to post this morning. When it comes to databases, I’m a fan of anything that eliminates the need to use cursors.
ALT.NET-->NOT.NET?
I came across this James Avery post via Mike Gunderloy’s blog. Avery attempts to make a similar point to one Martin Fowler puts forward about the best developers moving away from the .NET platform. Beyond the sort of anecdotal evidence I’ve read, I don’t see much abandonment of .NET as a platform.
When I read this post by Dave Laribee, I decided that Avery missed his point. The point of ALT.NET isn’t as a bridge to a different set of tools, but to recognize two things:
- The best solutions on the .NET platform won't always come from Microsoft.
- The best ideas from other software development communities can work very well on the .NET platform.
Strongly-typed datasets and queries without matching select clauses
I learned an annoying lesson about these late last week. I’d created the dataset by dragging and dropping the necessary tables from SQL Server in Visual Studio 2005. Then I added a query to one of the tables that didn’t include every one of its columns. Unfortunately, a number of the columns my query didn’t return didn’t allow nulls. I ended up modifying my query to include those columns, even though I don’t use them. I didn’t try removing the columns from the dataset, but that probably would have worked too.
Subversion and Team Foundation Server
There’s a Codeplex project that enables developers to use their Subversion clients with Team Foundation Server (TFS). It’s certainly an interesting project, though I don’t quite grasp the rationale. TFS is really expensive, so if a shop can afford it, they can afford Team Explorer too.
I found out about initially via TheServerSide.NET.
Ruby on Microsoft
This piece by Martin Fowler interests me more for his contention that the best technical leaders are abandoning .NET than for what he writes about Ruby. It’s the sort of argument that seems true because anecdotal evidence seems readily available. I’d be interested to see if there’s more quantitative backing for the assertion.
Some poking around on Google did reveal at least a couple statistics:
"Rails.NET" Revisited
It’s been almost a year since I learned about the .NET Action Pack. Since then, the project has changed names (to SubSonic) and switched to using Google Code as a repository (though they still use CodePlex for other things). The team appears to have enhanced it significantly, including the addition of a command-line utility and support for non-web applications. Since we’re short-staffed at work, we definitely need to jump on anything that will generate code for us.
Fun with Settings.settings
Apparently this is where Visual Studio 2005 stores connection strings when you add strongly-typed datasets in an application. Even though I had an app.config file and I’d changed it to point to a new database, I was still getting SqlExceptions when I ran my unit tests. I just didn’t know the old value was still stored in Settings.settings and needed to be updated.