View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. Hardware
June 7, 2016

Why SQL Server Express is a good fit for your workloads

A free version of one of the most popular database choices, but there are limitations.

By James Nunns

Microsoft’s SQL Server relational database is one of the most popular choices in the market, but as with all big technology choices there is complexity.

SQL Server is a relational database management that is used to manage and store information and SQL Server Express is a version of this that is free to download, distribute and use.

The free version is aimed at being used for embedded and smaller-scale applications and has many of the same features that are available in the paid, full version of the system but there are some differences.

In SQL Server 2014 the maximum database size is 10GB per database, in the 2008 version that is 4GB and in earlier versions it is 2GB.

In the free version there is no SQL Server Agent service and there are artificial hardware usage limits. In the free version a user can only have a single physical CPU but multiple cores and 1GB of RAM.

A typical use of the free version might be with a phone application that then synchronises with an online data source.

SQL Server Express is particularly well suited to smaller use cases given the limitations that are applied. Typical adopters of this version would be those that want database technology but do not feel that it is worth them paying for the big version.
The popularity of SQL Server Express has led to Microsoft adding it to its Azure cloud platform for customers to use it for testing, development, and monitoring management applications.

Content from our partners
Scan and deliver
GenAI cybersecurity: "A super-human analyst, with a brain the size of a planet."
Cloud, AI, and cyber security – highlights from DTX Manchester

The free version can be used with any web application framework such as PHP, and applications such as WordPress, and Drupal.

SQL Server Express supports the same T-SQL language that are found in SQL Server and users can issue data manipulation language queries against the database, in addition to running data definition language statements to create views, triggers, cursors and stored procedures.

Express also supports Full Text Search, native XML, and the SQL Common Language Runtime.

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how Progressive Media Investments may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.