Category Archives: software

Small Business Server 2008: no ISA Server, no built-in tape backup

I have caught up a little with what is coming in Small Business Server 2008, code-named Cougar. Short version: Microsoft is focusing on ease of use but omitting some of the features that made previous versions attractive. This will be an upgrade headache if you used those features.

The new version is 64-bit only and includes Exchange Server 2007, Sharepoint Services 3.0 and WSUS (Windows Server Update Services) 3.0 as standard. Go Premium to get SQL Server 2008 and a license for a second server (which can be 32-bit).

Program Manager Sean Daniel says in an interview (video) that the install is easier than before, and that wizards are scenario-based rather than task-based. I think this means that more decisions are taken for you. However, two changes have caused some consternation.

The first is that tape backup is no longer built in. The new backup system only supports external USB or FireWire drives. I’m not sure about backup over the network; it would be silly to omit this, but who knows? It is based on differential backup, which means you can backup in 10 minutes and do it every hour if you like.

Microsoft says this is because external drives are cheaper than tapes, and that most SBS users have moved to hard drive backup in any case. This is true unless you have a lot of tapes. However, tape advocates point out that tapes are more robust in transit and safer for archiving. Personally I’ve had problems with the cheapest bus-powered external drives, mainly because of the power being inadequate, but I’d hope that up-to-date hardware fixes this. If you still love tape, the solution is to buy a third-party tape backup system.

The other big omission is ISA Server, Microsoft’s firewall and proxy server. This is a bigger deal. ISA is a complex but sophisticated product that requires two network cards to be installed. If you can work out how to administer it, it provides extra security in conjunction with an external firewall, and numerous features for publishing internal servers and services. Why has it been dropped? Daniel makes a curious comment in this Q&A:

I am as disappointed as you with this. Certain circumstances with the changes in Longhorn server left us without firewall solution in our standard product. We attempted to move ISA into the standard product, but legal issues prevented this. There was nothing we could do.

Legal issues? This is a Microsoft product bundled with a Microsoft product. I wonder if he means internal politics?

In particular, note that there is a new multi-server bundle called Windows Essential Business Server 2008, which does include ISA.

So what do you do if you have a full-works, dual-NIC SBS 2003 box and want to upgrade? There’s no in-place upgrade, because this is 32-bit to 64-bit; and the disappearance of ISA means you have to rethink your network architecture, or upgrade to the aforementioned EBS.

Two things disappoint me here. One is that Microsoft is pushing small businesses towards multiple servers, in SBS Premium or EBS. Although this has administrative advantages, it’s not very green, it’s losing the essence of what SBS was about, and seems out of tune with the more general industry move towards fewer servers and virtualization.

The second disappointment is that Microsoft seems to be pretty much ignoring the cloud. I may be wrong: the blurb says “Integration with Microsoft Office Live Services Small Business”, though I’m not sure what this amounts to. Personally I reckon the cloud is the future for the niche that SBS fills. I’d design SBS Next as a local cache for cloud services.

Help! My app only works maximized

A built-in feature of Windows Forms applications is that the main window remembers its size and position. Normally this is an OK feature. If you had your app sized small and in the bottom left of the screen last time you used it, it opens at the same place next time.

Unfortunately, perhaps because of a bug somewhere in Windows or somewhere in Windows Forms, this can go wrong. What happens is that somehow your app saves negative position coordinates and in effect disappears. The application icon appears on the taskbar, but if you click on it the app still doesn’t appear. The workaround is to right-click the taskbar icon and choose Maximize. Then the app appears full-screen. However, you can’t resize a maximized app, and when you hit “Restore down”, your app disappears again.

One possibility is to figure out where the app writes its old position. Somewhere in the registry, or in an XML config file somewhere? You tell me. So here’s another workaround. Display the app normally, so you can’t see it but it isn’t actually minimized. At this point, the focus is on the app. Hit Alt+Spacebar to display the window menu. Because of some quirk in Windows, this seems to appear on the visible screen, even if the rest of the app does not. Now press M for “Move”, hold the left mouse button down, and drag the app to where you can see it. Sounds strange? Sure, but it worked for me. Thank goodness for keyboard shortcuts.

Microsoft Softgrid: virtualization for applications

At Microsoft’s Heroes Happen Here launch, I caught up a little with something to which I’ve paid insufficient attention: Microsoft Softgrid, which is described as Application Virtualization. Softgrid is a way of packaging an application and its dependencies into an isolated bundle that runs on the client, but hardly touches the client environment. Each application has its own virtual registery, DLLs, COM DLLs, and even a virtual file system. As a consequence, it “just works”. It also lets you run otherwise incompatible applications side by side. For example, you could have an old Access 97 application, for which the developer left long ago and nobody dares to touch the code, and run it alongside Access 2007. This is apparently a huge hit for Microsoft, which does not surprise me as it solves all sorts of deployment problems. Unfortunately it’s not that easy to get Softgrid: you need to sign up for a thing called the Desktop Optimization Pack for Software Assurance and it is hooked to other components of Microsoft’s enterprise server system:

I would like to see Softgrid’s technology also made available for more general use.

Technorati tags: ,

Adobe AIR now available; not just consumer fluff

Adobe has released AIR and you can download the runtime and SDK now, as well as FlexBuilder 3, the official IDE for AIR. Just to remind you, AIR is a way of running Flash applications on the desktop, supplemented by SQLite, a fast local database manager.

Among the most interesting case studies I’ve seen is from LMG, which runs loyalty schemes including the Nectar card and Air Miles. The big deal for the retailers is that using your loyalty card lets them identify who is buying what, providing mountains of data which can be mined for trends and the like. I do mean mountains. Nectar is used by Sainsburys. Between 25 and 40 million “basket items” are added to the database each day, and the database holds 2 years of data.

LMG’s Self-serve is an app in development which enables Sainsburys and its suppliers to analyze this data; it could potentially be used by other retailers too. “The application answers questions like how’s my brand performing, who’s buying my brand, what else are they buying,” says Garth Ralston, LMG’s Business Intelligence Development Manager.

Self-Serve is built with AIR and Flex. “Excel spreadsheets, which some of our competitors use, and the pie charts than you can create within them, are so 1990’s”, says Ralston. “We’re looking for a little bit more of the Wow factor.”

A couple of things particularly interested me. One is that SQLite is critical for the app, which works by downloading large chunks of data and manipulating it on the client. This means that Self-Serve would not work as a browser application, unless possibly with Google Gears, which also uses SQLLite. Another is the importance of offline working. “The ability to have a user run the app, run a report, download the data to their system, take the laptop on the train and continue to work is an absolute business requirement”, says Ralston.

James Governor, Redmonk analyst, told the press that BMC will be using AIR as a front-end to integrate its mainframe management offerings, and SAP will be using it. “Frankly, I think this will be the front-end for all SAP business applications,” he said. In other words, AIR is not just consumer fluff.

Governor is just back from Sun, as I am, and while I was there I picked up some anxiety at the way Flash and now AIR are doing what Java was intended to do – provide a rich cross-platform client. Has Adobe stolen Sun’s market? “Sun is quite capable of stealing its own market”, he said. “Java just hasn’t delivered the kind of rich desktop experiences that we would expect and hope.” That said, note that FlexBuilder is a Java application, Adobe’s server-side LiveCycle data services are Java, and Adobe’s ColdFusion runs on Java, so there are pros and cons here for Sun’s technology.

Actually, I suspect you could build Self-Serve in Java without much difficulty. The big win for AIR is that it’s home territory for multitudes of Flash designers. This is as much about designer and developer communities as it is about technology. The same applies to Microsoft’s Silverlight, which is ideal for Visual Studio developers to whom Flash is foreign.

I still have reservations about AIR, though there is also much to like. It’s early days of course; I’m looking forward to trying it for real. I also love the way these new initiatives are making us rethink the design of essential applications that have remained essentially unchanged for years.

Fixing Windows Media Player after a system upgrade

A while back I upgraded my motherboard. Windows Media Player seemed fine – in fact, it works quite a bit better with the faster CPU – until today, when it started crashing shortly after starting. The faulting module was Indiv01.key.

The solution is in this thread. On Vista, what you have to do is to delete the contents of the folder C:\ProgramData\Microsoft\Windows\DRM (not the folder itself). Note that this folder is invisible by default. In Explorer – Folder Options – View, you have to check Show hidden files and folders, and uncheck Hide protected operating system files.

Observe the caveat:

Note that anything recorded on the old system that is DRM protected will not be playable after this procedure.

I recall doing something similar to get BBC iPlayer (download version) working.

This is all to do with tying DRM to hardware. You are not meant to copy a protected file to another PC and still be able to play it. There used to be a method for backing up and restoring your licenses, but it seems to have gone in Vista. From online help:

This version of the Player does not permit you to back up your media usage rights. However, depending upon where your protected files came from, you might be able to restore your rights over the Internet. For more information, see the question in this topic about how to restore your media usage rights.

This leaves a few questions for Microsoft to consider:

  • Why does a DRM problem break Windows Media Player even when playing non-DRM content?
  • Why does a DRM problem cause Windows Media Player to crash, rather than reporting a DRM problem?
  • Why does the user have to uncheck a box in Explorer options that says “Recommended” and warns you that you may make your computer inoperable, in order to fix a common problem? I mean “Hide protected operating system files”?
  • Is it acceptable to say, “you might be able to restore your rights”, when a user could in theory have thousands of pounds invested in DRM-protected content?

Fortunately I don’t have any DRM-protected content that I am aware of.

Everything is fine now.

How long should it take to set up a laptop?

So you need a new laptop. Ignoring those irritating voices that say you should go Apple, you select a value-for-money offering from one of the big names like Toshiba or HP, hit the buy button at Ebuyer or the like, and a day or so later a van is at the door and you have your shiny new laptop. You slit the tape, pull the thing out of the box, plug it in and turn it on. How long should it take before you are happily typing away in Word or enjoying a DVD?

The answer I guess is as short a time as possible. In principle, I don’t see why it should take more than 5 or 10 minutes. The manufacturer has pre-installed the operating system and can ensure that all the right drivers are in place.

Here’s what actually happened when I did this for a friend yesterday. Toshiba Satellite Pro A200 with Vista Business. Not a bad machine, great value. We also had a key to activate Office 2007, which came pre-installed as part of Microsoft’s Office Ready scheme.

I started mid-morning. Turned on. It takes ages before it lets you in. I lost count of the reboots. There is some sort of partitioning dance, then when Vista itself starts up it goes through an optimisation process, then various Toshiba and third-party utilities install themselves, sometimes requiring a reboot. I broke for lunch.

After lunch I connected to the Internet. Vista immediately set about downloading updates. Needed reboots, naturally. Then I ran the Office Activation Wizard. Microsoft’s Office-Ready program is great marketing, but fairly annoying, because typically you don’t want to purchase all of it. In our case we had purchased Office Small Business, but not Access. In consequence, you end up with an installation that is partially a trial version, even though you have paid. I’ve heard of this scenario actually preventing a machine from passing “Genuine Office Validation” when trying to download updates from Microsoft. Not a good way to treat customers. The solution is to uninstall the bits of Office you are not actually buying.

At this point I could have declared “job done”, but I knew that it wasn’t. I applied Vista SP1, which takes ages. I applied Office 2007 SP1, which is fairly quick. I removed a few things that I knew would not be needed, like Outlook’s Business Contact Manager.

I uninstalled Toshiba’s ConfigFree utility. This is a thing that is meant to “simplify” managing wireless (and wired) networks. It hijacks Vista’s perfectly good built-in wireless configuration utility. Now, it is possible that ConfigFree genuinely offers some added value, but even if it does this kind of thing is still a nuisance. First, because people like myself know how the Windows version works, and are disinclined to learn the foibles of an unnecessary replacement. Second, because the official item will be maintained and updated through Windows update, rather than at the whim of Toshiba (or whomever).

If you are really unlucky, the supplier of your wireless card, or wireless router, or your ISP, will persuade you to install yet more network configuration software. Once two or three of these guys are fighting to manage and diagnose your wireless connection, you have little chance of connecting successfully to anything.

There there is anti-virus to think about. Personally I reckon the practice of installing trial versions of Norton’s anti-virus suite (or similar) is a disgrace. It makes for a lousy user experience because the first thing you see after enduring setup is a nag screen assuring you that your new computer is insecure. It is a disgrace because if you accept the trial but don’t pay up, you end up with an out-of-date anti-virus utility, which leaves you vulnerable. Let’s not forget that basic anti-virus software is available for free from AVG and a few others – if Toshiba really cared about the security of its customers, it would pre-install that. I have zero confidence in anti-virus software anyway, but this is not the place.

Result overall: three to four hours spent on something that should take a few minutes.

I have a good understanding of the commercial, technical and political reasons for these hassles, and I don’t regard Toshiba as the worst offender. Nevertheless, Microsoft and its partners have failed to tackle the problem effectively, and this is a factor behind Apple’s resurgence. Frankly, Ubuntu and other Linux distros are more fun to install, though with Linux you inevitably end up Googling to solve one or more strange issues so overall it is no better for the non-technical user.

Recently I’ve been working with Windows Server 2008, which is a delight by comparison. The concept is simple: pre-install the bare bones, and make all the features optional. So Microsoft can do it. Why can’t consumer Windows work the same way? Install a clean, fast, basic version of Windows, and then let the user decide what else they require?

Microsoft moves to protect its Office business in format war

Here’s a key snippet from yesterday’s interoperability announcement:

We’re also designing new APIs for Microsoft Word, Excel and PowerPoint applications that will enable developers to plug in additional document formats and allow users to select those formats as their default for saving documents.

Translation: if OOXML fails to get ISO standardisation, and/or if the rival ODF catches on or is mandated by institutions, then Microsoft wants you to keep using Office.

Product Manager Gray Knowlton has a little more detail here.

I’m not clear how extensive these changes are. Presumably it amounts to more than just tweaking the open and save dialogs to enable different defaults. Office applications already let you select from a range of different formats.

A few further comments. First, I’d like to see OOXML standardized. Aggressive IBM-sponsored lobbying has not convinced me this is a bad idea. And yes, I’ve pored over the spec and even done a little development with OOXML. Standardization tends to improve documentation and helps to protect developers from arbitrary changes.

It is interesting to see someone like Patrick Durusau, Chair of incits, coming out in favour of  OOXML standardization [PDF]:

I have seen some attacks on OpenXML saying it is not an “open” standard. I am quite puzzled by those attacks and think that OpenXML makes the case for open development of standards.

Understand that as the Project Editor for ISO/IEC 26300 and the OpenDocument Format TC editor in OASIS, I carry no brief for OpenXML. However, a well defined and publicly controlled OpenXML would be a great benefit for future work on the OpenDocument Format standard so I have no reason to wish it ill.

That does not mean Microsoft has done everything right. Microsoft’s Jean Paoli, now an evangelist for standardization, told me three years ago that OOXML was not suitable to be managed by a standards body. Why the change of heart? Simply, the threat of losing market share to a rival that was standardized. Microsoft had years of unchallenged Office supremacy in which it could have opened up its formats; but did nothing until its profits were threatened.

This should tell us something about the benefits of competition.

Despite Microsoft’s efforts, gains in ODF market acceptance will damage Microsoft Office. It will take more than a few API changes to make Microsoft Office as good an ODF editor as Open Office, which has a family relationship with the rival formats.

Standardization is only a small piece of this puzzle. On the Microsoft side, Office is a decent product with massive market dominance. On the ODF side, Open Office is also a decent product and is free and open source. The fight will still be on, no matter how the standards thing plays out.

Technorati tags: , , , , ,

Contemplating an in-place upgrade to Server 2008? Read this first

Microsoft evangelist Neil Hutson has a detailed post describing what happens when you upgrade to Windows Server 2008. As with Vista, the new upgrade procedure is actually a clean install into which your old stuff gets copied afterwards:

Instead of just installing new versions of binaries over those of an existing computer, the new operating system is installed side-by-side with the older operating system. Then the data and settings are migrated from the older version to the newer version, and then the source is deleted. While this is architecturally more correct and certainly build a clean OS install, this does cause some obvious complications that you should be aware of.  Secondly in Windows Server 2008 the upgrade process is destructive to the pre-existing operating system state.

My instant reaction: there’s enough that go wrong, that a true clean install looks a great deal more attractive.

Technorati tags: ,

How Sun will profit from MySQL

Following my earlier post, I was invited to ask Sun what was the business model behind the MySQL acquisition. We’ve just finished a Q&A session with Sun’s CEO and president Jonathan Schwartz. I didn’t ask the question because it turned out that I didn’t need to; it was core to the theme.

So what is the answer? It is not straightforward. First off, Schwartz acknowledges that most users of MySQL do not pay for it now, and will not do so in the future. That said, there is money in global support agreements, especially as MySQL and other open source software migrates from start-ups and hobbyists into the Enterprise. That’s answer number one.

He observes though that although only a small minority of users pay for MySQL, they all need hardware on which to run it. So answer number two is that Sun can sell hardware to MySQL users.

The obvious rejoinder is that Sun didn’t need to buy MySQL in order to sell hardware to MySQL users. Now, this is where it gets interesting. There is value in owning the brand. Apparently one of the reasons MySQL allowed itself to be purchased by Sun was to benefit from a much larger sales team and infrastructure, and clearly that team will be offering MySQL plus Sun hardware, so it can improve its share of what we might call the MySQL hardware business.

I’m still not done. Schwartz talked repeatedly about software as community, even saying at one point that Sun could be considered a media company. In response to a tricky question about how Sun had not apparently driven many sales as a result of the huge Java community, Schwartz talked about the mobile phone market. He said that mobile networks do not aim to make money from selling handsets; rather, they will subsidise them in order to gain subscribers. Once they have the subscribers, they work out how to get revenue from them.

Schwartz sees products like MySQL, Java and Open Office in this light. Each download, to him, is a subscriber whom he is “capturing into the community.” Like the mobile networks, Sun will then work out how to profit from that subscriber. So that’s answer number three.

He answers a question about how many “Blackbox” mobile datacenters Sun expects to sell in a similar manner. Most of Sun’s Enterprise customers, he says, are interested in talking to Sun about Blackbox. Most of them will not buy a Blackbox, but as a result of that conversation they will buy something from Sun. Therefore, he does not care about Blackbox sales as such; it is a way of creating a conversation, and the conversation is what counts.

One can only conclude that Sun does not actually know what is the business model behind the MySQL acquisition. It has an almost religious belief that the huge community of MySQL customers, even those who do not pay, will become a source of revenue.

I noticed that Schwartz failed really to answer the point about the poor job Sun has done so far in monetizing the Java community.

Naive, or brilliant? Perhaps both.

Technorati tags: , , , ,

Sun’s Media Summit

I’m at Sun’s Media Summit in San Francisco for a couple of days. It follows an analyst week, which prompted this great post from James Governor: Strong Leaders, Strange Bedfellows and The Art of War by Sun Two. Here’s a sample:

Jonathan [Schwartz] is quiet, understated and concentrates on running the business, rather than running down the competition. He may not have the raw charisma of his predecessor Scott McNealy but in my opinion he is a just as strong, if not a stronger character.  His decision to shell out a billion dollars MySQL also shows he is extremely ballsy – Wall Street is finally coming round to the idea of Sun as a going concern rather than a basket case, and what does Jonathan do? He goes and buys a little company from Sweden that builds an open source database which pretty much no one actually pays for.

So what would you ask Sun? Let me know, and if you’re quick I’ll try and get the question in.