I had hoped that the Windows 2003 webedition would have included som kind of "MSSQL bundle" that I could have purchased for my non-profit initiatives. But no dice.
So what should I choose? MySql 4? or does anyone know that Microsoft will have some MSSQL pricing changes just around the corner?If history is any indication, pricing will go up ;-) There isn't a new version of SQL Server out for awhile yet. I'm not sure what the limitations are on the Small Business Server package, if that's even still around. That might be one way to go.
I agree SQL Server is expensive for a small shop because if you use it as a web backend, you pretty much have to buy the per processor license. and it isn't cheap. still if you want SQL Server features, you have to pay the cost. Oracle is even worse. Another option for you is to outsource your site (host it elsewhere). There are a number of hosts that offer SQL Server as an option that are fairly reasonable, see the ASP.NET ISPs forum for some suggestions.
cs|||Yup, it really isn't practical for a small shop to use SQL Server as a backend. MS doesn't come right out and say it, but if you read between the lines a per processor is really the only viable way to licenses SQL Server for a web app. If anyone knows of any wording in the faq to back this up please post it or link to it. Reading thru the faqs etc... on how to licenses SQL server is about as pleasurable as banging your head against a meat grinder.
MySQL might be the way to go. Heck, it is probably becoming a valuable skill to have anyway. But, if you do want SQL Server, just buy it now and then take advantage of upgrade pricing when the next version comes out.|||::Yup, it really isn't practical for a small shop to use SQL Server as a backend.
Why? I know LARGE shops running happily on MSDE. Frankly, the limitations in MSDE are not really a lot:
* 2Gb per database. Now, unless you store videos in the database, 2Gb is a LOT - even for a CMS this is quite an amount.
* 5 parallel queries. Read the fineprint. Now, this is quite a lot, too. With smart programming, intellitgent use of output caching and all the nifts things you should do anyway to keep your processor usage down, you can probably max out a dual processor system with this limit.
The small shop does really not need more. And IF he needs more, SQL Server is not expensive at all.
::MySQL might be the way to go.
Yes, unless you need - a databae. The limitations of MySQL are a little harsh at the moment.
::Heck, it is probably becoming a valuable skill to have anyway
I know a lot of people who value MySQL very high. NONE of them is anyone I would trust with more than a "Select * from table", knowledge wise, when I want database work to be done. MySQL is extreme in it's limitations.|||Read, Thona, Read
>> Yup, it really isn't practical for a small shop to use SQL Server as a backend.
(read: It's too expensive)
you reply: Why? I know LARGE shops running happily on MSDE.
??
makes no sense at all.|||MSDE != SQL Server, although I agree it is a valid alternative for some situations. But the original question was regarding SQL Server. There are some limitations on how you can use MSDE and be within licensing compliance.
from http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Q. Can I use MSDE as a database for Web applications?
A. MSDE is an ideal solution for low-end Web applications. The following products and services enable you to redistribute MSDE as a database server for Web applications:
ASP.NET Web Matrix*
MSDN Universal, Enterprise, and Professional subscriptions
Office XP Developer Edition
SQL Server 2000 Developer, Standard, and Enterprise Editions
Visual Studio .NET Architect, Developer, and Professional Editions
Visual FoxPro 7.0 or 8.0
* When obtained by downloading ASP.NET Web Matrix, MSDE is provided only for use in conjunction with an application developed by using ASP.NET Web Matrix.
cs
No comments:
Post a Comment