All posts by onlyconnect

.net, microsoft, visual studio, web authoring, windows

Hands on with ASP.Net Membership, SQL Express and Server 2008

2 Comments

Is it worth using the built-in membership framework in your ASP.Net application, or should you roll your own? I’ve been trying it out recently, and I have mixed feelings.

On the plus side, it does get you up and running quickly with user login and role-based permissions, saving time and possibly achieving more reliable results, on the grounds that Microsoft and countless other users should have found and fixed any bugs by now.

One the negative side, there are annoying limitations. The most obvious one is that a user as defined in the framework only has a minimal number of fields, not including information you probably want to store like first and last name. You are meant to fill this gap by using profiles, another ASP.Net feature which lets you store arbitrary name-value pairs in a database as a kind of persistent session. That works, but the way profile properties are stored makes it hard to do things like sorting users by last name. Therefore, you will probably end up managing your own user database and joining it to the membership system with the user ID, at which point you begin to lose some of the benefits.

Some of the supplied controls, like the CreateUserWizard, seem rough-and-ready too.

Still, the real fun began when I tried to deploy my demo app to Server 2008 and SQL Server Express 2008. By the way, make sure you install .NET Framework 3.5 SP1 and Windows Installer 4.5 before installing the latest SQL Server Express, otherwise the setup spends ages unpacking its files and then exits with a brief message. I got there eventually, copied my application across, and optimistically tried to run it.

When you debug a web application in Visual Studio, it defaults to a SQL Express database in the App_Data folder within the web site, attached on demand. In theory, that should make it easy to deploy to another machine with SQL Express installed: just copy it across, right? There must be a way of getting this to  work, but it seems a lot of people have problems. I got the message:

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

This makes sense, insofar as ASP.NET runs as this user. I temporarily attached the database and added the login, to be rewarded with a different and more perplexing error:

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.

A quick Google shows that many users have suffered from these errors, and that a large number of remedies have been proposed. I abandoned the idea of attaching the database on demand and set up a new database, made ready with Aspnet_regsql. I still got one or other of these errors.

Eventually I realised that my application was using more than one connection string. The problem is that the membership framework uses three different "providers", one for membership, one for roles, and one for profiles. By default in IIS 7.0, these all use an attach-on-demand connection string, defined as LocalSqlServer, and inherited from machine.config buried deep within your Microsoft .NET Framework system folder. In order to prevent ASP.Net membership from using this, you have to override all three providers in the web.config for your application. There’s an example in this article from ISP MaximumASP. I wish I’d come across it sooner; but my demo works fine now.

adobe, flash, internet, silverlight, web authoring

RIA plug-in stats: Flash dominates

3 Comments

I’ve just come across riastats.com which has statistics on which RIA (Rich Internet Application) plug-ins are installed on which browser.

The stats are from a relatively small sample: it claims to have analysed 1.5 million browsers across 42 sites at the time of writing.

The headline: Flash is on over 97% of browsers; but only 52% are at version 10. Java is on just under 75%, while Silverlight can only muster 20% penetration.

I also noticed that Firefox (25%) users are more likely to have Silverlight than IE (20%). Maybe all those locked-down corporate desktops.

Another snippet: less than 30% of Linux users have Sun’s Java plug-in installed.

Microsoft can take some comfort from the direction of the graph. In December 2008 only 15% of browsers had Silverlight. That’s pretty fast growth.

Still, the bottom line is that if you want to be fairly sure that your users have nothing to install in order to view your RIA content, use Flash. But stick to version 9.

google, internet, search, Uncategorized

Latest steps in the Google dance: brands, or not?

There’s a buzz in the SEO community about an update which the search company has made to its algorithms – though Google’s Matt Cutts calls it a change, if you can figure out the difference, albeit one important enough to have a name within the company – it’s “Vince’s change”, after the employee who contributed it.

According to SEO guru Aaron Wall  it is related to CEO Eric Schmidt’s comments last year that the Internet is a “cesspool” of false information. Big idea: promote trusted brands in the search results to ensure quality in the top hits.

As usual with Google, it’s hard to discern whether this is a big deal as Wall claims, or a minor evolution as Cutts presents it. Still, it is worth a few observations.

First, it seems obvious that Google’s original big idea, pagerank based on incoming links, is becoming less and less useful. It has been killed first by the SEO industry itself and its unceasing link farms and exchanges, and second by Google’s promotion of the “nofollow” attribute, which ironically means that many of the best incoming links are now supposedly ignored, while the SEO folk ensure that low-quality links which are not tagged nofollow abound.

That being the case, Google has to look for other ways to rank sites. According to Cutts, there are three things (in addition to pagerank) that it tries to identify: trust, authority, and reputation.

The brands idea is an easy solution. Prefer the well-known names; that way you may not get the best content or the best price; but at least users generally won’t be scammed.

The potential consequences of this kind of thinking are far-reaching. It is undermining one of the Web’s key attractions, which is low barriers to entry. If SEO becomes a matter of building a big brand, it is no different than the old world of big-budget marketing campaigns (and perhaps that should not come as a surprise).

The other twist on this is that users searching don’t necessarily want the big brands. Rather, they want the best information. Further, if a user wants to find a big brand on the Web, it does not need Google to do so. If Google goes too far in promoting familiar names above the best content, it leaves an opportunity for other search engines.

I think Google is smarter than that. Nevertheless, the problem which Schmidt refers to is real, and I reckon that barriers to entry on the Internet are rising and will continue to do so.

The power Google exerts to make or break Internet enterprises and to influence the flow of information is downright spooky, mitigated by the fact that it does an excellent job as far as I can tell (and there lies the rub).

Finally, one tip for Google. Scrap nofollow. It was a bad idea, for reasons which only now are becoming obvious. If I were building a search engine today, I would take little or no account of it.

PS great comment from @monkchips on Twitter just as I posted this entry:

for my purposes google search has actually become less useful over time. Now its kind of like a mall of corporations

.net, adobe, google, iphone, microsoft, ruby, silverlight, software development, web authoring

Programming language trends: Flash up, AJAX down?

5 Comments

I’m fascinated by the O’Reilly reports on the state of the computer book market in 2008, particularly the one relating to programming languages.

Notable facts and speculations:

C# is the number one language, overtaking Java (which is down 12%), and was consistently so throughout 2008. Although the .NET platform is no longer new and exciting, I’m guessing this reflects Microsoft’s success in corporate development, plus the fact that the language is changing fast enough to stimulate book purchases. Absolute growth is small though: just 1%.

Objective-C is growing massively (965%). That’s probably stimulated by iPhone app development more than anything else. It’s a perfect topic for a programming book, since the platform is important and popular, and attracting developers who were previously ignorant of Objective-C.

ActionScript is growing (33%). That’s Adobe’s success in establishing Flex and the Flash platform.

PHP is up 3%. I’m not surprised; it’s usually the P in LAMP, everyone’s favourite free and open source web platform. That said, the online documentation and community support for PHP is so good that a book is less necessary than for some other languages.

JavaScript is down 24%. I’m a little surprised, as JavaScript is still a language everyone has to grapple with to some degree. It may be a stretch; but I wonder if this is a symptom of AJAX losing developer mindshare to Flash/Flex (ActionScript) and maybe Silverlight (C#)? Another factor is that JavaScript is not changing much; last year’s JavaScript book is still good enough.

Visual Basic is down 15%. Exactly what I would expect; slow-ish decline but still popular.

Ruby is down 51%. This is a surprise; though it was well up in 2007 so you could be kind and describe this as settling. The problem with Ruby though is lack of a major sponsor; plus the migration from PHP to Ruby that seemed possible a couple of years ago just has not happened. It may be intimidating to casual developers who find PHP more approachable; plus of course, Ruby probably is not installed on your low-cost shared web hosting package.

Python is down 14%. Google sponsors Python, in that it is the language of App Engine, but apparently this has not been enough to stimulate grown in book sales. I guess App Engine is still not mainstream; or maybe there just aren’t enough good Python books out there.*

It will be interesting to see the 2009 report in a year or so. Meanwhile, I’m off to write an Objective C tutorial (joke!).

*Update: I was reading the charts too quickly; it looks as if the percentages above are only for the last quarter; the annual figures are similar except that Python actually grew over the year as a whole.

.net, microsoft, mobile, open source, software, software development, visual studio

SharpDevelop 3.0: everything .NET from Boo to F#

4 Comments

I’ve been researching open source .NET and noticed that SharpDevelop, the free IDE for .NET on Windows, completed version 3.0 earlier this month. Congratulations to the team. Along with Windows Forms and ASP.NET applications in C# or Visual Basic, you get extras like support for F#, Boo and Python. Another welcome feature is built-in support for Subversion version control. There’s even an ASCII table in the IDE, which brings back memories: 15 years ago every programming manual had one at the back.

SharpDevelop has two major challenges. One is keeping up with Microsoft; right now there are discussions about improving WPF support, for example. The other is that Microsoft offers free Express versions of Visual Studio, which leaves SharpDevelop with those niche users for whom the Express products are unsuitable, but who do not want to pay for a full version, or who are wedded to some exclusive SharpDevelop feature.

In favour of SharpDevelop, it installs more easily and loads more quickly than Microsoft’s effort, and certainly proves the point that native C# applications do not have to be slow.

A more interesting though less complete product is the forked MonoDevelop, which is cross platform and targets Mono, the open source implementation of .NET. Mono now looks good on Linux; but the idea of WORA (Write Once Run Anywhere) has never really caught on in the .NET world. How many significant Mono applications for Windows have you seen? My guess is that if it happens at all, it will be in the form of Silverlight/Moonlight running in the browser.

Technorati tags: , , , ,
.net, microsoft, software development, visual studio

First screenshots of Visual Studio 2010 UI

1 Comment

Jason Zander has posted some screenshots and info about the new WPF-based UI for Visual Studio 2010.

An early build of VS 2010 was handed out at PDC last year, but lacked the new UI.

Floating document windows is a great new feature. That said, Visual Studio 2008 works rather well; I hope the new version is equally fast and stable.

Technorati tags: , ,
adobe, cloud computing, flash, internet, microsoft, multimedia, silverlight, software, software development, Uncategorized, web authoring

How will Microsoft make money from Silverlight?

6 Comments

Indeed, will it do so? I like Silverlight a lot; though I appreciate that to a Flash developer it may seem pointless. It does a lot of stuff right: small download, powerful layout language, cross-platform (with caveats), rich media, fast just-in-time compiled code.

Still, what intrigues me is how Silverlight has come from nowhere to what seems to be a central position in Microsoft’s product strategy in just a few years. What’s the business case? Or is it just that someone high up experienced a moment of horror – “Flash is taking over in web media and browser-hosted applications, we gotta do something”?

Let’s eliminate a few things. It’s not the design and developer tools. Making a profit from tools is hard, with tough competition both from open source, and from commercial companies giving away tools to promote other products. I don’t know how Microsoft’s figures look for the Expression range, but I’m guessing they bleed red, irrespective of their quality. Visual Studio may just about be a profit centre (though the Express series is free); but Silverlight is only a small corner of what it does.

Nor is it the runtime. Adobe can’t charge for Flash; Microsoft can’t charge for Silverlight.

I asked Twitter for some ideas. Here are some of the responses:

migueldeicaza @timanderson, my guesses:WinServer built-in-steaming;Strengthening .NET ecosystem, and client-server interactions;Keep share in RIA space

IanBlackburn @timanderson Isn’t Silverlight going to become the "Microsoft Client" and central to s+s?  Apps built with it can be charged in many way

harbars @timanderson no doubt with annoying adverts

mickael @timanderson isn’t silverlight a defensive move against other RIA platforms (like Adobe’s one)? They might only plan selling developmt tools

jonhoneyball @timanderson In the long term by hosting tv stations’ internet traffic and providing the charging/hosting/download/player model.

jonhoneyball @timanderson ie azure cloud + silverlight + someone elses content = ms revenue. no, it wont work, but its not unexpected ms-think.

jonhoneyball @timanderson why no work? price war to come on cloud host/delivery etc Someone will host BBC for free. Game over

There are two main themes here. One is media streaming; as the Internet takes over an increasing proportion of broadcasting and media delivery (note recent comments on Spotify) Microsoft plans to profit from server-side services. The challenges here are that there may be little money to be made; Adobe has a firm grip on this already; and Apple will do its own thing.

The other is about applications. This is the bit that makes sense to me. Microsoft knows that the era of Windows desktop clients, while not over, is in long-term decline; and that applies to applications like Office as well as custom business applications. Silverlight is a strong client platform for web-based alternatives. So I’m voting for Ian Blackburn’s comment above: it’s the Microsoft Client.

If that’s right, we’ll see Silverlight embed itself into more and more of Microsoft’s products, from desktop to server, just as Adobe is gradually remaking everything it does around Flash.

The difference is that Microsoft has far more invested in the status quo: selling Windows and Office. I’m guessing that there are heated internal battles around things like Web Office. The briefing I attended at the 2008 PDC on Office Web Applications was fascinating in respect of its ambivalence; for every web feature shown, the presenters wanted to emphasise that desktop Office was still the thing you should have.

Technorati tags: , , ,
apple, internet, itunes, logitech, multimedia

Squeezebox and Napster – the perfect combination?

2 Comments

I’ve just posted a review of the Squeezebox Boom, a lovely device that once set up is perfect for hiding all the computer gunk and letting you enjoy the music wherever you are in the house. During the review I noticed that Logitech’s Squeezenetwork, which aggregates a number of Internet radio stations and music services for use with Squeezebox, announced Napster support last week.

I tried this, and it is amazing, though you do need to subscribe to Napster; trial accounts are available. If I want to play any song or album in Napster’s vast library, I select Squeezenetwork as the music source on the Boom, select the Napster music service, search the Napster library, and play the music. No computer has to be running for this to work. Sound quality is good though noticeably worse than locally-streamed lossless FLAC; more radio than hi-fi.

I’ve also been spending time with Spotify. Like Napster, this makes a huge library available, plus it has a couple of advantages. Performance is better, with near-instant search results and playback; and best of all it is free, if you can tolerate occasional advertisements. Unfortunately Spotify does not integrate with Squeezebox yet, though users are clamouring for it.

The Squeezebox is a schizophrenic product with one foot in the old world of local media storage, and one foot in the new world of Internet streaming via Squeezenetwork. Squeezebox plus Napster is great; Squeezebox plus Spotify would be even better. Either one makes Apple’s iTunes purchase-and-download model look dated.

Technorati tags: , , ,
apple, multimedia

Spotify is the new Napster

4 Comments

I signed up today for Spotify. This is a music service that like all the best innovations can be explained in a few words. You download the client (Mac or Windows), which has a Mac-like user interface for searching and playing songs. You type in a search, double-click a song in the result list, and it plays. When it finishes, it plays the next one in the list.

So far it has worked flawlessly. Performance is the key. Searches are fast, and songs seem to start playing instantly – impressive. Now and again an advertisement plays in between songs – it’s not too intrusive, but for a ad-free experience you can sign up to a premium subscription, currently £9.99 per month or £99.00 per year.

A few technical details: according to the FAQ, Spotify uses both streaming servers and peer-to-peer connections. It also grabs up to 10% of your hard drive (user configurable) for local storage. The codec is “Ogg Vorbis q5 which streams at approximately 160kb/s.”

The selection of music is not comprehensive; last month a number of songs were withdrawn “…so that we implement all the proper restrictions that are required by our label deals.” Nevertheless, the selection is wide and includes many mainstream artists. The latest Lily Allen is there; so is the latest Morissey as illustrated above. A search for Beethoven revealed 9,302 tracks; Mozart 14,148. Most people will find plenty of music they like.

In 1999, Shawn Fanning created Napster, a peer-to-peer music sharing service that allowed users to share MP3 files. It was wildly popular and illegal, and introduced the download era to a mass market. Download is about amassing a collection of music files on local storage and playing them through a computer or over a network. Ripping a CD is really just another way of downloading it.

The company that has profited most from the download era is Apple, with its market-dominating iPod/iTunes combination.

But what is the point of downloading a song, if you can play it just as easily without downloading it? What is the point of “buying” a song, if you can already play it whenever you want? What is the point of ripping a CD in order to make a copy that is identical to copies made thousands of times already, when you can easily access a shared copy over the Internet?

There is none; and all-you-can-eat streaming is the natural successor to the download era.

That does not mean we are there yet. Format changes in recorded music are not instant; there is a long transitional period. You can still buy LPs today; CDs remain a major source of revenue for the music industry; Spotify will not kill iTunes overnight. Audiophiles will not be satisfied with Spotify’s lossy-compressed music format for serious listening.

Further, Spotify has some limitations. Playing on mobile devices is one problem that will not easily be solved, bearing in mind that while broadband internet at home is now widely available, fast mobile connections remain expensive and unreliable.

History also suggests that Spotify will not necessarily be the company that makes this a business success. The music companies might panic and remove their works from Spotify. Apple might buy the company, and/or transition iTunes to a similar subscription-based streaming service. You can be sure it will not stand by and watch as its music business become irrelevant.

Nevertheless, even a day with Spotify is enough to make the idea of only being able to play what you have already downloaded seem quaint and unnecessary.

Technorati tags: , , ,
virtualization, windows

Hyper-V disk I/O: performance of dynamic vs fixed virtual hard disks

1 Comment

The dynamic virtual hard drive is one of the best things about virtualization. It is like Dr Who’s Tardis. The virtualized OS thinks it has plenty of space, while on the host machine your 128GB virtual drive might occupy just 4 or 5GB – this is typical of the test VMs I set up, running say Server 2008 and a server application or two.

Trouble is, there’s a performance penalty. I first came across this with a hilariously slow Ubuntu install, where the problem is made worse by the lack of integration services, the utilities and drivers that install into the guest to enable smooth interaction with the host.

As an experiment, I created a second Ubuntu VM using a 30GB fixed-size drive. Better? Yes, much better. Here are the figures on my admittedly slow low-end HP Xeon server:

Copy an 891MB file:

  • Ubuntu 8.10 on 127GB dynamic drive with 1GB RAM: 6 min 45 secs
  • Ubuntu 8.10 on 30GB fixed drive with 1GB RAM: 3 min 15 secs

As a further test, I copied the same file in Server 2008:

  • Server 2008 on 127GB dynamic drive with 2GB RAM: 5 min 55 secs

My immediate thoughts: you would be crazy to use VMs in production with dynamic drives. Always use fixed drives. You can still expand them manually if necessary. Note that Hyper-V defaults to dynamic drives.

Still, these tests are not extensive or rigorous; I’d be interested in other results. I’ll also be creating my next Server 2008 VM on a fixed drive and will repeat the test there.

I’ve posted some further hyper-v tips and gotchas here.

Technorati tags: , ,