Arthur Fuller
fuller.artful at gmail.com
Wed Sep 21 12:40:43 CDT 2011
Stick with what you know, until and unless you have learned something new. I love Linux and more specifically Ubuntu 11.04, and on this VM I run this baby and OpenOffice and Base (not quite an Access clone but not bad). VMs are the safe way to play, IMO. Have tried lots of them and have succeeded in protecting my main squeeze, which is what it's all about. I can't help experimenting. That's just my nature. But I also like to wear a jock-strap just in case. Hence my preference for VMs, safe sandboxes that cannot fork with my main squeeze, Call me a pussy but over lo these many years I have learned that you cannot, cannot, cannot, fork with my home-baby. Sandboxes are us, as it were. If and when it proves interesting, I might promote you to home, but not unless and until. Too much acid on my face for me to choose any other alternative. Arthur > ing.com <http://colbyconsulting.com><jwcolby@**colbyconsulting.com<jwcolby at colbyconsulting.com> >>>> >> >>>> wrote: >>>> >>>> Mark, >>>> >>>>> >>>>> The reasons are exactly what Jim mentioned. The client currently has >>>>> around 5 gigs of data, or at least their mdb containers are around that >>>>> size. >>>>> >>>>> The free SQL Server express has the following limitations: >>>>> >>>>> 1) 10 gb file size >>>>> 2) 1 core maximum >>>>> 3) 1 gig ram maximum >>>>> >>>>> And the client has: >>>>> >>>>> 4) Serious money constraints today. >>>>> >>>>> SQL Server Express 2008 is just fine for a small database with a hand >>>>> full >>>>> of users but this is a fairly serious call center app, with 25 users in >>>>> the >>>>> database all the time. It just feels like a single core and a single >>>>> gig >>>>> is >>>>> starting with serious limitations. >>>>> >>>>> He was "written a check" for $2K for purchasing a new server to take >>>>> him >>>>> into the future. I proposed $2400 for a "roll your own" 8 core AMD >>>>> 6128 >>>>> and >>>>> 16 gigs of ram, a modern 8 port Areca raid controller and 3X 120g hard >>>>> drives. He went back to the controller and got $3K. With that he >>>>> added >>>>> 5X >>>>> 1 tb drives to build out some real storage for the company. They have >>>>> always had old ebay Dell servers with too little memory and too little >>>>> storage. Always trying to shuffle things around to free up room. >>>>> >>>>> We are actually looking at starting with Windows XP X64 as the OS on >>>>> this >>>>> (otherwise) entirely modern system. If it works that gets rid of the >>>>> "$X >>>>> per seat" for something like Windows 2008. If we can use MySQL on that >>>>> with >>>>> let's say 6 cores and 12 gigs of ram and a 60 gig SSD partition for the >>>>> database files he could have a fairly serious system for his company >>>>> size. >>>>> >>>>> Windows 2008 and SQL Server 2008 together were going to cost him around >>>>> $10K just for those two things. While we may go there next year or the >>>>> year >>>>> after, I want to get him moving now. We have been stuck in neutral and >>>>> rolling backwards for too long. >>>>> >>>>> >>>>> John W. Colby >>>>> www.ColbyConsulting.com >>>>> >>>>> On 9/18/2011 11:24 AM, Mark Breen wrote: >>>>> >>>>> Hello Jim / Arthur >>>>> >>>>>> >>>>>> Thanks for that analysis, quite accurate. >>>>>> >>>>>> Mr Colby, just a question, why are you not advising your client to use >>>>>> the >>>>>> free MS SQL express R2. I use it all the time and PowerDNN use it on >>>>>> all >>>>>> there servers that host 100,000 DNN installations. All free db's. >>>>>> That >>>>>> is >>>>>> not to be sniffed it. And there are loads of tools to help with the >>>>>> enterprise tools that Express does not ship with. (Note: the free >>>>>> version >>>>>> does give you SSMS) >>>>>> >>>>>> Mark >>>>>> >>>>>> ______________________________******_________________ >>>>>> >>>>> dba-SQLServer mailing list >>>>> dba-SQLServer@****databaseadviso**rs.com<http://**databaseadvisors.com<http://databaseadvisors.com> >>>>> >< >>>>> dba-SQLServer@**databaseadviso**rs.com <http://databaseadvisors.com>< >>>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>>> > >>>>> >>>>>> >>>>>> http://databaseadvisors.com/******mailman/listinfo/dba-**sqlserver<http://databaseadvisors.com/****mailman/listinfo/dba-sqlserver> >>>>> <http://**databaseadvisors.com/****mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver> >>>>> **> >>>>> **<http://databaseadvisors.**com/**mailman/listinfo/dba-**sqlserver<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver> >>>>> <http://**databaseadvisors.com/mailman/**listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>>> > >>>>> **> >>>>> http://www.databaseadvisors.******com<http://www.**databaseadv** >>>>> isors.com <http://databaseadvisors.com><http://www.** >>>>> databaseadvisors.com <http://www.databaseadvisors.com>> >>>>> >>>>>> >>>>>> >>>>> >>>>> ______________________________****_________________ >>>>> >>>> dba-SQLServer mailing list >>>> dba-SQLServer@**databaseadviso**rs.com <http://databaseadvisors.com>< >>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>> > >>>> http://databaseadvisors.com/****mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver> >>>> **<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>> **> >>>> http://www.databaseadvisors.****com<http://www.**databaseadvisors.com<http://www.databaseadvisors.com> >>>> > >>>> >>>> >>>> ______________________________****_________________ >>>> >>> dba-SQLServer mailing list >>> dba-SQLServer@**databaseadviso**rs.com <http://databaseadvisors.com>< >>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>> > >>> http://databaseadvisors.com/****mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver> >>> **<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>> **> >>> http://www.databaseadvisors.****com<http://www.**databaseadvisors.com<http://www.databaseadvisors.com> >>> > >>> >>> >>> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> >> ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >