Jim Lawrence
accessd at shaw.ca
Mon Jun 22 22:46:51 CDT 2009
Hi Darryl: I would say that I am more of an expert in Oracle than MS SQL. I really like MS SQL but to find meaningful work in an Oracle town is difficult to say the least. After working on a MS SQL project for almost 5 years it was cancelled without comment, other than "We need to standardize" and replaced with Oracle. I have worked full-time on Oracle support and have taken courses in Oracle 10 and 11i. They are both excellent products. MS SQL is more automated while Oracle can really be hacked and patched. There a lot more work in Oracle as far as I can see and when you become certified in the product starting wage is 60K up to 120K for senior techs (5 years). And in free-lance work you can make a lot more. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Monday, June 22, 2009 4:14 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net "Why SQL Server and not Oracle?????" aaaakkkkkgh... For lotsa techie info on why what where and who, Google " Oracle vs SQL Server" For me, it is sheer ease of use, and the fact that SQL Server logic largely makes sense where as Oracle (like the name suggests) seems to involve elements of faith or belief (or disbelief - IMHO of course). For example the Oracle NULL seems gibberish to me: For example: "Though common sense leads us to conclusion that a basket with one apple is clearly different from a basket without apples, in Oracle they are not different. So the empty basket is not different from a non-empty one, but then again, they are also not the same. Putting all that in one sentence, the empty is not equal to anything, nor different from anything, including nothing. It is a bit painful, isn't it? In theory, any binary operation involving NULL will also give NULL, but even that is not consistent. Add NULL to 1 and you will get NULL, but concatenate NULL to 'Donald' and you will get 'Donald'. NULL and empty string, as far as Oracle is concerned, are the same (but then again, not equal). And, to make things worse, there are EMPTY_CLOB and EMPTY_BLOB. Clobs and Blobs are strange enough for themselves, but EMPTY versions exist only to make our life harder." - From http://www.orafaq.com/node/1023 uh huh... make a lot sense? I didn't think so... Besides you can download, install and run SQL Server Express 2008 for free - and my word, what a fantastic product it is. Sure it is missing a few bells and whistles that the enterprise version has, but for most folks doing database stuff it has plenty of grunt under the hood. Rock solid, easy to integrate into existing Excel and Access Front ends and frankly a joy to use. It also runs great on low specced PC's. I have it installed on my Dell Lattitude D600 which is years old now (2GB RAM on XP Pro), and SQL Server just sings along. Process data much faster than having an Access BE - I was suprised, but the speed and stability speak for themselves. As for Oracle - well, I am note quite a member of the "I Hate Oracle" club, but one does exist. And the computer science guy I sit next to at work can give you plenty of reasons why Oracle stinks if you want me to press him on it. :) cheers Darryl. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com