That's exactly the reason because I said that MS-SQL DBA are less professionals than Oracle ones. It's like when someone says that it masters MS Word or master Latex. Someone who says that masters Latex, really does. But there are a lot of people that are unable to use Word styles that say that master MS Word.
At the end, MS-SQL is very easy to admin. That's a problem! :) Regards, Jose Manuel Huerta http://theremedyforit.com/ On Fri, Sep 7, 2012 at 6:36 PM, Joe Martin D'Souza <jdso...@shyle.net>wrote: > ** > > What you probably mean is that it takes more than a few points and clicks > to do majority of the maintenance in Oracle while in MS-SQL, much of the > work can easily be done with a few points and clicks.. MS-SQL does have a > more user friendly GUI interfaces, which is possible to maintain without > the need of a full time DBA. So if you want to get rid of your dependence > on a DBA, MS-SQL may be a good way to go. This DB has got fairly robust > over time. A little less than 10 years ago, I wouldn’t be saying the same > thing.. > > Oracle however is one of the best DB’s that is capable of handling larger > data volumes more efficiently. Yes it has its drawbacks with case > sensitivity, but if that is not a major concern (because of the way your > foundation data might be set up), then it is undoubtedly a better DB with > slightly higher maintenance costs as it may require the need for a full > time DBA if your Remedy Admins or developers do not have those skills.. > > Joe > > *From:* Jose Manuel Huerta Guillén <arsl...@theremedyforit.com> > *Sent:* Wednesday, September 05, 2012 5:18 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Oracle vs. SQL > > ** > After dealing with MS SQL and Oracle, I can see two differences: > - MS SQL case insensitive is easier to achieve. > - Oracle admins are usually more "professionals" than MS SQL ones. This is > not a fact, but a probability I found at my experience. > > What it isn't true is that case insensitive can only be achieved in MS > SQL. I have an Oracle RAC configured for case insensitive and it performs > perfectly. > > So, at the end, it is more about organization culture and religion than a > technical decision. > > IMHO, I would choose MS SQL because the licensing cost. Invest the saved > license cost in hardware and admin, and the result would be better. > > Finally the decision between enterprise and standard depends on the size > of your ARS system. Normally the standard edition can fit for hundreds of > users. But It would depend on the use that those users made on the > database, and if the database server is to be shared with other > applications. Also it's important your DBA opinion, since the enterprise > edition has some features not available at the standard like increased > management or BI options > > Regards, > > Jose Manuel Huerta > http://theremedyforit.com/ > > > > > On Wed, Sep 5, 2012 at 11:06 PM, Thad Esser <thad.es...@gmail.com> wrote: > >> s me as funny criteria for determining which database to use, but I gues > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"