[dba-SQLServer] [AccessD] MySQL

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>
>
>



More information about the dba-SQLServer mailing list