Microsoft is Expanding their SQL Server 2005 Product Line, with the introduction of SQL Server Workgroup Edition. These new price points are no doubt in response to open source database competitors such as MySQL and PostgreSQL.
Here's an overview of the SQL Server 2005 editions, and their pricing:
- Simple Management Tool
- Report Wizards & Controls
- Replication & SSB Client
- Replaces MSDE 2000
- Management Studio
- Limited Replication Publishing
- Backup Log Shipping
- Database Mirroring
- OLAP Server
- Reporting Server
- New Integration Services
- Data Mining
- Full Replication & SSB Publishing
- Advanced DB Mirroring
- Complete online and parallel operations
- DB Snapshot
- Advanced Analysis Tools OLAP, Data Mining
- Customized & High Scale Reporting
- Advanced SSIS
|Previous Prices||Free||N/A||$4,999 per processor or
$2,249 (server + 10 users)||$19,999 per processor or
$11,099 (server + 25 users)|
As you can see while the low end is easier to get into, but Microsoft has raised the prices on the high end (Standard and Enterprise versions of Microsoft SQL Server).
eWeek has also published an article on the new edition.
>>> what I never understood is the named user/device licensing in relation to web applications
If your app provides 'services and/or hosted applications' with MSSQL Server, then you'd need to look into the MS SPLA: Spervice Provider License Agreement
This license depends on the # of processors and the # of authenticated users. It's a monthly fee and you 'DO NOT' need to buy a copy of SQL Server, I was recently sent this quote:
For an unlimited number of anonymous users, each month you would report:
Windows Srv Std Unauthenticated Processor License is $18/mo
SQL Std Processor License is $169/mo
For a two Processor box:
2x $18 win
2x $169 Win
and MSSQL 2000 = $4,999 per processor
2 processors = $9,998 which is a bit more than $4,488
I suggest contacting MS, the representative I spoke with was helpful, and responded very fast.
As to the real subject of this blog posting...
I think it's excellent that they are making these kinds of moves and expanding the line.
If you are going to run a Web service of any type... you'll have to get this SPLA, which I believe will give you the "Standard" edition. Based on those 2005 prices - you'd pay less with the SPLA if you are running a CF site with MSSQL 2005 on a dual processor where your users are not being authenticated by MS software/system.
It's worth looking into.
Sorry I babbled so long :)