Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database
    • Development

    SQL Server 2005 Options

    By
    Michael Caton
    -
    December 5, 2005
    Share
    Facebook
    Twitter
    Linkedin

      A major change since SQL Server 2000 is the introduction of the free Express version of SQL Server 2005, designed for smaller-size database applications and to spur developer interest.

      Oracle recently introduced a beta of its own free offering, the forthcoming Oracle Database 10g Express Edition.

      In addition to spurring developer interest, the free version is intended to interest developers who would otherwise use less expensive open-source database alternatives, Oracle officials have said.

      Both Microsofts and Oracles express editions can use only a single CPU, limit database size to 4GB and support only up to 1GB of memory, making them suited only for development of very lightweight applications.

      /zimages/4/28571.gifClick here to read more about SQL Server 2005 from columnist Charles Garry.

      Microsoft has offered a free version of SQL Server designed for desktop applications in MSDE (Microsoft SQL Server 2000 Desktop Engine).

      SQL Server 2005 Express Edition replaces MSDE. IBM offers a comparable Personal Edition of DB2 Universal Database V8.2 for $369.

      Despite the pricing discrepancy between Microsofts and IBMs basic offerings, SQL Server 2005 and DB2 are very comparable on a list-price basis and are considerably less expensive than Oracle Database 10g.

      In the SQL Server 2005 family itself, there are substantial differences among the three server versions: Workgroup Edition, Standard Edition and Enterprise Edition.

      The Workgroup Edition is priced at $3,899 per processor or $739 for a server with five CALs (client access licenses).

      The Workgroup Edition supports a maximum of two processors and up to 3GB of memory.

      Furthermore, the Workgroup Edition has a limited feature set, forgoing capabilities such as partitioning, failover clustering, fast recovery and database tuning.

      Priced at $5,999 per processor or $1,849 per server with five CALs, the Standard Edition sacrifices some features found in the Enterprise Edition, including fast recovery, online indexing and partitioning.

      The Standard Edition also limits processor support to four CPUs. Like the Enterprise Edition, the Standard Edition fully supports 64-bit Windows, as well as failover and database tuning.

      The Enterprise Edition costs $24,999 per processor or $13,969 for a server and 25 CALs.

      With the Developer Edition of SQL Server 2005, Microsoft allows customers and developers to run copies of SQL Server for development purposes without incurring a license fee. The Developer Edition includes a copy of the Enterprise Edition.

      SQL Server 2005 Mobile Edition replaces SQL Server CE 2.0 and supports SQL Server 2000.

      Licensing is covered through the device CAL. Using SQL Server 2005 Mobile Edition, developers can create applications for the PDA and smart-phone versions of Windows—Windows CE 5.0, Windows Mobile 2003 Software for Pocket PC and Windows Mobile 2003 Software for smart phones.

      SQL Server 2005 Mobile Edition also covers applications written for Windows XP Tablet PC Edition. Standalone applications written in Mobile Edition dont require a CAL.

      /zimages/4/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Michael Caton
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×