Ranked in these QuestionsQuestion Ranking
Pro Rich developer tools
SQL Server Express has deep integration with Visual Studio, Visual Web Developer and SQL Server Management allowing for ease-of-use and rich table and query designers. It may be the best choice for someone who develops in the Microsoft environment.
Pro Easily manage SQL Server instances
"Manage SQL Server Express databases with SQL Server Management Studio Express. Connect to local SQL Server Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans, and access management and maintenance options."
Pro Easy backup and restore
Can be deployed to all editions of SQL Server and Microsoft Azure SQL Database
With a variety of versions to choose from the SQL Server Express version is free of charge. It is capable of upgrading to higher tiers, but that requires a fee.
Con Hardware limitations
Maximum number of cores: 4
Maximum memory utilized per instance: 1GB
Maximum size: 10GB
This hardware could be limiting with some high profile apps and sites.