Mark Breen
marklbreen at gmail.com
Mon Sep 26 05:23:57 CDT 2011
Hi John, >Are you experienced enough you could do this for me? I am definitely not. I can muddle through the same as you, but I am only a few hours in to really playing with Ubuntu. Since I have been working on DNN and thinking about Open source concepts, I have come to like the concept. I hope I can learn more of Linux. I do not think it is too late for us. In fact, an earlier might have been too early. Mark On 20 September 2011 12:40, jwcolby <jwcolby at colbyconsulting.com> wrote: > Mark, > > > > 1) I have been playing with Ubuntu recently and it is fun. > > I am trying to install Ubuntu on a VM and it is not fun (and I haven't > succeeded yet). The SuSE install mostly just went, although in the end I > was unable to get the tools installed for the virtual machine. Ubuntu must > have asked a dozen questions in the first 2 minutes. Unfortunately when you > are installing on a VM trying to answer those questions is an awkward > sequence of tabs and enters and more tabs and enters etc to position the > cursor in the right place, select text boxes etc. Even then, after I > managed to break the virtual disk into two partitions and tell it to use the > first, it told me I had to go make one of them the system partition or > something like that. > > <rant mode> > > *JUST DO IT* > > It is precisely this geeky stuff that drives us nubees away. I am trying > to get the big picture done, not set partitions to system. > > </rant mode> > > So I still have no linux vm to play with. > > I assume I could probably set up Linux on a real physical box, it is just > the added complexity of the vm that stops me dead. And I have built at > least a dozen Windows VM guests, truly click click done. > > Are you experienced enough you could do this for me? > > > John W. Colby > www.ColbyConsulting.com > > On 9/19/2011 6:57 PM, Mark Breen wrote: > >> 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@**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>< >>> 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> > >