I was in a customer meeting today with David Portas of Conchango who is hard at work doing battle with the new FileStream data type in SQL Server 2008. He is developing a solution where large filestream objects are being pushed around a site from central servers to roving laptops. Curiously, he’s using SQL Server 2008 Express on the laptops for a number of reasons:
I could also add spatial support to this list but while there is also support for all the new 2008 data types in Express, in this solution would spatial analysis not be that much useful.
I cannot be more specific about the actual application at the moment but it does give you an indication of the sort of use to which SQL Server Express can be put in an enterprise solution.