InfoQ

News

SQL Server 2008 Express Series Is Available

Posted by Abel Avram on Aug 27, 2008 04:03 AM

Community
.NET
Topics
Data Access ,
SQL Server
Tags
SQL Server 2008 ,
SQL Server Express

Microsoft has made available three versions of SQL Server 2008 Express. Express editions are free versions of SQL Server intended for leaning or building small server applications, or for ISV redistribution. The Tools edition contains the Management Studio, while the Advanced Services edition has full-text search and Reporting Services.

SQL Server 2008 Express is described by Microsoft as following:

Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores. SQL Server 2008 Express is available at no cost, and you are free to redistribute it with applications.

SQL Server 2008 Express with Tools contains the same database engine as the Express edition, but has the additional Management Studio Basic which is a graphical server management tool.

SQL Server 2008 Express with Advanced Services has the following features, according to Microsoft:

  • SQL Server database engine.
  • Manage and administer SQL Server 2008 Express with a graphical management tool - Management Studio Basic.
  • Issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.
  • Run SQL Server Reporting Services reports on local relational data.

Using SQL Server 2008 Express editions with Visual Studio 2005 requires Visual Studio 2005 Support for SQL Server 2008 CTP, and the Release Notes should be carefully read before using an Express edition with Visual Studio 2008.

The Express editions can be downloaded and used for free from the following links: SQL Server 2008 Express, SQL Server 2008 Express with Tools, SQL Server 2008 Express with Advanced Services. More information is available on Microsoft's SQL Express page.

Related Sponsor

Red Gate Software makes ingeniously simple tools for over 500,000 SQL Server and .NET professionals.

No comments

Watch Thread Reply

Educational Content

Bindings, Platforms, and Innovation

This presentation focuses on the Internet and separating myth from fact, history from the future, and the mundane from the imaginative. Bob Frankston presents a vision of what could and should be.

  •  Jul 02, 2009,
  •  

Orchestrating Long Running Activities with JBoss / JBPM

This article explores the use of JBoss and jBPM to implement design solutions that effectively address the issue of orchestrating long running activities.

  •  Jul 01, 2009,
  •  

Neo4j - The Benefits of Graph Databases

This presentation covers the use of graph databases as an optimal solution for data that is difficult to fit in static tables, rapidly evolving data or data that has a lot of optional attributes.

Realistic about Risk: Software development with Real Options

This session introduces Real Options and shows how it can help in running your project. Real Options is a decision-making process that can be used to manage risk.

  •  Jun 30, 2009,
  •  

Communication Flexibility Using Bindings

This article discusses the use of bindings on services and references (including the instance of non-configured bindings) as the means to implement SCA communications in a Web and SOA environment.

  •  Jun 30, 2009,
  •  

Writing DSLs in Groovy

After a short introduction to DSLs, Scott Davis plays with the keyboard showing how to approach the creation of a DSL by typing working snippets of Groovy code that get executed.

Scaling Agile with C/ALM (Collaborative Application Lifecycle Management)

IBM Rational and InfoQ present, Scaling Agile with C/ALM, an eBook showing organizations how to become “finely tuned software delivery machines” by enabling team integration and scaling.

Concurrent Programming with Microsoft F#

Amanda Laucher presents a real life enterprise application written in F#. She shows actual code snippets, explaining design decisions and suggesting how to use some of the F# constructs.