SQL Server 2005 Express Edition

SQL Server Express is a version of SQL Server 2005 is the evolution of MSDE 2000 in SQL Server 2005 It is a free, easy to use, and lightweight version of SQL Server 2005, designed for building simple, dynamic applications.

SQL Server Express helps developers build robust and reliable applications by providing a powerful database that is also free and easy to use. Too often database systems are overly complex for building simple applications. SQL Server Express and the other Express products reduce this complexity by providing a simple but powerful development environment for building data-driven applications. You can design schemas, add data, and query local databases, all inside the Visual Studio 2005 environment. If you need more advanced database features, then SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.

Download is from here

SQL Server ExpressExpress ManagerDeployment

A robust database for building dynamic applications

  • Based on the core SQL Server 2005 Database Engine, including an advanced query optimizer and the new snapshot isolation level
  • Supports the complete SQL Server programming model including T-SQL and CLR integration
  • Standard SQL Server objects such as stored procedures, views, triggers, and cursors
  • Client (Subscription-only) replication and support for the new Service Broker features

Strong XML support

  • Native XML data type
  • Supports structured and semi-structured data
  • XQuery support
  • XML Schema support

Tools and features to enhance management and ease of use

  • Automated tuning of database parameters based on usage characteristics
  • Express Manager (coming soon) will provide wizards for many common tasks
  • Comes with Computer Manager for starting and stopping the SQL Server Express Windows service
  • Automated servicing and patching (as part of Microsoft Update)
  • XCopy deployment with administrator privileges (non-admin support in Beta 3)
  • Simplified documentation helps you easily build dynamic applications using relational databases

Easy installation and setup

  • Fast download
  • Simplified user interface for setup
  • Silent install for embedded usage

Scalability and performance

  • Supports 1 CPU, but can be installed on a server with any number of processors
  • Maximum 1 GB addressable RAM
  • Maximum 4 GB database size

Deep integration with Visual Studio 2005

  • Installed with Visual Studio 2005
  • Takes advantage of Visual Studio Data Explorer for designing schema, adding data, and querying local databases
  • CLR integration
  • Supports user-defined types and aggregates
  • In-process data access with ADO.NET 2.0
  • Integration of SQL Server and CLR security
  • Integrated debugging

Robust security

  • Secure by default settings
  • Fine-grained administration rights
  • Three levels of code access security: Safe, External Access (verifiable), and Unsafe
  • Supports leveraging stored procedures as an abstraction layer
  • Support for Windows authentication

No Comments