Mark Breen
marklbreen at gmail.com
Mon Sep 19 17:57:29 CDT 2011
Hi John, Ok, sorry, when you mentioned Access I assumed that the db's were not too big. Can I throw a few things out, just in case they are useful for you? 1) I have been playing with Ubuntu recently and it is fun. 2) I successfully installed mySQL on Ubuntu over the weekend - I have more testing to do but for your client, that's all free and it is good software. 3) Once you get your mySql server up, you can do all the rest of your work in MS world, just use mySQL as your data store. No reason not to use VS2010 as your FE and mySQL as your BE. Do not be afraid of Ubuntu, it is not that difficult and weirdly, it is satisfying in a way that Win 98, Millennium , Vista, Office 97, VS 2003 (need I go on) can never be. Finally, I would adore to hear some results comparing your db between MS SQL and mySQL Mark On 19 September 2011 01:00, jwcolby <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@**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> > >