Thursday, September 13, 2007 - Posts

If I needed to execute SQL scripts on multiple servers...

...I'd be using Red Gate's SQL Multi Script. The initial "alpha" version is available now for free. I've given it a whirl and it works exactly as advertised, with further improvements in the pipeline too.

At first glance I thought a utility like this would be better off being built into SQL Server Management Studio. After using it (and reading on the forum what other users want it for), I reckon a small, stand-alone product is probably better.

I've been advised that this alpha release will stop working at the end of 2007.

Tags: sql server, database, script, server

A 5-second test for your User Interface

Here's an interesting metric (via Usability in the News) for testing websites:

Q: “What percentage of your interface contains stuff that your customers want to see?”

  1. 10%
  2. 25%
  3. 100%

If you answer a, or b then you might do well, but you'll probably get blown out of the water once someone decides to enter the market with option c.

(continued at "A really simple metric for measuring User Interfaces" at iQ Blog)

This test could easily be applied to utility-type software whether web or windows e.g. Flickr or WinZip (it would be a little harder to apply the principle to fully-fledged applications, where "infrastructure" user interface is impossible to avoid).

37 Signals calls this kind of approach "epicenter design" in its online book Getting Real - start with main thing the user will need, then the second most, then the third, and build outwards.

Tags: user interface, usability, design