Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Opportunities with SQL Server 2005 Express Edition


By:   |   Read Comments   |   Related Tips: 1 | 2 | 3 | More > Express Edition

Problem
Have you heard of the SQL Server 2005 Express edition, but not sure where it fits into your overall architecture?  Are you concerned it is too constraining and will not meet your business needs?  Are you looking for ways to continue to use SQL Server in niche capacities?  Are you trying to balance distributing your applications without causing a future server consolidation project?  If so, this tip will outline the opportunities with SQL Server 2005 Express edition in addition to considerations when adopting this version of SQL Server 2005.

Solution
SQL Server 2005 Express Edition offers a unique opportunity to meet database management needs, but should be analyzed properly to ensure the overall architecture is the correct solution from both a development and operational perspective.  As you evaluate and adopt this technology be sure to think about:

  • Development capabilities
    • Ensure the platform contains all of the functionality as compared to other SQL Server versions
  • Operational considerations
    • Keep in mind the operational costs to implement, support and troubleshoot
  • Licensing costs
    • Windows, backup products, monitoring products, etc.
  • Infrastructure costs
    • Hardware, racks, storage, power, etc.

Capabilities

The SQL Server 2005 Express Edition supports the following capabilities:

  • CPU quantity - 1
    • Express can be installed on a multi CPU machine
  • Max database size - 4 GB
  • Memory - 1 GB
  • Query governor - None
  • Users - Unlimited number
  • Environments - Production, test and development
  • Features - Relational Engine, Full Text Search, Reporting Services
  • Scheduling - SQL Server Agent is not supported by Express Edition, but a Free Job Scheduling Tool for SQL Server Express and MSDE is available to meet this need
  • Management tools - Independent Express Edition tool set and support with Management Studio from the Standard Edition
  • Additional information - Check out the Express Edition feature list

Opportunities

Depending on your organization, SQL Server 2005 Express Edition can be leveraged in a variety of ways.  Below outlines some general applications were the Express Edition, can be used, but the sky is the limit and think creatively on how this edition can be used in your organization. 

  • Distributed applications
  • Utility applications
  • Kiosk applications
  • Mobile sales applications on a laptop
  • Hosted applications requiring data collection
  • Meta data support for custom reporting applications

Considerations

Although the Express Edition offers a unique set of features at a very reasonable licensing cost, be sure think about the following considerations for your application:

  • Keep it simple, do not feel like you need to implement technology for the sake of the technology, be sure to meet the business need first and then expand
  • Do not set yourself up for distributing the application unnecessarily where you are going to have to go through a server consolidation process in the future, because the cost of building the application and then consolidating can be a much larger cost than the SQL Server licensing cost for another edition of SQL Server which is a common driver to move to the Express Edition
  • Keep in mind that if you have an existing SQL Server you can continue to add databases and\or instances depending the current capacity
  • Be sure to evaluate all costs related to the architecture including Windows licensing, backup applications, implementation, support, troublehsooting, etc.

Express Downloads

Follow the links below to obtain your copy of SQL Server 2005 Express Edition:

Next Steps



Last Update:






About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an Edgewood Solutions SQL Server Consultant, MSSQLTips.com co-founder and Baltimore SSUG co-leader.

View all my tips


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools