|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Sql better than Oracle?
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
Search on google Show quote "Paulo" <prbs***@uol.com.br> wrote in message news:O1S98tbMIHA.4308@TK2MSFTNGP05.phx.gbl... > Any articles? Comparisons? > Paulo,
I prefer SQL Server for a lot of reasons, but (just so that you know what they say) here is Oracle explaining why they are so much better. http://www.oracle.com/technology/products/database/oracle10g/pdf/cwp_general_o10g-vs-ss2k.pdf I have a few friends working in Oracle shops after working with Microsoft SQL Server and they (like I) much prefer SQL Server. (But remember, this is a SQL Server newsgroup. If you ask in an Oracle newsgroup I expect you will get a different opinion.) RLF Show quote "Paulo" <prbs***@uol.com.br> wrote in message news:O1S98tbMIHA.4308@TK2MSFTNGP05.phx.gbl... > Any articles? Comparisons? > > I prefer SQL Server for a lot of reasons, but (just so that you know what Please, tell me some reasons.Thanks for the pdf ! 1) Money
Show quote "Paulo" <prbs***@uol.com.br> wrote in message news:uXVtevcMIHA.2208@TK2MSFTNGP06.phx.gbl... >> I prefer SQL Server for a lot of reasons, but (just so that you know what > > Please, tell me some reasons. > > Thanks for the pdf ! > Paulo,
Yes, as Uri mentions, cost is one factor. Also, MSSQL is much more automated in handling standard DBA type tasks, freeing time for working on the non-standard tasks that always come up. (I am not up-to-date on the latest Oracle versions, but I believe this to still be true.) RLF Show quote "Paulo" <prbs***@uol.com.br> wrote in message news:uXVtevcMIHA.2208@TK2MSFTNGP06.phx.gbl... >> I prefer SQL Server for a lot of reasons, but (just so that you know what > > Please, tell me some reasons. > > Thanks for the pdf ! > Hi Paulo,
Here is a white paper by David Litchfield from Next Generation Security Software comparing the numbers of security flaws identified by external security researchers and subsequently fixed by Oracle and Microsoft in regard to their database products: http://www.ngssoftware.com/research/papers/comparison.pdf And here are the results from a study by the Enterprise Strategy Group: http://www.darkreading.com/document.asp?doc_id=110881&WT.svl=news1_3 I have worked for a few years on parallel projects with Oracle, DB2, SQL Server, and some other DB products. My observation has been that Oracle was more demanding (and unnecessary complex) for administration. Also, it required more expensive hardware (but nowadays if you want to have a powerful SQL Server you need to invest too). It is a bit subjective to say, but I had a team of 10 developers working on Oracle project (there was even a person who worked for Oracle on the DB engine development) and another team of 3 developers working on SQL Server project. Both projects had similar scope and workload, but we were seeing more progress and better results from the SQL Server project... Also, for Microsoft platforms SQL Server integrates much better with other MS technologies and tools. And as Russell said, you should ask for opinion from different places to gather better info. HTH, Plamen Ratchev http://www.SQLStudio.com Thanks to all!
Nice explanations! Show quote "Plamen Ratchev" <Pla***@SQLStudio.com> escreveu na mensagem news:eZw3XPdMIHA.5988@TK2MSFTNGP02.phx.gbl... > Hi Paulo, > > Here is a white paper by David Litchfield from Next Generation Security > Software comparing the numbers of security flaws identified by external > security researchers and subsequently fixed by Oracle and Microsoft in > regard to their database products: > > http://www.ngssoftware.com/research/papers/comparison.pdf > > > And here are the results from a study by the Enterprise Strategy Group: > > http://www.darkreading.com/document.asp?doc_id=110881&WT.svl=news1_3 > > > I have worked for a few years on parallel projects with Oracle, DB2, SQL > Server, and some other DB products. My observation has been that Oracle > was more demanding (and unnecessary complex) for administration. Also, it > required more expensive hardware (but nowadays if you want to have a > powerful SQL Server you need to invest too). It is a bit subjective to > say, but I had a team of 10 developers working on Oracle project (there > was even a person who worked for Oracle on the DB engine development) and > another team of 3 developers working on SQL Server project. Both projects > had similar scope and workload, but we were seeing more progress and > better results from the SQL Server project... > > Also, for Microsoft platforms SQL Server integrates much better with other > MS technologies and tools. > > And as Russell said, you should ask for opinion from different places to > gather better info. > > HTH, > > Plamen Ratchev > http://www.SQLStudio.com > >  |
|||||||||||||||||||||||
Other interesting topics