SQL Server Workgroup Edition


If you have not heard already Microsoft has announced a new version of SQL Server 2000 and 2005.  The new version, SQL Server Workgroup Edition fills a hole that lots of Visual Basic developers and consultants have run into. 

With Visual Basic you can build data-driven application against MSDE for small to mid-size companies on a fixed budget, however there was a bit of sticker shock when you wanted to scale up to SQL Server Standard and purchase licenses.

SQL Server Workgroup provides a step in between at a much more affordable price to many smaller clients you might have.  It also works great if you are building application for a department or work group inside of a larger company but don't need the power of SQL Standard but hate the performance restrictions of MSDE.

Read about it here.


Comments (5)

  1. Bill Vaughn says:

    I think the Workgroup Edition is a welcome addition to the family. However, I don’t see the Developer Edition. IMHO leaving out this ($49) version for developers is a big mistake. I’ll revisit this opinion once the “real” version of the SQL Express Manager shows its face. So far, it does not have the features developers need to get the job done.

    I’ve been interviewing and working with MSDE customers for some time and find that virtually none of them “hate the performance”. I have had very (very) few of them tell me that the governor was an issue. It seems that today developers are smart enough to know how to use a “small” engine to get the work done without melting down the cylinder-head by over-revving.

    Sure, MSDE is limited, but the fact that SQL Server Standard (and now Workgroup) is there if they ever grow into it is what attracts them to the Microsoft solution.

    Bill

  2. yoshi says:

    Hi Brad,

    How wonderful the Workgroup Edition is!

    In the press release, you said that Workgroup Edition support up to 2Gbytes memory. It seems that the information is both for SQL Server 2000 and 2005 Workgroup Edition.

    The document you suggested in your comment, Mr.Tom Rizzo said "SQL Server 2000 Workgroup Edition supports up to 2 CPUs, 2 gigabytes of memory". But in his presentation, he said SQL Server "2005" Workgroup Edition support up to 3Gbytes memory.

    How much memory does the SQL Server 2005 Workgroup Edition support?

  3. Brad McCabe says:

    SQL Server 2005 Workgroup supports up to 3GB of RAM. For a side by side listing see http://www.microsoft.com/sql/spotlight/expandsqlserver.asp. There is a graphic about half way down the page that puts them side by side.

  4. yoshi says:

    Thank you, Brad!

Skip to main content