Scott Swigart over at 3Leaf has posted a blog entry titled “SQL Express: The Little Engine that Could”. In it, he shows how the great new capabilities of SSE can be used by VB6 developers instead of Jet (Access) databases.
My only response to this is “yup!” <g>. SQL Server Express is one of the projects I’ve most enjoyed working on in this release. The ability to have a database that is XCOPY deployable, that can be connected to via a file path, that will run as Normal User and needs no upgrading to work under SQL Server is awesome . Before I came to Microsoft, one decision we often had to make was how to support both local data stores and SQL Server as the application grew or moved to a larger office. SSE now gives us the best of both worlds – the ease of Access or Fox data files, with the simple movement to SQL Server.