Jim Lawrence
accessd at shaw.ca
Sun Sep 18 15:49:29 CDT 2011
Hi Mark: The old 4GB to 10GB data limit depending on which version you have access to; only uses one of GB of RAM max and one CPU. If the client is not using a application that is data or user heavy then MS SQL Express is an excellent choice. Otherwise it is either the serious options like MS SQL or Oracle (I personally like these beast but not many smaller businesses seem willing to anti-up) or some of the low cost alternatives which can support all the way up to heavy load enterprises. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Sunday, September 18, 2011 8:24 AM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] [AccessD] MySQL 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 On 18 September 2011 07:01, Jim Lawrence <accessd at shaw.ca> wrote: > Postgesql and Postgres Plus are the heirs apparent. They can now do what > MySQL will ever be allowed to do and that is become an enterprise database. > Oracle has no intention of building a free competitor. > > Read more: http://www.postgresql.org/, > http://en.wikipedia.org/wiki/PostgreSQL and > > http://www.enterprisedb.com/products-services-training/products/postgres-plu > s-advanced-server > > There are lots of documents and samples and the product is very stable. > There has been a lot of excitement with the latest versions. > > Jim > > > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur > Fuller > Sent: Saturday, September 17, 2011 6:53 PM > To: Discussion concerning MS SQL Server > Subject: Re: [dba-SQLServer] [AccessD] MySQL > > There are some nice things about MySQL but on the other hand I definitely > do > not like where Oracle is going with this puppy since its acquisition of Sun > and by inheritance MySQL. I'm still on the fence about these developments, > but quite frankly I am leaning against Oracle on all these transmutations > of > what was originally a simple, straightforward approach. At last > recollection, Monty has departed, and with him, I fear, has the guiding > vision of this product. > > Frankly, I am all over the place on where next to go: I look at Mongo and > see it exquisite for web-apps but not for OLTP situations. I look at > PostGreSQL and think it's got a bunch of things right. I look at Oracle and > MS-SQL and think they have some things right as well. I frankly do not have > any clue into which basket to toss my next eggs. > > Arthur > > On Sat, Sep 17, 2011 at 7:51 PM, Stuart McLachlan > <stuart at lexacorp.com.pg>wrote: > > > I run MySQL locally as part of a WAMP installation and remotely on our > > FreeBSD servers. > > > > I use phpMyAdmin for all the administration. It's a very intuitive > > interface. > > > > It's possibly worth installing WAMP just for the phpMyAdmin. > > > > -- > > Stuart > > > > > > On 17 Sep 2011 at 19:24, jwcolby wrote: > > > > > For now I have to figure out how to create a database. Is it the same > > > concept as SQL Server? A file or set of files where tables, indexes, > > > views etc are stored? I assumed there would be some visual designer > > > that would allow me to create the db, then tables etc. It looks like > > > that stuff is in "SQL Development". > > > > > > This thing looks pretty nice, but very different on the surface. > > > > > > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com