Things you can do

Build web and mobile applications for multiple data types

Support structured and unstructured data while storing business data with native support for relational data, XML, and spatial data. Add geographical information to business applications and build location-aware applications. Increase granularity of temporal data with date and time data types.

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.

Basic reporting services

Visualize data through basic Reporting Services (available with SQL Server Express with Advanced Services) and create readable reports that answer complex user questions. Enable users to share reports by using Microsoft Word and Microsoft Excel.

Simplify and speed development with rich developer tools

Take advantage of existing Transact-SQL skills, and incorporate technologies like Microsoft ADO.NET Entity Framework and LINQ. Develop applications faster through deep integration with Visual Studio, Visual Web Developer, and SQL Server Management Studio. Take advantage of rich table and query designers and drag-and-drop IDE support.

Embed lightweight database into basic desktop applications

SQL Server Express LocalDB is a lightweight deployment option for SQL Server Express with fewer prerequisites. This makes it ideal for developers who need an embedded SQL Server database for desktop applications or tools. LocalDB runs in-process with applications and not as a service.